Splunk Search

Search For max value in Stats within Multiple Search outputs

rbhatta99
Engager

Hello,

I have this search query 

 

 

index=app  iNumber IN (72061271737983, 72061271737983, 72061274477906, 72061277215167) | stats count by notificationId, iNumber

 

 

 

This results in multiple notificationIds coming in for each iNumber in this list. What im trying to find out is the max notificationId value per iNumber, and output that list. Is there a way to do that? 
somthing like:

iNumber(Max)NotificationId
7206127173798312345
72061271737983 78787

 

Thank you!

Labels (1)
0 Karma
1 Solution

sjringo
Contributor

| stats max(notificationId) by iNumber

View solution in original post

0 Karma

sjringo
Contributor

| stats max(notificationId) by iNumber

0 Karma
Get Updates on the Splunk Community!

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 ...

Integrating Splunk Search API and Quarto to Create Reproducible Investigation ...

 Splunk is More Than Just the Web Console For Digital Forensics and Incident Response (DFIR) practitioners, ...

Congratulations to the 2025-2026 SplunkTrust!

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