Installation

How do I see used vs available license usage?

lwaddep1
New Member

I have the below search against a particular heavy index which lists its daily volume consumed.

index=_internal source=*license_usage.log type=Usage | eval totalMB = b/1024/1024  | eval totalGB = totalMB /1024 | rename idx as index | search index="xxx-xxx" | timechart span=1d sum(totalGB) by index 

_time             xxx-xxx       
------------------------------------
date             200GB          

I want the above query tweaked to compares the daily usage against 1000GB and list the output like below

_time              xxx-xxx            Total            %Used    
---------------------------------------------------------------------------------------------
date               200GB              1000GB           20%

Thanks,
Laks

Labels (1)
0 Karma
1 Solution

harishalipaka
Motivator

Hi @lwaddep1
Can you try like this.

index=_internal source=*license_usage.log type=Usage | eval totalMB = b/1024/1024 | eval totalGB = totalMB /1024 | rename idx as index | search index="xxx-xxx" | timechart span=1d sum(totalGB) as used_gb by index | eval total=1000 | eval used=used_gb/total |eval "used%"=used +"%"
Thanks
Harish

View solution in original post

0 Karma

harishalipaka
Motivator

Hi @lwaddep1
Can you try like this.

index=_internal source=*license_usage.log type=Usage | eval totalMB = b/1024/1024 | eval totalGB = totalMB /1024 | rename idx as index | search index="xxx-xxx" | timechart span=1d sum(totalGB) as used_gb by index | eval total=1000 | eval used=used_gb/total |eval "used%"=used +"%"
Thanks
Harish
0 Karma

lwaddep1
New Member

Thanks for the quick update, i am able to see like below, but used% is missing.

_time xxx-xxx total

date 200GB 1000

0 Karma
Get Updates on the Splunk Community!

Understanding Generative AI Techniques and Their Application in Cybersecurity

Watch On-Demand Artificial intelligence is the talk of the town nowadays, with industries of all kinds ...

.conf24 | Registration Open!

Hello, hello! I come bearing good news: Registration for .conf24 is now open!   conf is Splunk’s rad annual ...

Using the Splunk Threat Research Team’s Latest Security Content

REGISTER HERE Tech Talk | Security Edition Did you know the Splunk Threat Research Team regularly releases ...