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"
Solved! Go to 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'
Here is a document that outlines what you may be looking for. Go to the section entitled:
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'