[cisco-voip] UCCX Reporting

[Brian Meade]

Just to update everyone, I made some SQL queries to give me what I was
looking for.  Here it is with some data:

admin:run uccx sql db_cra select
CRD.STARTDATETIME,CCD.applicationname,CCD.calledNumber,CRD.QUEUETIME,R.resourceLoginID
as agent from ContactRoutingDetail as CRD left join AgentConnectionDetail
as ACD on CRD.SESSIONID=ACD.SESSIONID left join ContactCallDetail as CCD on
CRD.SESSIONID=CCD.SESSIONID left join resource as R on
ACD.resourceID=R.resourceID where CRD.QUEUETIME > '500'
STARTDATETIME   APPLICATIONNAME CALLEDNUMBER    QUEUETIME       AGENT
----------------------------------------------------------
2013-07-14 12:07:53.075 MSC_Helpdesk    7793    750     FakeAgentName1
2013-07-14 12:07:53.075 MSC_Helpdesk    7793    750     FakeAgentName2
2013-07-14 12:07:53.075 MSC_Helpdesk    7793    750     FakeAgentName3
2013-07-14 12:26:07.93  MSC_Helpdesk    7799    958     null

Thanks,
Brian


On Thu, Sep 18, 2014 at 4:35 PM, Anthony Holloway <
avholloway+cisco-voip at gmail.com> wrote:

> Looks like the report you want is: Detailed Call by Call CCDR Report
> <http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_0/user/guide/UCCX_BK_UE5BE47D_00_uccx-historical-reports-ug/UCCX_BK_UE5BE47D_00_uccx-historical-reports-ug_chapter_011.html#UCCX_RF_D3613427_00>
>
> However, just like the rest of us, UCCX reporting falls short, and there
> is no way to filter based on Queue Time, even though the report output has
> it as a column.  So, what we tend to do at this point is, we export the
> report into excel, massage the data a little, and then use auto filter to
> sort and filter based on the column of your choosing.
>
> In CUIC and HRC, the report filters are the same, but you may be able to
> add the queue time column to a report that doesn't have it by default.  But
> it's not super flexible so don't hold your breath.
>
> I hope that helped.
>
> Here's the Reporting User Guide:
>
> http://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_0/user/guide/UCCX_BK_UE5BE47D_00_uccx-historical-reports-ug.html
>
> Here's the Reporting Admin and Developer guide:
>
> http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_0/programming/guide/uccx90hrepadm.pdf
>
> Here's the UCCX DB Schema:
>
> http://www.cisco.com/c/dam/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/crs/express_9_0/user/guide/uccx90dbschemagd.pdf
>
>
>
> On Thu, Sep 18, 2014 at 11:33 AM, Brian Meade <bmeade90 at vt.edu> wrote:
>
>> Hey all,
>>
>> I know nothing about UCCX reporting.  Does anyone know if there's a
>> canned report I can pull to see how many calls had hold times greater than
>> x minutes?
>>
>> If not, do you know where in the DB this info is stored so I can write a
>> query?
>>
>> Thanks,
>> Brian
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> https://puck.nether.net/mailman/listinfo/cisco-voip
>>
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20140919/f9e1c890/attachment.html>