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!

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...

Accelerating Observability as Code with the Splunk AI Assistant

We’ve seen in previous posts what Observability as Code (OaC) is and how it’s now essential for managing ...