Splunk Search

How to create Timechart when no splitby available?

dvg06
Path Finder

Hi Splunkers

Need some help with a timechart query please.

index=linux host IN (a,b,c,d,e) | timechart span=1week eval(avg(CPU) * avg(MEM)) BY host

This works well if there is atleast an event per host. But I wanted to show zero value when there are no events for a particular host. Is that possible?

eg: I have events only for a,b,c but still wanted to show zero for d and e hosts. 

Labels (1)
Tags (1)
1 Solution

bowesmana
SplunkTrust
SplunkTrust

This is a very common question - there is no data in Splunk for d and e, so you need to tell Splunk that you want information about hosts it does not know about.

The most normal way to do this is to create a lookup with your (5?) hosts in, e.g. my_hosts.csv

host
a
b
c
d
e

 then do your search

index=linux [ | inputlookup my_hosts.csv ]
| timechart span=1week eval(avg(CPU) * avg(MEM)) BY host
| appendcols [ 
  | inputlookup append=t my_hosts.csv
  | eval {host}=0
  | fields - host
  | stats max(*) as * 
]
| filldown

which will make the time chart and then add columns for each of the missing hosts

 

View solution in original post

bowesmana
SplunkTrust
SplunkTrust

This is a very common question - there is no data in Splunk for d and e, so you need to tell Splunk that you want information about hosts it does not know about.

The most normal way to do this is to create a lookup with your (5?) hosts in, e.g. my_hosts.csv

host
a
b
c
d
e

 then do your search

index=linux [ | inputlookup my_hosts.csv ]
| timechart span=1week eval(avg(CPU) * avg(MEM)) BY host
| appendcols [ 
  | inputlookup append=t my_hosts.csv
  | eval {host}=0
  | fields - host
  | stats max(*) as * 
]
| filldown

which will make the time chart and then add columns for each of the missing hosts

 

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!

Announcing Modern Navigation: A New Era of Splunk User Experience

We are excited to introduce the Modern Navigation feature in the Splunk Platform, available to both cloud and ...

Kubernetes Alerts That Work Out of the Box with AutoDetect detectors in Splunk ...

A deployment rolls out slowly, one pod sits not ready for a few minutes, and whoever is on call gets an alert ...

Observability at Your Fingertips Directly From Splunk Platform—for Free

At .conf, we announced our roadmap to bring observability foundations to Splunk Platform. Bringing metrics and ...