I have configured DB Connect App to SQL Server. I have created a dashboard in Splunk DB Connect App, by using queries based on DMVs.
I want to control the execution of the query, how do I schedule it? It executes every time I open the dashboard. I want the query to execute at scheduled time only, not every time I open the dashboard. is there a way to control this? Please let me know.
Have you tried scheduling the entire dashboard, or converting that specific panel to a scheduled search?
You also could look into setting up DB Inputs so that data is ingested into Splunk on a regular interval.
Thanks, I have edited the XML source as which will refresh my dashboard every 5 minutes. Does this mean the query behind dashboard will be executed only once in 5 minutes?
Please let me know how do I schedule a dashboard (suppose I want to run DMV query at specific time), I can scheduling only for Alerts, when I save a search string as an alert, I get option to schedule it. But not for a Dashboard panel.