UCCX 11.6 - CUIC -how to get list of members in Groups

[lleweyiss]

UCCX 11.6 - HA pair - co-resident CUIC. 
I would like a list of what agents are in the CUIC groups.  Yes , when looking a that the CUIC Admin, it has a small box with list of names you can scroll down through,  but you can't  copy then into something (like Excel or Word ) to do some comparisons.

Is there some sql command in the CLI  to run ?

The CUIC references userID,  UCCX list of Agents is by Name.  Only way in UCCX to get user ID is by selecting the Agent individually .  UCCX > Tool > User Management only pulls in 75 users from CUCM,  so I cant get a full list there without searching individually.

I am trying to compare UCCX agents and the Groups they are members of in CUIC.

So far its been a painfully tedious manual task ....  hoping for ideas or a sql command or something to make this easier.

[Ratheesh Kumar]

Hi there

Check out this command in CCX CLI

admin:run uccx sql db_cra select s.skillname, rsm.competencelevel, r.resourceLoginID,

Hope this Helps

Cheers
Rath!

***Please rate helpful posts and if applicable mark "Accept as a Solution"***

[lleweyiss]

Hi Rath,

That command is nice way to get the ID, Skill and Level out of the UCCX. 

But what I am looking for is a way or cli command to get a list of the  Members of the Groups in CUIC.

I did ask a TAC engineer and he has not found anyone that can say if there is such a way to get this list.

It would have been helpful if I could highlight all the names in the list (small box showing members) and copy .. but no that does not work

[peyton.gwinn]

find the groups a user belongs to in CUIC:

run sql SELECT gm.memberid,u.name,gm.groupid,g.name FROM cuic_data:cuicgroupmember gm INNER JOIN cuic_data:cuicuser u ON u.id==gm.memberid INNER JOIN cuic_data:cuicgroup g ON g.id==gm.groupid WHERE u.name LIKE ‘%username%'

find the members of a group in CUIC:

run sql SELECT gm.memberid,u.name,gm.groupid,g.name FROM cuic_data:cuicgroupmember gm INNER JOIN cuic_data:cuicuser u ON u.id==gm.memberid INNER JOIN cuic_data:cuicgroup g ON g.id==gm.groupid WHERE g.name = 'Supervisors'

queries were built from information in this post:

https://www.cisco.com/c/en/us/support/docs/customer-collaboration/unified-intelligence-center/211608-Troubleshoot-CUIC-User-Collection-Permis.html#anc3 

test in UCCX 15.0(1)