CUIC Gadget

Running CUIC Version:10.5(1) build 1 (10_5_1_10000_7) and Finesse Version 10.5

Hopefully this makes sense...

Is there a way to create a Agent Call Detail CUIC permalink report that can be used for each individual agent as a Gadget without the need to create multiple permalink reports? Let me know your thoughts.

Hi Steve,

One idea would be to create an Anonymous Block report definition with a parameter where they can enter their UserID and press Run.

Have a play with this.

Create the Report Definition as Anonymous Block with @UserName as a string.
You could create a value list for all Agents to make it easier for them to select their username on the filters.

SELECT

Queue = Variable3,

DateTime,

Agent.EnterpriseName as Agent,

Skill_Group.EnterpriseName as SkillGroup,

CASE TCD.CallDisposition

WHEN 1 THEN 'Abandoned in Network'

WHEN 2 THEN 'Abandoned in Local Queue'

WHEN 3 THEN 'Abandoned Ring'

WHEN 4 THEN 'Abandoned Delay'

WHEN 5 THEN 'Abandoned Interflow'

WHEN 6 THEN 'Abandoned Agent Terminal'

WHEN 7 THEN 'Short'

WHEN 8 THEN 'Busy'

WHEN 9 THEN 'Forced Busy'

WHEN 10 THEN 'Disconnect / Drop No Answer'

WHEN 11 THEN 'Disconnect / Drop Busy'

WHEN 12 THEN 'Disconnect / Drop Reorder'

WHEN 13 THEN 'Disconnect / Drop Handled Primary Route'

WHEN 14 THEN 'Disconnect / Drop Handled Other'

WHEN 15 THEN 'Redirected'

WHEN 16 THEN 'Cut Through'

WHEN 17 THEN 'Intraflow'

WHEN 18 THEN 'Interflow'

WHEN 19 THEN 'Ring No Answer'

WHEN 20 THEN 'Intercept Reorder'

WHEN 21 THEN 'Intercept Denial'

WHEN 22 THEN 'Time Out'

WHEN 23 THEN 'Voice Energy'

WHEN 24 THEN 'Non-Classified Energy Detected'

WHEN 25 THEN 'No Cut Through'

WHEN 26 THEN 'U-Abort'

WHEN 27 THEN 'Failed Software'

WHEN 28 THEN 'Blind Transfer'

WHEN 29 THEN 'Announced Transfer'

WHEN 30 THEN 'Conferenced'

WHEN 31 THEN 'Duplicate Transfer'

WHEN 32 THEN 'Unmonitored Device'

WHEN 33 THEN 'Answering Machine'

WHEN 34 THEN 'Network Blind Transfer'

WHEN 35 THEN 'Task Abandoned in Router'

WHEN 36 THEN 'Task Abandoned Before Offered'

WHEN 37 THEN 'Task Abandoned While Offered'

WHEN 38 THEN 'Normal Task End'

WHEN 39 THEN 'Cant Obtain Task ID'

WHEN 40 THEN 'Agent Logged Out During Task'

WHEN 41 THEN 'Maximum Task Lifetime Exceeded'

WHEN 42 THEN 'Application Path Went Down'

WHEN 51 THEN 'Task Ended During Application Init'

WHEN 53 THEN 'Partial Call'

ELSE 'Unknown'

END as CallDisposition,

TCD.DigitsDialed,

TCD.DNIS,

TCD.ANI,

TCD.TalkTime,

TCD.RingTime,

TCD.TimeToAband,

TCD.Duration,

TCD.HoldTime,

TCD.LocalQTime,

TCD.WorkTime,

CASE TCD.CallDispositionFlag

WHEN 1 THEN 'Handled'

WHEN 2 THEN 'Abandoned'

WHEN 3 THEN 'Short'

WHEN 4 THEN 'Disconnect'

WHEN 5 THEN 'Redirected'

WHEN 6 THEN 'Requery'

WHEN 7 THEN 'Incomplete'

ELSE 'Unknown'

END as CallDispositionFlag,

Agent.SkillTargetID

FROM

Termination_Call_Detail TCD JOIN

Agent ON TCD.AgentSkillTargetID = Agent.SkillTargetID JOIN

Skill_Group ON TCD.SkillGroupSkillTargetID = Skill_Group.SkillTargetID

WHERE Agent.EnterpriseName = :UserName

AND DateTime >= :startDate

AND DateTime <= :endDate

ORDER BY

            Agent.EnterpriseName ASC,

            DateTime ASC

Thanks Robert. I will give this a try and let you know the outcome.

Steve