Dashboards & Visualizations

Creating a report that progressively narrows the data set

amanteja
Path Finder

Imagine that we are sending data that has the following fields in every event
time, userid, thread ...

Would like to create a forms where the on call engineer can

  1. Start by selecting a time range
  2. He/she is now able to view all the user ids in that time range in a drop down
  3. Now the engineer can select a user. On doing that the engineer is able to view the list of all the thread ids that this user has made requests in the given time period (again a dropdown)
  4. And so on...

To finally arrive at a small subset of logs that he/she should inspect. Is this doable? Could you point me to a sample?

Tags (2)
0 Karma

martin_mueller
SplunkTrust
SplunkTrust

That's doable.

In short, this could be an approach:

  1. time range picker
  2. feed time range into a search for user ids, populating a pulldown
  3. feed time range and user id into a search for thread ids, populating a pulldown
  4. and so on
  5. feed all params to the final search, yielding your desired events

Depending on your data, it's probably smart to have commonly used fields filled from prepared lookups to speed things up.

0 Karma

martin_mueller
SplunkTrust
SplunkTrust

I had something a little different in mind - one Advanced XML view with a tree of pulldowns. A bit like the SideviewUtils doc on "Pulldown - reusing searches with 'postProcess'", available under Key Techniques if you have Sideview Utils v2 (get it from http://sideviewapps.com/apps/sideview-utils/ - you really should!).

0 Karma

amanteja
Path Finder

Thanks.
In the second form- as soon as the user has picked a userid (prepopulated by query) how does one transition to the next form WITHOUT showing the results to the user and having him click on that as documented here http://docs.splunk.com/Documentation/Splunk/5.0.3/Viz/Dynamicdrilldownindashboardsandforms#Dynamic_d...

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Best Practices: Splunk auto adjust pipeline queue

When you enable autoAdjustQueue in Splunk, maxSize should be understood as the queue size Splunk starts with ...

Laser Bananas and Edge Hubs: Exploring Operational Technology (OT) Data Through a ...

  OT is a different environment to traditional IT and can have interesting challenges when interfacing the ...

Event Series: Mastering AI Tokenomics and Splunk Agent Observability

Beyond the Black Box: Correlating AI Performance and Tokenomics with Splunk Agent Observability   As ...