topic Re: How to create a dashboard with hidden search used as base? in Dashboards & Visualizations

How to create a dashboard with hidden search used as base?

paulski82 — Fri, 07 Jun 2019 00:46:17 GMT

I had a poke around in Splunk Answers, but I couldn't find anything on this specifically.

I have a dashboard that has 8+ panels, with maybe more required. Each panel does something slightly different, but each uses the same search string (at least before the first pipe sign). For performance reasons, I'd like to be able to run the search only once for the dashboard (eg. as a base search), and then let the search in the other panels refer back to the initial search. However, I don't want to show the full (or any) results of the initial/base search in the first panel at the top of my dashboard. That is, I want the results of the base search to be "hidden", but accessible by the other searches lower down in the dashboard. I don't want to run the initial search as a saved search, I'd like it be available in (as close as possible to) real time.

Is this possible with Splunk?

Re: How to create a dashboard with hidden search used as base?

HiroshiSatoh — Fri, 07 Jun 2019 03:22:56 GMT

I think it would be better to use BASE search, but if there are many base search results, performance will deteriorate.
It is effective in the case that uses an aggregation result like a sample.

＜Base search＞
https://docs.splunk.com/Documentation/Splunk/7.2.6/Viz/PanelreferenceforSimplifiedXML

Re: How to create a dashboard with hidden search used as base?

paulski82 — Fri, 07 Jun 2019 04:35:22 GMT

OK, but the question is how do I do a HIDDEN base search. I know how to do a base search.

Re: How to create a dashboard with hidden search used as base?

niketn — Fri, 07 Jun 2019 06:04:30 GMT

@paulski82 I think what @HiroshiSatoh mentioned was that as per your description seems like you want to use streaming results in your base search which will impact performance of dashboard instead of improving it. So, you should ensure to use post-processing only for panels which reuse same transforming result sets and display different column and/or field from the transforming results. If there are too many events in your raw search then the same may also be dropped. Refer to Best Practices Documentation: https://docs.splunk.com/Documentation/Splunk/latest/Viz/Savedsearches#Best_practices

Also what you need to do is create an independent search i.e. a search without a panel and view.

<search id="baseSearch"> 
    <query> your base search query
    </query>
</search>

You can use the above documentation to see Chained and Complex Post processing examples which list this approach. They also explain when to use post-processing and when to avoid.

Re: How to create a dashboard with hidden search used as base?

hallt3 — Fri, 07 Jun 2019 19:00:43 GMT

You can just put the base searchin the XML (like an init)

< form>
< search id="base_id" >
< query>
< /query >
< /search >

...

< row>
< panel>
< table>
< search base="base_id" >
...

< /form >