Avaya CMS Designer Report – List of Dialed Numbers By Agent
Has anyone ever built a report that lists the dialed numbers by an agent. I know the dialed number is captured in the trace report, but I need something much simpler that just shows: Agent, Date, Time, Dialed #. I’ve tried so many query options and just cannot seem to get the data to appear.
Question asked by Mark
Answer for Avaya CMS Designer Report – List of Dialed Numbers By Agent
From what you said it looks like you have found the Agent Trace by Location report with DIGITS_DIALED
Have you tried looking at the Call Detail Records CDRs? You should be able to find it there.
I think that it is in the Call Records report under DIALED_NUM
With thanks to Jonty
Avaya Historical Report – Find Which Agent Took A Call From Outside Number
Hi, looking for a way to find out which agent took a call from a specific number. Does anyone have an idea how to create this report?
With thanks to Chris
Try Looking At These
– Agent Trace by Location report with DIGITS_DIALED
– Call Detail Records CDRs
– Call Records report under DIALED_NUM
With thanks to Jonty
Customize Agent Trace Report
I done this by customizing the agent trace report. Try copying the report and change the query. In ‘Where’ add “Direction=2” (2 is for IN, 1 is for OUT).
Here is the complete query I done by copying the report ‘agent trace by location’:
Select
ROW_DATE, EVENT_TIME, WORKMODE, DIRECTION, SPLIT, DURATION, CALLING_PTY FROM ag_actv
Where
ROW_DATE = [Fechas:] and STARTTIME = [Intervalo:] and LOGID = [Agente:] and DIRECTION=2 and ACD=$acd
With thanks to Diego
Author: Jonty Pearce
Published On: 12th Apr 2022 - Last modified: 19th Apr 2022
Read more about - Archived Content
