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!

Splunk Mobile: Your Brand-New Home Screen

Meet Your New Mobile Hub  Hello Splunk Community!  Staying connected to your data—no matter where you are—is ...

Introducing Value Insights (Beta): Understand the Business Impact your organization ...

Real progress on your strategic priorities starts with knowing the business outcomes your teams are delivering ...

Enterprise Security (ES) Essentials 8.3 is Now GA — Smarter Detections, Faster ...

As of today, Enterprise Security (ES) Essentials 8.3 is now generally available, helping SOC teams simplify ...