Splunk Search

How to customize the dashboard drill down query

sajoseph
Explorer

HI,
I have a dashboard query which is like this.

index=elf |search * | chart count(eval(event_type="3000")) AS AUDIT, count(eval(event_type="6000")) AS USAGE,count(eval(event_type="7000")) AS HEART_BEAT,count(eval(event_type="10000")) AS ERROR by app_id

This search gives events grouped by application ID and the different event_types that are stacked in a Column chart.

When i click on any event type, it is suppose to run a search which filters the data by Application ID and then filters the data by Event_type.

But I am getting only the below search "index=elf | search app_id="ERD"" not as "index=elf | search app_id="ERD" event_type=6000"

Please let me know how to customize the drilldown search

I am new to splunk. Appreciate your timely help.

0 Karma

lguinn2
Legend

FIrst, I would rewrite your search as

index=elf 
| eval CountType = case(eventtype="3000","AUDIT",
                        eventtype="6000", "USAGE"
                        eventtype="7000", "HEART_BEAT",
                        eventtype="10000", "ERROR",
                        1=1,"Unknown" )
| where CountType!=unknown
| chart count by app_id CountType

It just seems easier. Second, drilldown may not work because of the way you have structured the result table. For example, Splunk isn't going to be able to connect "USAGE" with eventtype="6000". I think this will be true regardless of whether you use the original search or the search I've shown above. And I can't see how to do this even with a custom drilldown.

You could do this:

index=elf (eventtype="3000" OR eventtype="6000" OR eventtype="7000" OR eventtype="10000")
| chart count by app_id eventtype

Now your drilldown should work, but your headings won't be as nice.

0 Karma
Get Updates on the Splunk Community!

Dashboard Studio Challenge - Learn New Tricks, Showcase Your Skills, and Win Prizes!

Reimagine what you can do with your dashboards. Dashboard Studio is Splunk’s newest dashboard builder to ...

Introducing Edge Processor: Next Gen Data Transformation

We get it - not only can it take a lot of time, money and resources to get data into Splunk, but it also takes ...

Take the 2021 Splunk Career Survey for $50 in Amazon Cash

Help us learn about how Splunk has impacted your career by taking the 2021 Splunk Career Survey. Last year’s ...