Dashboards & Visualizations

How to create Executive Overview Dashboard with Status Icons / Rangemap

jlucius
Explorer

I would like to create something that is shown in the Operational Intelligence Demo of Splunk (see screenshot below). In this Dashboard there are several icons changing color depending on the status of an IT area like operations or security. The status icons are linked to a dashboard that shows more details about this area.

From what I can tell so far:
- the custom icons with changing colors can be created using custom CSS and rangemap
- Linking to another dashboard should not be a problem as well

But every status icon should change depending on the results of like 5-10 searches, for which I have already created a dashboard that is showing the individual results.

Is there a more intelligent way to get the status other than doing a complex rangemap query that does all of the searches in one query and somehow change status depending on different thresholds for each subsearch?
Can this be done with Splunk native or is extending splunk involved?
Is there any example in an App how to do something like this (free or not)?

alt text

yonick
Engager

I have worked around that problem. I wanted to create a dashboard with live data. But you can only do a numbered of real time searches. So I worked around it by doing the search every 10 sec, for the light searches that need live data, and 1 min, for the bigger searches where the live data isn't that critical.

You can convert your dashboard to an HTML page and then use java script to restart your searches. I'll give a example:

var searchID1= new SearchManager({
                            "id": "searchID1",
                            "latest_time": "@m",
                            "earliest_time": "-1m@m",
                            "search": "index=* ...seach... | rangemap field=value ...rangemap...,
                            "status_buckets": 0,
                            "cancelOnUnload": true,
                            "app": utils.getCurrentApp(),
                            "auto_cancel": 90,
                            "preview": true,
                            "runWhenTimeIsUndefined": false
                        }, {tokens: true, tokenNamespace: "submitted"});

                        new SearchEventHandler({
                            managerid: "searchID1",
                            event: "preview",
                            conditions: [
                                {
                                    attr: "any",
                                    value: "*",
                                    actions: [
                                        {"type": "set", "token": "value1", "value": "$result.value$"},
                                        {"type": "set", "token": "range1", "value": "$result.range$"}
                                    ]
                                }
                            ]
                        });
var searchID2= new SearchManager({
                            "id": "searchID1",
                            "latest_time": "@m",
                            "earliest_time": "-1m@m",
                            "search": "index=* ...seach... | rangemap field=value ...rangemap...,
                            "status_buckets": 0,
                            "cancelOnUnload": true,
                            "app": utils.getCurrentApp(),
                            "auto_cancel": 90,
                            "preview": true,
                            "runWhenTimeIsUndefined": false
                        }, {tokens: true, tokenNamespace: "submitted"});

                        new SearchEventHandler({
                            managerid: "searchID2",
                            event: "preview",
                            conditions: [
                                {
                                    attr: "any",
                                    value: "*",
                                    actions: [
                                        {"type": "set", "token": "value2", "value": "$result.value$"},
                                        {"type": "set", "token": "range2", "value": "$result.range$"}
                                    ]
                                }
                            ]
                        });

This are your searches in javascript. Now they all have a ID so we can call that ID to restart the search:

     window.setInterval(function() {
                searchID1.startSearch();
     }, 5*1000);
     window.setInterval(function() {
                searchID2.startSearch();
     }, 60*1000);

With this you can rerun your searches. The time is in milliseconds.

I hope this helps you to your solution

0 Karma
Get Updates on the Splunk Community!

Join Us for Splunk University and Get Your Bootcamp Game On!

If you know, you know! Splunk University is the vibe this summer so register today for bootcamps galore ...

.conf24 | Learning Tracks for Security, Observability, Platform, and Developers!

.conf24 is taking place at The Venetian in Las Vegas from June 11 - 14. Continue reading to learn about the ...

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...