Alerting

how to get list of alerts which are disabled within 24 hours

chandanjaisal
Explorer

I have couple of alerts, among of these alerts some of alerts are disabled. Some of alerts are disabled a week ago, some of alerts are disabled within last 24 hours, I need list of that alert which are disabled within 24 hours only.

Tags (2)
0 Karma
1 Solution

woodcock
Esteemed Legend

You get the list of alerts like this:

|rest/servicesNS/admin/search/saved/searches | search disabled=1 | table title | outputlookup mylookup

You run this as a saved search every 24-hours and use outputlookup to save the results. You also save a similar search to run just before the first one that uses inputlookup and compares the 2 looking for new entries and ignoring old entries like this:

|rest/servicesNS/admin/search/saved/searches | search disabled=1 | table title | eval type="new" | append [|inputlookup mylookup | eval type="old]" | stats values(type) AS types BY title | where types!="old"

View solution in original post

woodcock
Esteemed Legend

You get the list of alerts like this:

|rest/servicesNS/admin/search/saved/searches | search disabled=1 | table title | outputlookup mylookup

You run this as a saved search every 24-hours and use outputlookup to save the results. You also save a similar search to run just before the first one that uses inputlookup and compares the 2 looking for new entries and ignoring old entries like this:

|rest/servicesNS/admin/search/saved/searches | search disabled=1 | table title | eval type="new" | append [|inputlookup mylookup | eval type="old]" | stats values(type) AS types BY title | where types!="old"

View solution in original post

chandanjaisal
Explorer

Hi Woodcock
Can we merge these two search

0 Karma

woodcock
Esteemed Legend

Possibly but I think it would be highly inadvisable.

0 Karma
.conf21 Now Fully Virtual!
Register for FREE Today!

We've made .conf21 totally virtual and totally FREE! Our completely online experience will run from 10/19 through 10/20 with some additional events, too!