Splunk Search

Divide a severity count by host count in a timechart

jravida
Communicator

Hi folks,

I guess what I am trying to do is create a timechart based on a scan events severity rating(low, med, high, severe):

index=scan | timechart span=1mon count by severity

I have another query, which gives me a timechart of the total number of hosts that were actually scanned month to month:

index = scan | timechart span=1mon dc(hostName)

Since the total number of each severity means nothing without the host count as context, I would like to divide the total count of each severity by the host count, month to month (each will be different). I've tried to join the search, but haven't had any luck dividing the severity counts by the host count in the timechart or stats command.

Thanks!

Tags (3)
0 Karma

jkat54
SplunkTrust
SplunkTrust
 index=scan | timechart span=1mon dc(hostName) by severity

jravida
Communicator

This does the 'split by' function. I need the dc(hostName) month by month, to divide the number of severities, by severity

0 Karma
Get Updates on the Splunk Community!

See just what you’ve been missing | Observability tracks at Splunk University

Looking to sharpen your observability skills so you can better understand how to collect and analyze data from ...

Weezer at .conf25? Say it ain’t so!

Hello Splunkers, The countdown to .conf25 is on-and we've just turned up the volume! We're thrilled to ...

How SC4S Makes Suricata Logs Ingestion Simple

Network security monitoring has become increasingly critical for organizations of all sizes. Splunk has ...