Splunk Search

Top 1 for already selected values using query

Digvijay
Path Finder

Digvijay_0-1626335823022.png

 

Current query :

index=salcus sourcetype= ticket_mgmt_rest source= http:ticket_mgmt_rest |rename "properties.o2-TroubleTicket-ReqId" as REQID | transaction REQID keepevicted=true | search eventcount=2 |table REQID duration |sort -duration

 

Now I want only top 1 record which has maximum duration , so how can I modify above query

Labels (1)
0 Karma
1 Solution

ITWhisperer
SplunkTrust
SplunkTrust
| sort 1 -duration

View solution in original post

ITWhisperer
SplunkTrust
SplunkTrust
| sort 1 -duration

Digvijay
Path Finder

thanks @ITWhisperer   for the quick and perfect reply

0 Karma
Get Updates on the Splunk Community!

Stay Connected: Your Guide to November Tech Talks, Office Hours, and Webinars!

🍂 Fall into November with a fresh lineup of Community Office Hours, Tech Talks, and Webinars we’ve ...

Transform your security operations with Splunk Enterprise Security

Hi Splunk Community, Splunk Platform has set a great foundation for your security operations. With the ...

Splunk Admins and App Developers | Earn a $35 gift card!

Splunk, in collaboration with ESG (Enterprise Strategy Group) by TechTarget, is excited to announce a ...