Splunk Search

How to turn CSV into a graph?

Lither1423
Observer

Hey hey, I'm trying to turn telemetry to a graph.

I have a CSV containing:

PID,runtime,invoked,usecs,5sec,1min,5min,tty,process.

There are a bunch of process with each of those fields, I want to turn the CSV into 3 column graphs, one with the process name and then% CPU used in (5sec, 1min or 5min, one graph each)

And I'm confused as to how to accomplish that

 

 

 

 

 

Labels (2)
0 Karma

richgalloway
SplunkTrust
SplunkTrust

I thought you wanted a single graph with three values.  Thanks for clarifying.  To get three separate graphs, you can try trellis mode.  If that doesn't do what you expect then you'll need three separate searches in different panels.

---
If this reply helps you, Karma would be appreciated.
0 Karma

richgalloway
SplunkTrust
SplunkTrust

It's not clear what output you want, but perhaps this will get you started.

... | chart max(5sec) as 5sec, max(1min) as 1min, max(5min) as 5min by PID
---
If this reply helps you, Karma would be appreciated.
0 Karma

Lither1423
Observer

It didn't really show me anything, what I'm looking for is adding a panel to my dashboard with 3 column charts, 1 chart will have a %amount specified on the 5th place every row in the y axis and the process name which is the first place every row on the X axis,  second chart will be the same but the y axis will take the number from the 6th place every row and third chart will take from the 7th.

So the result would be 3 column charts with the process names on the X axis and % on the y axis, one graph showing the usage in 5 seconds, one shows usage in 1 minute and the third for 5 minutes.

0 Karma
Get Updates on the Splunk Community!

Ready, Set, SOAR: How Utility Apps Can Up Level Your Playbooks!

 WATCH NOW Powering your capabilities has never been so easy with ready-made Splunk® SOAR Utility Apps. Parse ...

DevSecOps: Why You Should Care and How To Get Started

 WATCH NOW In this Tech Talk we will talk about what people mean by DevSecOps and deep dive into the different ...

Introducing Ingest Actions: Filter, Mask, Route, Repeat

WATCH NOW Ingest Actions (IA) is the best new way to easily filter, mask and route your data in Splunk® ...