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

maryamchar — Thu, 07 Feb 2019 19:18:28 GMT

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

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

adonio — Thu, 07 Feb 2019 22:37:30 GMT

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

hope it helps

topic How do you show all source types even if no data is available? in Getting Data In

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

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