Splunk Search

Using stats and table command

Vig95
Engager

Hi,

I am new to splunk, could you please help me with below SPL, I am trying to use stats and table command

We have 4 entries for same incident, I need to pick earliest time.

Index="monitoring" sourcetype="tool" incident_id=INC* | stats earliest(_time) as early | table "mc_host" "incident_id" "early" | convert ctime(early)

 

I am getting error if execute.

 

 

Labels (3)
0 Karma
1 Solution

gcusello
SplunkTrust
SplunkTrust

Hi @Vig95,

the solution is the one hinted by @isoutamo because after a stats command you have only the fields used in the stats command itself, so you have to declare (using e.g. values or earliest) all the fields you need in the following table, that couldn't be necessary if the fields from the stats command are already in the order you want:

index="monitoring" sourcetype="tool" incident_id=INC* 
| stats earliest(_time) as early BY mc_host incident_id
| convert ctime(early)

Ciao.

giuseppe

View solution in original post

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Vig95,

the solution is the one hinted by @isoutamo because after a stats command you have only the fields used in the stats command itself, so you have to declare (using e.g. values or earliest) all the fields you need in the following table, that couldn't be necessary if the fields from the stats command are already in the order you want:

index="monitoring" sourcetype="tool" incident_id=INC* 
| stats earliest(_time) as early BY mc_host incident_id
| convert ctime(early)

Ciao.

giuseppe

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @Vig95 ,

good for you, see next time!

Ciao and happy splunking

Giuseppe

P.S.: Karma Points are appreciated by all the contributors 😉

0 Karma

isoutamo
SplunkTrust
SplunkTrust

Hi

you probably want to see it by inc? If so you could try

Index="monitoring" sourcetype="tool" incident_id=INC* 
| stats min(_time) as _time values(mc_host) as mc_host by incident_id
| table "mc_host" "incident_id" _time

r. Ismo 

Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Accelerate Splunk App Development with AI

  Learn how to automate the repetitive parts of your build cycle.   Watch On-Demand   Replay the Accelerate ...

Splunk Agent Observability: Measuring AI Value with Splunk Tokenomics on AWS

The AI landscape is moving faster than ever, and our latest 2026 State of Observability report provides the ...

Enterprise Security Watch Party: What’s New in 8.8 - Recap

Splunk Community HQ hosted a Splunk Enterprise Security Watch Party: What’s New In ES 8.8 last Thursday. I had ...