Dashboards & Visualizations

How to store results of searches in Dashboard?

brober27
New Member

I have build a dashboard with many instagrams , gauges, and graphics .. every time I click on this dashboard the searchs are runned again from the start. But this is not necessary because the data do not change (at the moment). It is not useful to waste processing computation in Splunk (that we know is also limited). This is an issue also because it takes time to run this computation and therefore the dashboard takes time to be displayed.
So my wish is to store once the calculation and each time I click on the dashboard will be presented the results of stored computation.
How can I do it? Please Help me!!

Tags (1)
0 Karma

niketn
Legend

@brober27, you have several options based on what the queries on your dashboard look like.

1) Summary Based Search Acceleration
2) Dashboard Panel from Scheduled Report. Each time dashboard is loaded results from last execution of Scheduled Report will be displayed instead of re-running the search.
3) Look into performance tuning of existing Searches based on Search Optimization Tips
4) Create Data Models for datamodel acceleration
5) Use Scheduled searches to push results to lookup file using outputlookup command and create Dashboard based on Lookup file (Similar to summary indexing approach, however same lookup file can be overridden here instead of filling up summary index)
6) Use collect command to push summary results to an index of your choice and create dashboard from index with summarized events.
7) If you are on Splunk Enterprise 7 or higher and your data contains metrics data points, you can use mcollect or meventcollect to convert your events to metrics which would run faster

Read the documentations and take help from Splunk Support/Sales Engineer to weigh in your options depending on your existing data input/dashboards and requirements.

Check out couple of Splunk .conf 2017 Sessions: (1) Searching Fast (2) Speed Up Your Searches

____________________________________________
| makeresults | eval message= "Happy Splunking!!!"
Career Survey
First 500 qualified respondents will receive a $20 gift card! Tell us about your professional Splunk journey.

Can’t make it to .conf25? Join us online!

Get Updates on the Splunk Community!

Calling All Security Pros: Ready to Race Through Boston?

Hey Splunkers, .conf25 is heading to Boston and we’re kicking things off with something bold, competitive, and ...

Beyond Detection: How Splunk and Cisco Integrated Security Platforms Transform ...

Financial services organizations face an impossible equation: maintain 99.9% uptime for mission-critical ...

Customer success is front and center at .conf25

Hi Splunkers, If you are not able to be at .conf25 in person, you can still learn about all the latest news ...