sql query cucm end user that do not have phone association

[Seski Ramadhan]

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"

[Andrew Skelly]

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

[Anthony Holloway · Accepted solution]

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'