Splunk Search

Find earliest time of when the process starts using streamstats?

k31453
Explorer

Hi, I have a particular service which we triggered occasionally and I would like to know the earliest time of every time it gets kick off for e.g 

For e.g following is the data:

_time service message Host
2022-07-08T05:47:22.029Z abc calling service 123 host123.com
2022-07-08T05:49:17.029Z abc Talking to service 123 host123.com
2022-10-11T01:00:39.029Z
abc calling service 123 host123.com
2022-10-11T01:02:46.029Z
abc Talking to service 123 host123.com

 

The expected data outcome would be:

Host starting_time
host123.com 2022-07-08T05:47:22.029Z
host123.com 2022-10-11T01:00:39.029Z

 

I am aware I have to use streamstats somewhere. But given all the other fields are identical earliest time by host wont work. Also I am backdating the data for 6 months so I need something that is bit efficient. I only care about starting_time of the service of each time the service starts.

Labels (2)
0 Karma

ITWhisperer
SplunkTrust
SplunkTrust
| where message = "calling service 123"
0 Karma
Get Updates on the Splunk Community!

Splunk Observability Cloud | Unified Identity - Now Available for Existing Splunk ...

Raise your hand if you’ve already forgotten your username or password when logging into an account. (We can’t ...

Index This | How many sides does a circle have?

February 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

Registration for Splunk University is Now Open!

Are you ready for an adventure in learning?   Brace yourselves because Splunk University is back, and it's ...