topic Re: Splunk DB Connect Scheduler: in Splunk Enterprise

Splunk DB Connect Scheduler:

pprakash2 — Tue, 12 Jul 2016 14:33:52 GMT

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.

Re: Splunk DB Connect Scheduler:

ryanoconnor — Tue, 12 Jul 2016 17:07:00 GMT

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.

Re: Splunk DB Connect Scheduler:

pprakash2 — Wed, 13 Jul 2016 07:01:39 GMT

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.