Reporting

Saved search usage

priya0709
Path Finder

I have a query saved to display all Hard Disk error for hosts. We generate this data daily from the query and send it to the respective Assignee every Wednesday.

My requirement is to prepare a visualization for 30 days data of these scheduled search??

Please help me with the query

Labels (1)
0 Karma
1 Solution

ITWhisperer
Legend

I would start by setting up a summary index populated with the results of your daily searches. You can then base your 30 day report/dashboard visualisation on this index without having to rerun the original query for each of the 30 days. Not only will this be faster, it will mean you can save space because you will have already extracted all the information you need from the raw logs into the summary index. This does mean you have to think carefully about the search for your summary index so that it includes everything you might need from the original data.

View solution in original post

0 Karma

ITWhisperer
Legend

I would start by setting up a summary index populated with the results of your daily searches. You can then base your 30 day report/dashboard visualisation on this index without having to rerun the original query for each of the 30 days. Not only will this be faster, it will mean you can save space because you will have already extracted all the information you need from the raw logs into the summary index. This does mean you have to think carefully about the search for your summary index so that it includes everything you might need from the original data.

View solution in original post

0 Karma

soutamo
SplunkTrust
SplunkTrust
That's excellent way to do it if you have lot of data and it takes time to generate the whole report. Remember to ensure that summary indexes don't contains any holes if/when there are some issues to populate those.

But if amount of data is quite slow and you have resources to run this query as needed then just create it when needed from your original data.
r. Ismo
0 Karma
Register for .conf21 Now! Go Vegas or Go Virtual!

How will you .conf21? You decide! Go in-person in Las Vegas, 10/18-10/21, or go online with .conf21 Virtual, 10/19-10/20.