Splunk Search

How to return associated fields based on stats command

steverimar
Explorer

I'm trying to return the associated fields based on a stats command. My stats command determines the minimum field value based on two other fields. I need the remaining fields associated with the record that has this minimum value.

For example, my data looks like this:

Project RequestID TaskID Resolution
   A        1       1      Fixed
   A        1       2    Withdrawn
   A        1       3     Deleted
   B        2       4     On Hold
   B        2       5     Created

I want to return a table like this:

Project RequestID TaskID Resolution
   A        1       1      Fixed
   B        2       4     On Hold

How is this achieved since stats requires you to either use a function or group by to return the values? I don't want either, I just need the associated fields based on the minimum value of another field.

Thanks!!

Tags (2)
0 Karma
1 Solution

_d_
Splunk Employee
Splunk Employee

Try this:

<search that produces the table above> | eventstats min(TaskID) as min_task min(RequestID) as min_req by Project | where (RequestID=min_req AND TaskID=min_task) | fields - min*

View solution in original post

_d_
Splunk Employee
Splunk Employee

Try this:

<search that produces the table above> | eventstats min(TaskID) as min_task min(RequestID) as min_req by Project | where (RequestID=min_req AND TaskID=min_task) | fields - min*
Get Updates on the Splunk Community!

Why You Can't Miss .conf25: Unleashing the Power of Agentic AI with Splunk & Cisco

The Defining Technology Movement of Our Lifetime The advent of agentic AI is arguably the defining technology ...

Deep Dive into Federated Analytics: Unlocking the Full Power of Your Security Data

In today’s complex digital landscape, security teams face increasing pressure to protect sprawling data across ...

Your summer travels continue with new course releases

Summer in the Northern hemisphere is in full swing, and is often a time to travel and explore. If your summer ...