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' ) |