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!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...