About ThomasADP

ThomasADP · ‎08-19-2015

hi, there is no "_" userID listed when i used this search `cdr_events` (type="outgoing" OR type="incoming") |eval userID=mvappend(finalCalledPartyUnicodeLoginUserID, callingPartyUnicodeLoginUserID ) | search userID=amares OR userID=sbordea OR userID=cserban OR userID=andran OR userID=vladr | `get_call_id` | stats dc(callId) as calls by userID

ThomasADP · ‎08-18-2015

Hi, 1) CMR records store information about the quality of the streamed , that's why we separate CDR index from CMR index. what is bad to do that ? 2) Even if 2 agents speak with one client it must be count like a call one to one . So it's ok for us. In General Report UI, "search terms" doesn't appear, i have "other termes" ,that's why i used raw search . there is always a difference between result VALUE in blue and the total of all agents Regards Thomas

ThomasADP · ‎08-17-2015

Hello, it's works ! , need just modify some details 🙂 index="cucm_cdr" OR index="cucm_cmr" sourcetype=cucm_cdr OR sourcetype=cucm_cmr NOT INTEGER NOT globalCallID_callId globalCallId_ClusterID=*(type="outgoing" OR type="incoming") |eval userID=mvappend(finalCalledPartyUnicodeLoginUserID, callingPartyUnicodeLoginUserID ) | search amares OR sbordea OR cserban OR andran OR vladr | top limit=20 day_of_week i would like to keep it like that but split by Total userID calls by day with one colors for each user, instead of total calls by day It's possible to keep the original order of day : monday , tue, web,thu,Fri ? PS: In public we can show all possibilities of Splunks Cisco CDR's , amazing ! 🙂 thanks Thomas

ThomasADP · ‎08-13-2015

Hi, thanks for your reponse , i was in holiday , i test that tomorow 😉 Thomas

ThomasADP · ‎08-05-2015

Hi all, I'm tring to count the number of times username appear in the result ,and display count by day with one color = one user: In the result : on incoming calls entries, field finalCalledPartyUnicodeLoginUserID ,there is username available on outgoing calls entries , field callingPartyUnicodeLoginUserID there is username available how i can created a variable table based on fields above : robert 15 mickeal 6 I start the query : index="cucm_cdr" OR index="cucm_cmr" sourcetype=cucm_cdr OR sourcetype=cucm_cmr NOT INTEGER NOT globalCallID_callId globalCallId_ClusterID=*(type="outgoing" OR type="incoming") | search rsmith OR maldo | top limit=20 day_of_week I must use | timechart sum at the end for display it as i want ? really need help 🙂 Thanks Thomas

Posts	5
Solutions	0
Karma Given	0
Karma Received	1
Member Since	‎08-05-2015

Online Status	Offline
Date Last Visited	‎06-05-2020 02:04 AM

Count Result on user name in CUCM CDR

Re: Count Result on user name in CUCM CDR

Re: Count Result on user name in CUCM CDR

Re: Count Result on user name in CUCM CDR

Re: Count Result on user name in CUCM CDR

Count Result on user name in CUCM CDR