Agent Call detail report with listing on each call

[hemal.mehta]

Is there a standard report to find out calls for an agent by time and details on each call.  I  just wanted to check before I start writing one.  I am not looking for the standard half hr type report.

[PCHoldmann]

Can you provide a little more information on the environment and the exact information you are looking for?

CCX or CCE? Version? CUIC or HR?

[hemal.mehta]

It is for CUIC report(8.5.4 ) & UCCE 8.X  setup. Thanks.

[PCHoldmann]

I am not familiar with what is available in CCE, but the Agent Detail report in CCX sounds like what you need. Not sure if that is available to you.

[david.macias]

You can look at a historical agent detail report, it should get your started.  More than likely you'll have to customize your own if you want to see PVs for each call.

david

[hemal.mehta]

Well I already know that.  The thing is that I do not want it by half hour.  I want visbility into each call, time, ani etc.  Just wanted to confirm if that indeed is a custom report and not a template that is already available.

[jimmy jain]

Hemal Try this one , gives most of the information

********************************************************************

select

ag.EnterpriseName as AgentName,

ms.EnterpriseName as ScriptName,

sg.EnterpriseName as skillgroup,

tcd.AgentPeripheralNumber,

tcd.DateTime,

tcd.Variable1,

tcd.Variable8,

tcd.Variable9,

tcd.Variable5,

tcd.Variable7,

tcd.ANI,tcd.DNIS,rcd.DialedNumberString,rcd.FinalObjectID,rcd.ScriptID,rcd.RouterErrorCode,tcd.CallDisposition,

tcd.SourceAgentPeripheralNumber,

*

from Termination_Call_Detail tcd  join

     Route_Call_Detail rcd

        on tcd.RouterCallKey = rcd.RouterCallKey

       and tcd.RouterCallKeyDay = rcd.RouterCallKeyDay    join

           prnt_awdb.dbo.Skill_Group sg

        on tcd.SkillGroupSkillTargetID = sg.SkillTargetID join

           prnt_awdb.dbo.Agent ag

        on tcd.AgentPeripheralNumber = ag.PeripheralNumber join

           prnt_awdb.dbo.Script s

        on rcd.ScriptID = s.ScriptID  join

           prnt_awdb.dbo.Master_Script ms

        on  s.MasterScriptID = ms.MasterScriptID

where AgentPeripheralNumber = 'xxxxxx'

[Gergely Szabo]

Hi,

people, please stop joining all rows of large table views like TCD with RCD. This might cause a serious performance impact on your AW/HDS server.

@hemal.mehta, can you please tell us what details are you interested in?

G.