Splunk Search

Finding the earliest event by Splunk server & index

kogane
Path Finder

I'm trying to come up with a query that shows me the earliest (oldest) event in each index on every server that I have. A naive way of doing this might be:

index=* | stats earliest(_time) as earliest_time by splunk_server, index

But I really don't want to run it on all available data... Is there a metadata-based query for getting the same information?

Tags (3)
0 Karma

mpaniagua_splun
Splunk Employee
Splunk Employee

Try | metadata type=hosts, this will give you am good overview

0 Karma
Get Updates on the Splunk Community!

Introducing the 2024 SplunkTrust!

Hello, Splunk Community! We are beyond thrilled to announce our newest group of SplunkTrust members!  The ...

Introducing the 2024 Splunk MVPs!

We are excited to announce the 2024 cohort of the Splunk MVP program. Splunk MVPs are passionate members of ...

Splunk Custom Visualizations App End of Life

The Splunk Custom Visualizations apps End of Life for SimpleXML will reach end of support on Dec 21, 2024, ...