Splunk Search

License usage

Siddharthnegi
Contributor

How to see daily licensing usage of 1 index in Splunk.

0 Karma

isoutamo
SplunkTrust
SplunkTrust

On MC (monitoring console) is own dashboard to show license usage. There are some selection by which you can see values. Just go

Settings -> Monitoring Console 

Indexing -> License Usage -> Historic License Usage

then Split By: By Index

Otherwise if you have all in one server you could check this also from

Settings -> Licensing

Usage Report

Previous 60 days

Split by: index

 

Those both shows by N (10?) biggest indexes. If you want to check some specific index then just copy that query by opening it from magnify glass.

Then modify it something like

index=_internal idx=<YOUR INDEX NAME>
    [ `set_local_host`] source=*license_usage.log* type="Usage" 
| eval h=if(len(h)=0 OR isnull(h),"(SQUASHED)",h) 
| eval s=if(len(s)=0 OR isnull(s),"(SQUASHED)",s) 
| eval idx=if(len(idx)=0 OR isnull(idx),"(UNKNOWN)",idx) 
| bin _time span=1d 
| stats sum(b) as b by _time, pool, s, st, h, idx 
| timechart span=1d sum(b) AS volumeB by idx fixedrange=false 
| join type=outer _time 
    [ search index=_internal idx=<YOUR INDEX NAME>
        [ `set_local_host`] source=*license_usage.log* type="RolloverSummary" earliest=-30d@d 
    | eval _time=_time - 43200 
    | bin _time span=1d 
    | dedup _time stack 
    | stats sum(stacksz) AS "stack size" by _time] 
| fields - _timediff 
| foreach * 
    [ eval <<FIELD>>=round('<<FIELD>>'/1024/1024/1024, 3)]

r. Ismo

0 Karma
Get Updates on the Splunk Community!

Splunk Enterprise Security: Your Command Center for PCI DSS Compliance

Every security professional knows the drill. The PCI DSS audit is approaching, and suddenly everyone's asking ...

Developer Spotlight with Guilhem Marchand

From Splunk Engineer to Founder: The Journey Behind TrackMe    After spending over 12 years working full time ...

Cisco Catalyst Center Meets Splunk ITSI: From 'Payments Are Down' to Root Cause in ...

The Problem: When Networks and Services Don't Talk Payment systems fail at a retail location. Customers are ...