topic Re: Splunk License Usage Report - Max license usage per Index per day showing the peak day per index in Splunk Enterprise

Splunk License Usage Report - Max license usage per Index per day showing the peak day per index

SamHTexas — Wed, 20 Oct 2021 21:19:16 GMT

Please help me fix this SPL to produce the license usage listed above. Thx a million

This is not working for me:

index="_internal"

| stats sum(GB) as A by Date, idx

| eventstats max(A) as B by idx

| where A=B

| dedup A idx

| sort idx

| table Date,A idx

Re: Splunk License Usage Report - Max license usage per Index per day showing the peak day per index

alonsocaio — Thu, 21 Oct 2021 18:07:44 GMT

Hi @SamHTexas, I am not sure if this is what you are looking for, but take a look at the following query:

I used your base stats, but changed some of the fields on the main query.

Re: Splunk License Usage Report - Max license usage per Index per day showing the peak day per index

SamHTexas — Thu, 21 Oct 2021 18:41:27 GMT

This is super. But not sure why it does not show all my indexes? Any ideas?

Re: Splunk License Usage Report - Max license usage per Index per day showing the peak day per index

alonsocaio — Thu, 21 Oct 2021 18:49:12 GMT

Not so sure, but I guess this query returns only indexes that had used any license on the time range your are searching. If the index didn't receive any data on this time range It won't be returned by the license usage log.