topic Re: Schedule a report to run each day so that query is not run every time viewed in Reporting

Schedule a report to run each day so that query is not run every time viewed

atornes — Fri, 30 Mar 2012 17:54:03 GMT

I've created a lot of reports and a number of dashboards, some of which are pretty complex. We don't have splunk setup on the best machine, so some of these queries take a while to run and dashboards can break or take forever to view while all of the reports are generated, sometimes they timeout.

All reports are based on daily data that is pulled in each night around midnight. Is there a way to schedule each report to run early in the morning, say 6am, each day so that every time someone views a dashboard with that report that day, it doesn't have to re-run each time and take forever to load, as its been "pre-run/scheduled"? I don't need it to be emailed to me or anything.

Re: Schedule a report to run each day so that query is not run every time viewed

lguinn2 — Fri, 30 Mar 2012 18:44:33 GMT

Yes - simply edit each search and check the box for "schedule this search". Under scheduled search, you can choose schedule type "cron". In the cron schedule box put

0 6 * * *

Save your changes. (Don't choose any of the alerts or notifications.) The search will run automatically every morning at 6:00 am.

The dashboard will automatically pick up the cached results. BTW if someone runs the search manually during the day, the dashboard will then pick up the latest results.

Re: Schedule a report to run each day so that query is not run every time viewed

p_splunk — Fri, 05 Oct 2012 12:10:36 GMT

when i see my view/dashboard, do i need to click vie result for every search and then create a scheduled search of this search?
beacuase I cannot find the checkbox u are talking about (i have 4.3.3)

thx for answer

Re: Schedule a report to run each day so that query is not run every time viewed

lguinn2 — Fri, 05 Oct 2012 23:12:32 GMT

In 4.3.3, you can click Edit on the dashboard to put the dashboard in edit mode, then click Edit on the dashboard panel and then Edit Search and Edit in Manager to get to the point that I mentioned above.

However, in all versions of Splunk, you can go to the Manager, choose Searches and Reports and then click the name of the search that you want to edit.

Re: Schedule a report to run each day so that query is not run every time viewed

p_splunk — Wed, 10 Oct 2012 11:41:50 GMT

hey, i found it out now,
you have to have the specific search saved before and then after "edit search" you have to click "Select a saved search" then u are where lguinn says (i think so 😉

that's how mine worked out,
thx