Check UCCX agent skills using SQL query on CLI

The following SQL command will output a table reflecting current agent skill assignments.

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 = 't' and = 't' order by s.skillname, competencelevel, resourceloginid