topic Re: How to write a Splunk search for License Utilization for Particular events? in Splunk Search

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

umesh — Thu, 29 Sep 2022 14:57:27 GMT

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

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

richgalloway — Fri, 30 Sep 2022 00:10:31 GMT

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

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

johnhuang — Fri, 30 Sep 2022 05:31:32 GMT

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