Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

UCCX 8.5 database table name for agent names

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

Everyone's tags (5)
1 ACCEPTED SOLUTION

Accepted Solutions
Silver

Re: UCCX 8.5 database table name for agent names

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

2 REPLIES
Silver

Re: UCCX 8.5 database table name for agent names

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

New Member

UCCX 8.5 database table name for agent names

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

1349
Views
0
Helpful
2
Replies
CreatePlease to create content