05-30-2012 10:42 AM - edited 03-14-2019 09:57 AM
HI All
Does anyone happen to know which table stores the names of the agent? I'm trying to do reporting using qlikview and I can't seem to locate the correct table.
For example, in the contactcalldetails, there is a field called destinationdn which is a 4 digit extension. There must be another table that translate that into a name like John Smith. I can't seem to locate that table.
Thanks
Solved! Go to Solution.
05-30-2012 10:48 AM
Table name is Resource and the field name is resourceName.
DB schema can be found here: http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/user/guide/uccx85dbschema.pdf
hope this helps, please rate posts
05-30-2012 10:48 AM
Table name is Resource and the field name is resourceName.
DB schema can be found here: http://www.cisco.com/en/US/docs/voice_ip_comm/cust_contact/contact_center/crs/express_8_5/user/guide/uccx85dbschema.pdf
hope this helps, please rate posts
05-30-2012 10:59 AM
Thanks, that worked. The preview function in qlikview didn't show me any data so I thought the table was blank.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide