I want to calculate daily license usage against a fixed quota like 800gb

[lwaddep1]

I want to calculate daily license usage against a fixed quota like 800gb.

Thanks,
Kanth

[HiroshiSatoh]

I modified ”Percentage of Daily License Quota Used” of DMC slightly.

(earliest=-30d@d host=ip-172-31-53-105.ec2.internal index=_internal source=*license_usage.log* type="RolloverSummary") 
| eval _time=('_time' - 43200) 
| bin _time span=1d 
| stats latest(b) AS b latest(stacksz) AS stacksz by slave, pool, _time 
| stats sum(b) AS volumeB max(stacksz) AS stacksz by _time 
| eval stacksz=800000000000
| eval pctused=round(((volumeB / stacksz) * 100),2) 
| timechart span=1d max(pctused) AS "used" fixedrange=false

[mstjohn_splunk]

@Iwaddep1

Thanks for posting on Splunk Answers.

Could you give us some more information about what you are looking to do? Generally, the more information you provide, the better the chance that someone in the community could solve your problem. Plus, you'd be providing a guide for future users who may be experiencing a similar issue.

[lwaddep1]

Sure, I have this below query
| rest splunk_server=local /services/licenser/pools | rename title AS Pool | search [rest splunk_server=local /services/licenser/groups | search is_active=1 | eval stack_id=stack_ids | fields stack_id] | eval quota=if(isnull(effective_quota),quota,effective_quota) | eval "Used"=round(used_bytes/1024/1024/1024, 3) | eval "Quota"=round(quota/1024/1024/1024, 3) | eval "%used"=((used_bytes/quota)*100)| fields Pool "Used" "Quota" "%used"

I want to change "Quota" to a fixed value instead of unlimited which currently set.

[lwaddep1]

Also I want show % used against 800GB