Splunk Search

query to get top 10 users

splunkuseradmin
Path Finder

Hello everybody,

I am getting data in "index=test", I am trying to get top 10 Calling userid's with there call count.
device_type="device1" so far i have

thanks

Tags (1)
0 Karma

renjith_nair
Legend

@splunkuseradmin ,

Try

index="collab_uc_cdr" NOT INTEGER NOT globalCallID_callId 
( sourcetype=cisco_cdr OR sourcetype=cisco_cdr-* OR sourcetype=cucm_cdr ) ( globalCallId_ClusterID=AMR-Corp-CCM11XX OR globalCallId_ClusterID=AMR-Corp-CCM12XX OR globalCallId_ClusterID=AMR-Corp-CCM13XX OR globalCallId_ClusterID=AMR-Corp-CCM14XX OR globalCallId_ClusterID=AMR-Corp-CCM15XX ) duration>0   device_type="Jabber" eventtype="outgoing_call" 
|stats count by globalCallId_ClusterID,callingPartyUnicodeLoginUserID 
|sort - count |head 10
---
What goes around comes around. If it helps, hit it with Karma 🙂
0 Karma
Get Updates on the Splunk Community!

Index This | What is broken 80% of the time by February?

December 2025 Edition   Hayyy Splunk Education Enthusiasts and the Eternally Curious!    We’re back with this ...

Unlock Faster Time-to-Value on Edge and Ingest Processor with New SPL2 Pipeline ...

Hello Splunk Community,   We're thrilled to share an exciting update that will help you manage your data more ...

Splunk MCP & Agentic AI: Machine Data Without Limits

Discover how the Splunk Model Context Protocol (MCP) Server can revolutionize the way your organization uses ...