UCCX 8.5 database table name for agent names

[jack_j_zheng]

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

[brian1mcc · Accepted solution]

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

[jack_j_zheng]

Thanks, that worked.  The preview function in qlikview didn't show me any data so I thought the table was blank.