Splunk Search

How to edit my search to display the status of my saved searches?

ramstolentino
Explorer

Hi, I am currently using the search below to get the status of my saved searches.

index=_internal sourcetype=scheduler | eval dispatch_time=strftime(dispatch_time, "%B %d %H:%M:%S") | table savedsearch_name status dispatch_time run_time result_count | sort dispatch_time

However, I want to see the following status:

  1. running;
  2. not running
  3. completed ("success" is OK)

Any suggestions? Thanks!

0 Karma

tlam_splunk
Splunk Employee
Splunk Employee

I think your search command is trying to get the status from the scheduler.log.
In scheduler.log, I don’t think it has the ‘running' status. In general, you could take status = success As 'completed' , other than success, you could take it as ‘not completed’.

0 Karma

woodcock
Esteemed Legend

Why not use the REST API?

| rest/servicesNS/-/-/saved/searches

cmerriman
Super Champion

by "not running" are you referring to saved searches that are not on a schedule? otherwise, in my opinion, if they are "not running" they would be "completed". I've never seen a "running" status, but I suppose i've never looked while i had a search running before.

Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...