Reporting

Number of events generated by a saved search

izyknows
Path Finder

Hello,

I have a savedsearches.conf deployed via a TA on Splunk. The conf has ~90-100 searches in it.

I would like to count the number of events generated per search query over a given period of time.

Could someone kindly help me with a Splunk query to do this? I've been trying for a while now.

Thank you!

Labels (2)
0 Karma

manjunathmeti
SplunkTrust
SplunkTrust

Try this:

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

 

If this reply helps you, an upvote/like would be appreciated.

0 Karma

izyknows
Path Finder

Hi thanks. Unfortunately the result_count which is the most important field for me returns 0 for all. Even though the searches have run.

0 Karma

manjunathmeti
SplunkTrust
SplunkTrust

I am getting proper values (not 0s) in the result_count. Check if your scheduled searches producing results in the Job Manager. Sometimes scheduled searches won't gives results due to incorrect time ranges, permissions to user running them etc.

0 Karma
Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...