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!

Splunk Lantern | Getting Started with Edge Processor, Machine Learning Toolkit ...

Splunk Lantern is Splunk’s customer success center that provides advice from Splunk experts on valuable data ...

Enterprise Security Content Update (ESCU) | New Releases

In the last month, the Splunk Threat Research Team (STRT) has had 2 releases of new security content via the ...

Announcing the 1st Round Champion’s Tribute Winners of the Great Resilience Quest

We are happy to announce the 20 lucky questers who are selected to be the first round of Champion's Tribute ...