How I would know when the last time data came in under any index/sourcetype? I have one query (see below) is showing me the feed status by index. But, my objective is to find when the last time data was fed to indexes/source types. Any help will be highly appreciated. Thank you!
| tstats prestats=t count where earliest=-7d@d latest=-0d@d index=* by index, _time span=1d | timechart useother=false limit=0 span=1d count by index
Thank you so much for your quick response, greatly appreciated. It's giving be only the status for main index and its source types.....do you think following going to work, how ever it's computationally very expensive...do you have any other optimal solutions ?
index=*|stats count values(sourcetype) as Sourcetype latest(_time) as Time by index|fields - count | convert ctime(Time)