cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
923
Views
0
Helpful
2
Replies

SQL query on cucm database for "access control groups",

stfarmfldw
Level 1
Level 1

would anyone know what is syntax for sql query to list out all "access control groups" in cucm 9.1? any help would be greatly appreciated. have not been able to find table listed as access control groups.

2 Replies 2

dstaudt
Cisco Employee
Cisco Employee

Looks like the 'dirgroup' table is what you are looking for:

admin:run sql select * from dirgroup

pkid                                name                                                                    isstandard

==================================== ======================================================================= ==========

d89fd7e3-f01f-ee3e-1464-48f94da7e85b Standard CCM Super Users                                                t        

40ca894c-cdf0-a1f9-f73a-8222240c67a1 Standard CCM Admin Users                                                t        

094a0c03-74ff-12ba-ac1c-d554a0567cc1 Standard CCM Read Only                                                  t        

5848401f-2cc4-5929-c6e7-b9253fa6dd5b Standard CCM Server Monitoring                                          t        

10613d57-eb46-d601-5064-bbc21d5ba87a Standard CCM Server Maintenance                                        t        

44f6659e-0258-236d-63c7-209dad42560c Standard CCM Phone Administration                                      t        

7421ac1e-0dcc-fde8-849b-183415e89699 Standard CCM Gateway Administration                                    t        

64a8af58-7a0d-4a06-a7e9-d8e033510cea Standard CTI Enabled                                                    t        

30e1bb3d-69b8-438f-89cc-e7ed931b8095 Standard CTI Allow Calling Number Modification                          t        

47b0de74-db3a-4be9-aa92-47a7921e0f26 Standard CTI Allow Call Park Monitoring                                t        

ee26a45b-e424-468a-a656-22e480e0c19f Standard CTI Allow Control of All Devices                              t        

5aa45cd8-2c5f-46c5-abc3-3e16380fbaa8 Standard CAR Admin Users                                                t        

7c2fdab8-7d4e-4171-b84c-0ca6c9aac1e4 Standard EM Authentication Proxy Rights                                t        

f17f95a6-c185-41a8-872e-70bfac7e634d Standard CCM End Users                                                  t        

58149578-97d0-4af1-adfc-fe7a175566f4 Standard Packet Sniffer Users                                          t        

53576043-7be1-48ea-92da-5794cca42b38 Standard CTI Secure Connection                                          t        

55bff9d7-a3b8-4eb6-ad95-03eb76bf19f5 Standard CTI Allow Reception of SRTP Key Material                      t        

72141a98-27b9-481e-9fb2-567212c201df Standard TabSync User                                                  t        

af032e82-bd68-4c3e-a27e-7e33cd797b3c Standard CTI Allow Call Monitoring                                      t        

0b5b7b9b-f261-447a-a9b9-3aefa73f0c0a Standard CTI Allow Call Recording                                      t        

26859fb4-6740-4aa6-a9e6-371f35faf63d Standard RealtimeAndTraceCollection                                    t        

3c873300-e510-47e2-a9c4-01b1bf4f4179 Standard Audit Users                                                    t        

e44fbaf6-9f81-4cc2-ae87-3727b1ce1c59 Standard CTI Allow Control of Phones supporting Connected Xfer and conf t        

4f550b75-8c5b-4bce-a358-f08834da2767 Standard CTI Allow Control of Phones supporting Rollover Mode          t        

f4550b75-8c5b-4bce-a358-f08834da2776 Standard Confidential Access Level Users                                t        

5940e920-328d-689b-0744-46386933a9fc Admin-3rd Party API                                                    t        

07592d51-c403-42da-83a5-39d458dc247e Application Client Users                                                t        

bd01f5f5-1da2-4802-b629-5f03012cb58e Third Party Application Users                                          t        

30f5ecbd-477b-e503-3ab3-6e1a3fec216a axlusers                                                                f        

16b806cb-efdc-2dfe-bfd6-8f9d1db54897 Serviceability Test Group                                              f        

fb2d3383-0037-bc96-243a-c25759da1e1d Serviceability Group                                                    f        

62487da0-6849-5006-9f97-20e38b78d087 ControlCenterAPITest                                                    f        

Yes thanks found this table today. Additionally found functionrolegroup and endusergroup. Just need to write a sql statement to put all three together. Looking to display access control group > a specific group > then the roles that the group has access to.

Thanks for your help.

Arthur

Sent from my iPhone

Arthur Chavez

Getting Started

Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: