About icenitesh

icenitesh · ‎01-14-2021

Thanks a lot for the reply. One final help.. Can we place 2 where clause in the query ? Like if difference is > 60% and SSO_Initiated > 100 . Because even if the failure is 1, it becomes 100% failure. so want to have minimum count as 100 before difference is calculated.

icenitesh · ‎01-11-2021

and how do we check if the Difference is 60% of the SSO Initiated?

icenitesh · ‎01-11-2021

I have a below query where i search two text field and see how many time each occurred and find the difference. ("SSO Initiated" OR "SSO Completed") | stats count(eval(searchmatch("SSO Initiated"))) as SSO_Initiated count(eval(searchmatch("SSO Completed"))) as SSO_Completed | eval Difference=SSO_Initiated-SSO_Completed I want to create alert if Difference > 20, then mail needs to be sent. This check should keep happening every 15 minute and check in last 15 minute if Difference > 20, then trigger mail.

icenitesh · ‎01-11-2021

("SSO Initiated" OR "SSO Completed") | stats count(eval(searchmatch("SSO Initiated"))) as SSO_Initiated count(eval(searchmatch("SSO Completed"))) as SSO_Completed | eval Difference=SSO_Initiated-SSO_Completed I want to create alert if Difference > 0, then mail needs to be sent. This check should keep happening every 15 minute and check in last 15 minute if Difference > 0, then trigger mail.

Posts	4
Solutions	0
Karma Given	0
Karma Received	0
Member Since	‎01-11-2021

Online Status	Offline
Date Last Visited	‎01-15-2021 03:49 AM

How to alert when difference in count of two query...

Re: How to alert when difference in count of two q...

Re: How to alert when difference in count of two q...

How to alert when difference in count of two query...

How to alert in Difference in count of two search ...