Export UCCX Agents

[zdesignstudio]

What do I need to do to export agents/supervisors from UCCX? I'm guessing I need to do a SQL query but I have no idea what db to connect to or what table everything is located in. I would like if possible to see all agents and assigned skills w/ levels, etc.

Exporting from v7.0(1)SR05_Build504

Thanks,

[Deepak Rawat · Accepted solution]

export agents/supervisors from UCCX

This cannot be done.

I would like if possible to see all agents and assigned skills w/ levels, etc.

This can be done using SQL DB connect to the Master DB if I remember it correctly since it had been a while I worked on windows based UCCX and then choose db_cra and run below query

select s.skillname, rsm.competencelevel, r.resourceLoginID, r.extension, r.resourceFirstName, r.ResourceLastName,t.teamname from skill s inner join resourceskillmapping rsm on s.skillid = rsm.skillid inner join resource r on rsm.resourceskillmapid = r.resourceskillmapid join team t on r.assignedteamid = t.teamid where s.active = 't' and r.active = 't' order by s.skillname, competencelevel, resourceloginid

Regards

Deepak