Dashboards & Visualizations

dashboard panels based on main search output (loop through the output)

Amirahussein
Path Finder

Dears,
please i need your support as i am creating new dashboard, the number of panel included in this dashboard is depending on the output of search query ( for each unique source there will be single panel)
this dashboard will be refreshed every 5 minutes to view new data

so i need to create a loop to access all sources individually, for each panel i will create new query to show statistics

for example:
1- Main Search:
index=x sourcetype="oracle:db" "search for specific string" | dedup source|table source
output:the output is variable
source1
source2
source3
2- for each source, i need to create panel with some regex
index=xsourcetype="oracle:db" source="source1" earliest=-5m latest=now|rex field=source "(?([-\w]+?))(?(\w+?))(?(\w+))" |timechart span=15m last(NODE) as Node , last(INSTANT) as Instance,last(QUEUE) AS Queue avg(QUEUE_COUNT) as QueueCount

so is there a way to create such dashboard ?

Tags (1)
0 Karma

woodcock
Esteemed Legend

This can be done if you are on v6.6 or later with the new Trellis feature.
It can be done on any version of Splunk with the multiplexer capability of sideview Utils:
http://sideviewapps.com/apps/sideview-utils/

0 Karma

rjthibod
Champion

Are you running Splunk 6.6? If so, then the new trellis chart layout can do this without you needing to do the first query. Without 6.6, this is going to be quite difficult.

0 Karma
Get Updates on the Splunk Community!

Observability Highlights | November 2022 Newsletter

 November 2022Observability CloudEnd Of Support Extension for SignalFx Smart AgentSplunk is extending the End ...

Avoid Certificate Expiry Issues in Splunk Enterprise with Certificate Assist

This blog post is part 2 of 4 of a series on Splunk Assist. Click the links below to see the other ...

Using Machine Learning for Hunting Security Threats

REGISTER NOW Seeing the exponential hike in global cyber threat spectrum, organizations are now striving more ...