Splunk Search

How to create chart view when you have all columns in same events ?

New Member

ok, let me try my best to explain my question here.

I have Json format logs and now I need them to compare based on one of the value there. below is sample event.

{ [-]
cpuUtilization: { [-]
guest: 0

idle: 100

irq: 0

nice: 0

steal: 0

system: 0

total: 0

user: 0

wait: 0


diskIO: [ [+]

engine: MYSQL

fileSys: [ [+]

instanceID: MyDB1

So I have same events coming from MyDB2, MyDB3.. etc. Now I want to get a below view.

    My DB1  My DB2  My DB3
 idle:  100 100 100
 irq:   0   0   0
 nice:  0   0   0
 steal: 0   0   0
 system:    0   0   0
 total: 0   0   0
 user:  0   0   0
 wait:  0   0   0

I am very poor dealing with Multi value command if that is what I need to use here. Need your help.

Tags (3)
0 Karma

Esteemed Legend

You have not given us much detail but probably something like this:

index=<You Should Always Specify An Index> AND sourcetype=<And sourcetype Too>
| stats avg(*) AS * BY host
| untable host metric value
| xyseries metric host value
0 Karma


Hello @NirajAlly

If for every instance you are getting different events then it will be pretty east easy
as for every field which is visible on the json above will have one field available in interesting field

Just click on All fields and try to search idle,you will see the field exists and use that to run the chart command.

0 Karma

New Member

Provided one in my question is the Json format event which I have on my splunk.

0 Karma


@NirajAlly community will be able to assist you better if you can share the raw JSON with valid JSON formatting (please mock anonymize any sensitive information before posting on Splunk Answers). Else provide the current fields that are currently available, with your current output, so that we can convert the same to the desired result.

| makeresults | eval message= "Happy Splunking!!!"
0 Karma
Get Updates on the Splunk Community!

Build Scalable Security While Moving to Cloud - Guide From Clayton Homes

 Clayton Homes faced the increased challenge of strengthening their security posture as they went through ...

Mission Control | Explore the latest release of Splunk Mission Control (2.3)

We’re happy to announce the release of Mission Control 2.3 which includes several new and exciting features ...

Cloud Platform | Migrating your Splunk Cloud deployment to Python 3.7

Python 2.7, the last release of Python 2, reached End of Life back on January 1, 2020. As part of our larger ...