Deployment Architecture

Data Feed Status in splunk: How  I would know when the last time data came in under any index/sourcetype?

SplunkDash
Builder

Hello,

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

 

Labels (2)
0 Karma

Stefanie
Builder

Try this search

|tstats values(sourcetype) as Sourcetype latest(_time) as Time groupby index,sourcetype|fields - Sourcetype | convert ctime(Time)

 It will give you a table of the last day an event was received by index & sourcetype.

SplunkDash
Builder

Hello,

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)

0 Karma
Get Updates on the Splunk Community!

Improve Your Security Posture

Watch NowImprove Your Security PostureCustomers are at the center of everything we do at Splunk and security ...

Maximize the Value from Microsoft Defender with Splunk

 Watch NowJoin Splunk and Sens Consulting for this Security Edition Tech TalkWho should attend:  Security ...

This Week's Community Digest - Splunk Community Happenings [6.27.22]

Get the latest news and updates from the Splunk Community here! News From Splunk Answers ✍️ Splunk Answers is ...