topic Re: List or View Scheduled searches in Splunk Search

List or View Scheduled searches

DavidHourani — Fri, 22 Jan 2016 14:08:32 GMT

Hello,

Does anyone have a search command to find / list all scheduled searches, the time they should run at and the time they ran ?

Thank you.

Regards,
David

Re: List or View Scheduled searches

renjith_nair — Fri, 22 Jan 2016 16:37:13 GMT

You can view all the scheduled search using

| rest /services/saved/searches | where is_scheduled=1

To get a history of scheduled search , check the internal logs

index=_internal sourcetype=scheduler  | table _time user savedsearch_name status scheduled_time run_time result_count

Re: List or View Scheduled searches

inventsekar — Fri, 09 Nov 2018 11:40:37 GMT

Anyone got any ideas for this issue?!?!

Re: List or View Scheduled searches

triest — Mon, 07 Jan 2019 18:47:09 GMT

As always, Splunk continues to improve and with the improvements, I would suggest a different search:

| rest /services/saved/searches search="is_scheduled=1"

What's the different between this and using rest with where?

In typically Splunk fashion, the earlier you do filtering, the more efficient the search should be. This should push the filtering down to the search peers which means they (potentially) return fewer results to the search head.

Re: List or View Scheduled searches

trav271 — Mon, 28 Jan 2019 03:38:24 GMT

While early filtering is a good rule of thumb, in this instance remember the "where" command is categorized as a Distributable Streaming search process, so this would also be done at the index level and more importantly can be done BEFORE the final output, so it does not necessarily generate more traffic as Splunk will send it down as well knowing this fact about the "where" command.

But, like I said, and learned from a great teacher I had, that is generally a good rule of thumb to follow 😉

Also, the above about Distributable Streaming goes for: eval, fields, rex, where, etc.

For the curious, here's a great read to understand how searching works wrt different commands:
https://docs.splunk.com/Documentation/Splunk/7.2.3/Search/Typesofcommands