Below query can be used to get data age of each sourcetypes.
| tstats count min(_time) as firstTime, max(_time) as lastTime, max(_indextime) as recentTime where index=* by sourcetype, index, splunk_server
| stats sum(count) as count, min(firstTime) as firstTime, max(lastTime) as lastTime, max(recentTime) as recentTime by sourcetype, index
| fields - count
| eval data_age=round((lastTime-firstTime)/86400,0)
| convert ctime(recentTime) ctime(firstTime) ctime(lastTime) ctime(lastUpdated)
| fields index, sourcetype, firstTime, lastTime, data_age
Note: Make sure to select 'All time' in time-range picker.
... View more