How to write a Splunk search for License Utilization for Particular events?

[umesh]

Hi ,

i want to find the license utilization of  firewall logs based on severity level. can anyone help me with the query on how to find the license utilization based on particular events like eventid in windows logs

[johnhuang]

You can approximate license utilization by counting the number of events instead of calculating the exact size. This is faster and could meet your use case.

For example, windows event log:

<base search>
| top 100 EventCode 

[richgalloway · Accepted solution]

Splunk's license usage log tracks utilization by index, host, source, sourcetype, and pool, but not severity.  You'll have to it yourself by adding up the sizes of all of the relevant events.  This method may not match the number calculated by Splunk, but should be close enough.

index=firewall sourcetype=firewall 
| eval size=len(_raw)
| stats sum(size) as TotalSize by severity