Splunk Search

How to get the top 10 values of a column by another column?

vrmandadi
Builder
2015-09-02T14:01:02.228 Name=UPS6Z444706F2 Chkd_Out=Y DomID="Upstreamaccts\\racantr" Model="ProLiant WS460c Gen8 WS Blade" VideoAdapter="NVIDIA Quadro K3100M,HP Remote Graphics Driver" q_Action=reboot q_Status=SUCCESS q_DTRequest=1441219778.000 MenuID=43 RootName=RGFX Level1Name=Standard Type=Win7 Category=RGFX

Name = UPS6Z444706F2 
 host = UPSSQL15 
 source = dbmon-tail://WoRP/Worp_Reboot1 
 sourcetype = rgfx_Rebootstatus 

The above is one event of many. I want to know the top 10 Name by q_Action

Tags (2)
0 Karma
1 Solution

woodcock
Esteemed Legend

Like this:

sourcetype = rgfx_Rebootstatus | top limit=10 Name BY q_Action

View solution in original post

woodcock
Esteemed Legend

Like this:

sourcetype = rgfx_Rebootstatus | top limit=10 Name BY q_Action

vrmandadi
Builder

thank You.

0 Karma
Get Updates on the Splunk Community!

[Puzzles] Solve, Learn, Repeat: Dynamic formatting from XML events

This challenge was first posted on Slack #puzzles channelFor a previous puzzle, I needed a set of fixed-length ...

Enter the Agentic Era with Splunk AI Assistant for SPL 1.4

  🚀 Your data just got a serious AI upgrade — are you ready? Say hello to the Agentic Era with the ...

Stronger Security with Federated Search for S3, GCP SQL & Australian Threat ...

Splunk Lantern is a Splunk customer success center that provides advice from Splunk experts on valuable data ...