cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
746
Views
15
Helpful
2
Replies
Highlighted
Beginner

sql query cucm end user that do not have phone association

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
Highlighted
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
Highlighted
Rising star

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 Chuck Taylor logo!
Highlighted
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

Content for Community-Ad