cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
1646
Views
15
Helpful
2
Replies

sql query cucm end user that do not have phone association

Seski Ramadhan
Level 1
Level 1

Hi All,

 

May i ask for help for run sql command in cli cucm to get those data

 

In CUCM you can get those data from

 

1. CUCM Page

2. User Management

3. End User

4. Find User where "No device/profile assigned"

 

Capture.PNG

1 Accepted Solution

Accepted Solutions

Anthony Holloway
Cisco Employee
Cisco Employee

Here's an additional tip to @Andrew Skelly 

 

Turn your CCMAdmin traces to debug, then setup a file tail on your publisher

 

file tail activelog tomcat/logs/ccmadmin/log4j recent

Then access the search in the web page.

 

You will then see that the following SQL command is executed to perform that search:

 

019-10-08 16:32:00,160 DEBUG [http-bio-443-exec-12992] actions.UserFindListAction - SELECT pkid, userid, keypadenteredalternateidentifier, firstname, lastname, department, directoryUri, status, tkUserProfile, fkdirectorypluginconfig, userrank FROM enduser WHERE ((NOT enduser.pkid IN (SELECT dv.fkenduser FROM device AS dv WHERE NOT fkenduser IS NULL UNION SELECT fkenduser FROM enduserdevicemap))) AND enduser.tkuserprofile='1'

View solution in original post

2 Replies 2

Andrew Skelly
Level 7
Level 7

Here is a document that outlines what you may be looking for.  Go to the section entitled: 

Find Phones that Do Not have a Line-Level User Association

https://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117726-technote-cucm-00.html

Please rate helpful posts by clicking the thumbs up!

Anthony Holloway
Cisco Employee
Cisco Employee

Here's an additional tip to @Andrew Skelly 

 

Turn your CCMAdmin traces to debug, then setup a file tail on your publisher

 

file tail activelog tomcat/logs/ccmadmin/log4j recent

Then access the search in the web page.

 

You will then see that the following SQL command is executed to perform that search:

 

019-10-08 16:32:00,160 DEBUG [http-bio-443-exec-12992] actions.UserFindListAction - SELECT pkid, userid, keypadenteredalternateidentifier, firstname, lastname, department, directoryUri, status, tkUserProfile, fkdirectorypluginconfig, userrank FROM enduser WHERE ((NOT enduser.pkid IN (SELECT dv.fkenduser FROM device AS dv WHERE NOT fkenduser IS NULL UNION SELECT fkenduser FROM enduserdevicemap))) AND enduser.tkuserprofile='1'
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: