02-03-2015 05:37 AM - edited 03-14-2019 02:24 PM
We have 206 users and the capability window only shows the first 76 agents. I've been tasked to generate a report which identifies both agents and supervisors separately.
Is there a way to export all of the data for the users, not just the first 76 and separate accordingly from this page?
Thank you, any help is greatly appreciated.
Solved! Go to Solution.
02-03-2015 06:38 AM
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
02-03-2015 06:38 AM
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
02-03-2015 07:13 AM
Thanks Aaron for the quick response.
Worked perfectly!
02-03-2015 07:18 AM
No problem :-)
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