Hi
I use SQL queries to grab this info.
For example, a quick user report for Supervisors:
run uccx sql db_cra select s.resourceLoginID, t.teamname from supervisor s inner join team t on s.managedteamid = t.teamid where s.active = 't' and t.active = 't' order by s.resourceloginid, t.teamname
And a quick one for agents with their skills/teams:
run uccx sql db_cra 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
Just paste those into the server CLI via Putty and log the output to text. You can then import that as a tab-sep-value file to Excel.
Aaron
Aaron
Please remember to rate helpful posts to identify useful responses, and mark 'Answered' if appropriate!
