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

[chandanjaisal]

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.

[woodcock · Accepted solution]

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"

[chandanjaisal]

Hi Woodcock
Can we merge these two search

[woodcock]

Possibly but I think it would be highly inadvisable.