Getting Data In

How do you show all source types even if no data is available?

maryamchar
Explorer

Hi,

I'm trying to show all the source types within the last 24 hours (I set that by using presets), and if those source types have no data, I still want to show the name of the soucetype but with 0 (represent no data).

This is what I'm doing now, but it only shows the source types with data for the last 24 hours.

index=* |chart count over sourcetype 
|eval name=if(count=="0", "0", "1") 

Please help. I searched everywhere and tried so many things but still no luck. Also, I'm trying to use the trellis visualization to represent those source types

0 Karma

adonio
Ultra Champion

use the | metadata command

| metadata type=sourcetypes index=*
| eval diff=now()-lastTime | where diff > 3600*24
| convert ctime(lastTime) 
| convert ctime(firstTime)  
| convert ctime(recentTime) 
| sort -diff

read more here:
https://docs.splunk.com/Documentation/Splunk/7.2.3/SearchReference/Metadata

hope it helps

0 Karma
Get Updates on the Splunk Community!

Announcing General Availability of Splunk Incident Intelligence!

Digital transformation is real! Across industries, companies big and small are going through rapid digital ...

Splunk Training for All: Meet Aspiring Cybersecurity Analyst, Marc Alicea

Splunk Education believes in the value of training and certification in today’s rapidly-changing data-driven ...

The Splunk Success Framework: Your Guide to Successful Splunk Implementations

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