10-07-2019 11:39 PM
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.
10-08-2019 02:37 PM
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'
10-08-2019 08:54 AM
Here is a document that outlines what you may be looking for. Go to the section entitled:
10-08-2019 02:37 PM
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'
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: