index=_internal source=*metrics.log
| eval MB=round(kb/1024,2)
| search group="per_sourcetype_thruput"
| stats sum(MB) by series | eval sourcetype=lower(series)
| table index sourcetype "sum(MB)"
| append [| tstats latest(_time) as latest where index=* earliest=-24h by sourcetype |eval LastReceivedEventTime = strftime(latest,"%c") |table index, sourcetype LastReceivedEventTime | eval sourcetype=lower(sourcetype)]
| stats values(*) as * by sourcetype
| where LastReceivedEventTime != ""
Above query giving me sourtype, latest time stamp and sum(MB), but unable to get index, can someone please help
... View more