Splunk Search

Is there a way in splunk to get the Custom sql query execution time ?

JBNB007
New Member

I am writing a custom sql dbxquery. When this custom query executes I want to know when it gets started and when its get completed.Based on that I want to create a performance report of this query

Can some one help me with this ?

Tags (1)
0 Karma

somesoni2
Revered Legend

If you're running your dbxquery as an adhoc Splunk search, then you can use "Inspect Job" to get the details about search execution including start time and executiontime. Alternatively, this should give your details of the execution. You can get the SID of the search

index=_audit  info=completed action=search (id=* OR search_id=*) <<PUT Search SID>>

If you're running your dbxquery as scheduled search, you can use scheduler logs to get the same info.

index=_internal sourcetype=scheduler savedsearch_name="PUT your Scheduled Search Name here"
0 Karma
Get Updates on the Splunk Community!

SOCin’ it to you at Splunk University

Splunk University is expanding its instructor-led learning portfolio with dedicated Security tracks at .conf25 ...

Credit Card Data Protection & PCI Compliance with Splunk Edge Processor

Organizations handling credit card transactions know that PCI DSS compliance is both critical and complex. The ...

Stay Connected: Your Guide to July Tech Talks, Office Hours, and Webinars!

What are Community Office Hours?Community Office Hours is an interactive 60-minute Zoom series where ...