Please I need the SPL to get the license usage per a specific host per GB in splunk
Note: not all host in the environment , just a single host
index=_internal host=your_license_host source=\*license_usage.log\* type="Usage" h=host | 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 | eval b=b/(1024*1024*1024) | timechart span=1d sum(b) AS volumeB by h fixedrange=false
Make sure to change the host and h values accordingly