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!

Splunk Observability Cloud | Customer Survey!

If you use Splunk Observability Cloud, we invite you to share your valuable insights with us through a brief ...

Happy CX Day, Splunk Community!

Happy CX Day, Splunk Community! CX stands for Customer Experience, and today, October 3rd, is CX Day — a ...

.conf23 | Get Your Cybersecurity Defense Analyst Certification in Vegas

We’re excited to announce a new Splunk certification exam being released at .conf23! If you’re going to Las ...