Create alert for long running query from the logs in Kibana alert

Need to get alerted if the time difference between these below two log event is more than 10 mins, Kindly provide some hint to do this Alerts / watcher in Kibana.

@timestamp DatabaseName UserName ServerName Duration Completed State Id Type StartTime EndTime Query
Aug 9, 2022 @ 13:46:37.316 db_1 ab112233 test_1 26,538 TRUE OK 2050 endRequest Aug 9, 2022 @ 09:46:02.494 Aug 9, 2022 @ 09:46:29.032 SELECT prjt_id FROM prj_cyle_time where prjt_id = '10' context ('i18n' = 'us_est' )
Aug 9, 2022 @ 13:46:05.310 db_1 ab112233 test_1 0 - - 2050 startRequest Aug 9, 2022 @ 09:46:02.494 - SELECT prjt_id FROM prj_cyle_time where prjt_id = '10' context ('i18n' = 'us_est' )

This topic was automatically closed 24 days after the last reply. New replies are no longer allowed.