Nice fix J_B(+5).  I ran into the same problem as you and dawson.  Call Manager allows you to create a role with just read/update to the "User web pages".  That role is then assigned to an Access Control Group, which is assigned to the lower tier HelpDesk End User (Standard CCM Admin Users is required as well for web page login/access).  Now the HelpDesk staff can login to CUCM and only view End User pages, all other pages return "User is not authorized to access this page".  With access to the End User pages they can update passwords for your customers/users...great...the problem is they can also update the Access Control Groups (lower down on the same page) to elevate their own privileges.  J_B provided a nice workaround: Create User Rank 2 Create Tier_1 Role, Assign "User web pages" read/update Create Tier_1 Access Control Group as Rank 2 Assign Tier_1 Role and Standard CCM Admin Users Role to Tier_1 Access Control Group Configure the HelpDesk End User's User Rank: 2 and Access Control Group: Tier_1 The HelpDesk user can now view Rank 1 users but the Add/Remove Access Control Group buttons are gone.  If the Rank 2 user browses to their own End User profile they can only see Rank 2 Access Control Groups (ie Tier_1).  They don't have the ability to modify User Rank on Rank 1 users (greyed out), on existing Rank 2 or "Add New" users the only option presented from CUCM is Rank 2 (not allowing them to change themselves back to Rank 1). This is definitely a unique scenario where your use case is to have a HelpDesk user only able to reset passwords. ...it's kind of like CSS' for End Users CUCM: 11.5.1.14900-11 ... View more

Hi Josh, I faced the same issue researching a solution to reboot Contact Centers at set intervals for best practice.  Another use case is gracefully shutting down UC servers for scheduled maintenance.  In smaller clusters it's not a problem babysitting the cli but it doesn't really scale well.  Since the UC appliance OS doesn't allow scheduling these power related tasks I put together a python script from Dragan's info at this thread: https://supportforums.cisco.com/t5/ip-telephony/schedule-restart-of-cucm-service-in-cli-or-gui/td-p/1347232 Below is a python3 script that utilizes the pexpect module to either restart or shutdown a UC appliance.  I use it regularly with cron for scheduled restarts and maintenance windows.  Hope you can find it useful. #!/usr/bin/python3 #This script utilizes pexpect to ssh to a cisco unified communications server #and restart or shutdown the system. This script provides the ability to schedule #graceful power related tasks via cron for maintenance windows and reboot best #practices. Tested on CUCM/CUC/CCX/CER/IMP/PLM v. 7.x, 8.x 11.x #os for environemnt variables and file attributes, argv for cli argument variable #pexpect for connecting to uc device, time for file timestamps import os, sys, pexpect, time #dictionary for command and expected result uc_commands = { 'restart': ' Appliance is being Restarted ...', 'shutdown': ' Appliance is being Powered - Off ...' } #verify command line arguments and display usage if incorrect if len(sys.argv) != 3 or sys.argv[2] not in uc_commands: print('Usage:python3', sys.argv[0].split('/')[-1],'[ip] [restart/shutdown]') exit() #define global variables script, ip, command = sys.argv username = os.environ.get('UC_CLI_USER') password = os.environ.get('UC_CLI_PASS') command_result = uc_commands[command] #display start date/time and hostname print('~'*79) print(time.strftime("%m/%d/%Y %H:%M:%S"), ': Conntecting to %s' % ip) #pexpect commands child = pexpect.spawn('ssh -o "StrictHostKeyChecking=no" %s@%s' % (username, ip), encoding='utf-8') child.logfile_read = sys.stdout #_read so sent commands like password not logged child.delaybeforesend = .5 #increase send delay for legacy uc server cli child.expect('password:') child.sendline(password) child.expect('admin:') child.sendline('utils system %s' % command) child.expect('Enter (yes/no)?') child.send('y') #send individual characters for uc server cli interaction child.send('e') child.send('s') child.sendline() child.expect(command_result) time.sleep(90) #keep ssh connection active to give uc server time to shutdown child.close() #close ssh connection to server #display verification print('\n'+time.strftime("%m/%d/%Y %H:%M:%S"), ': %s command successfully sent.' % command) print('~'*79) ... View more

Searching around the internet and support forums led me to this thread.  There still doesn't look to be an elegant way of exporting/reading .aef files for comparison.  It would be nice to have the ability to read scripts outside of the Cisco Unified CCX Editor.  Looking through the CCX API docs on DevNet seems to focus more on the configuration of the CCX application itself (resources, applications, triggers, etc) instead of scripts.  I've had success with the process thomascollins shared (Print to PDF (native in Windows10), Select All, copy into Notepad++ (or text editor of choice for compare)).  Thought I'd share my experience in case someone else stumbles upon this thread and thanks for the workaround thomascollins +5!   CCX: 11.6.1.10000-51 Cisco Unified CCX Editor: 11.6(1.00) ... View more

Thanks Sriram! +5, I couldn't find any documented database dictionaries for CER and your post led me to a solution for a different CER sql query.  I was having trouble automating an export for ERL to switch port mapping.  The use case being if a switch is removed/replaced/decommissioned from the network there wasn't an easy way to see what ERL's were assigned.  The nightly CER Phone Tracking email alert is great to let you know if a switch is unreachable, but it doesn't specify any ERL info.  The gui allows you to manually export (ERL Membership/Switch Ports) but there are very limited scheduling functions in CER, definitely not as robust as CUCM.  The DRS process archives this info but isn't easy to browse the .tar files.  From the 'show tech systables' I was able to find the table which holds this data and setup a cron job to export with <pick your coding language of choice>.  Below is the query for ERL to switch port in case anyone finds it useful. run sql select sw.switchid, erl.name, sw.switchports from cerswitchport as sw inner join cererl as erl on sw.fkerl=erl.erlid order by sw.switchid ... View more

Hi Chi, not sure if you found a resolution to your issue but looking at the screenshot you sent, I've always excluded the ".loads" in the device configuration.  As others have mentioned, check the release notes on the version for upgrade path, make sure the files are on all CUCM nodes running the TFTP service, restart TFTP service and specify just the firmware name in CUCM.  A helpful way to check is ssh to the TFTP server and run "file list tftp *SCCP42*" (without quotes). ... View more

In case anyone runs into this thread in CUCM v11.5 if a file in Media Resources/Music On Hold Audio File Management is being referenced by a stream in Media Resources/Music On Hold Server Audio Source the delete check box will not appear. You need to remove the dependency to the MOH Audio Source before deleting from MOH File Mangement. (not sure why there isn't a 'dependency record dropdown for this element) ... View more

There are some tricks you can do to get around the 1000 limit query result, but as you mentioned it's not a perfect solution.  What I've discovered working with RisPort70 is the '1000 results' are per query, so if you adjust your CmSelectionCriteria to key in on what you're looking for that can help.  One method I've used is loop through the model enum values you have configured on your system.  Basically multiple SOAP queries and keep appending to your destination variable/file/etc (per the DevNet docs RisPort70 will accept 15 requests per minute).  Depending on how you've setup your Call Manager Groups, type of phone models and the size of your deployment it might be worth exploring to get the data your looking for.   If you're just interested in a number of registered phones the SelectCmDevice response contains a TotalDevicesFound based on your search criteria, which might be helpful even if your results are truncated to 1000 (DeviceClass='Phone', Status='Registered').   Another option might be to use SNMP to query the ccmRegisteredPhones (.1.3.6.1.4.1.9.9.156.1.5.5.0) OID.  I've had success with this method making a dashboard for techs/mgmt to quickly check reg phone count but it won't give you the extended info that the RisPort70 API does.  ***The above OID is node based, so you'll have to query/aggregate all the CMNodes in your system. ... View more

Excellent article Sreekanth, I've referenced many times as bulk gateway modification isn't a normal day to day task.  I wanted to share my experience with the community in case it could help someone in the future.  Removing the commas (referenced in step 8) was necessary for the 8.6 BAT Import/Export utility but after upgrading to 11.5 removing the commas results in a failure.  A straight export/modify csv/tar/import now works as expected in my testing for 11.5.   Tested Versions: CUCM 8.6.2.22900-9 (remove extra commas in editor of choice) CUCM 11.5.1.14900-11(export/modify csv/tar/import)   ... View more

Thanks for the info Jonathan, yeah I was seeing that as well in troubleshooting how to parse the response.  I guess it depends on your search criteria as well, I was querying for phones in a registered status across all nodes.  A tuple is returned but depending on your CUCM CMGroup design there might not always be an expected CmNodes index that a phone is registered to.  So defining an explicit index (item[0] [1]) worked, but just wasn't giving me the data I was looking for. >>> print type(result.SelectCmDeviceResult) <class 'suds.sudsobject.SelectCmDeviceResult'> >>> print type(result.SelectCmDeviceResult.CmNodes) <class 'suds.sudsobject.ArrayOfCmNode'> >>> print type(result.SelectCmDeviceResult.CmNodes.item) <type 'list'> >>> for node in result.SelectCmDeviceResult.CmNodes: ...     print type(node) ... <type 'tuple'> >>> print result (selectCmDeviceReturn){    SelectCmDeviceResult =       (SelectCmDeviceResult){          TotalDevicesFound = 1          CmNodes =             (ArrayOfCmNode){                item[] =                   (CmNode){                      ReturnCode = "NotFound"                      Name = "ccm-pub01"                      NoChange = True                      CmDevices = None                   },                   (CmNode){                      ReturnCode = "NotFound"                      Name = "ccm-sub01"                      NoChange = False                      CmDevices = None                   },                   (CmNode){                      ReturnCode = "NotFound"                      Name = "ccm-sub02"                      NoChange = False                      CmDevices = None                   },                   (CmNode){                      ReturnCode = "Ok"                      Name = "ccm-sub03"                      NoChange = False                      CmDevices =                         (ArrayOfCmDevice){                            item[] =                               (CmDevice){                                  Name = "SEPXXXXXXXXXXXX"                                  DirNumber = "XXXXXXXXXX-Registered"                                  DeviceClass = "Phone"                                  Model = 111                                  Product = 111                                  BoxProduct = 0                                  Httpd = "Yes"                                  RegistrationAttempts = 0                                  IsCtiControllable = True                                  LoginUserId = "XXXXXXXXXX"                                  Status = "Registered"                                  StatusReason = 0                                  PerfMonObject = 2                                  DChannel = 0                                  Description = "Phone Description"                                  H323Trunk =                                     (H323Trunk){                                        ConfigName = None                                        TechPrefix = None                                        Zone = None                                        RemoteCmServer1 = None                                        RemoteCmServer2 = None                                        RemoteCmServer3 = None                                        AltGkList = None                                        ActiveGk = None                                        CallSignalAddr = None                                        RasAddr = None                                     }                                  TimeStamp = 1111111111                                  Protocol = "SIP"                                  NumOfLines = 1                                  LinesStatus =                                     (ArrayOfCmDevSingleLineStatus){                                        item[] =                                           (CmDevSingleLineStatus){                                              DirectoryNumber = "XXXXXXXXXX"                                              Status = "Registered"                                           },                                     }                                  ActiveLoadID = "firmware"                                  InactiveLoadID = "firmware"                                  DownloadStatus = "Unknown"                                  DownloadFailureReason = None                                  DownloadServer = None                                  IPAddress =                                     (ArrayOfIPAddressArrayType){                                        item[] =                                           (IPAddressArrayType){                                              IP = "x.x.x.x"                                              IPAddrType = "ipv4"                                              Attribute = "Unknown"                                           },                                     }                               },                         }                   },                   (CmNode){                      ReturnCode = "NotFound"                      Name = "ccm-sub04"                      NoChange = False                      CmDevices = None                   },                   (CmNode){                      ReturnCode = "NotFound"                      Name = "ccm-sub05"                      NoChange = False                      CmDevices = None                   },                   (CmNode){                      ReturnCode = "NotFound"                      Name = "ccm-sub06"                      NoChange = False                      CmDevices = None                   },                   (CmNode){                      ReturnCode = "NotFound"                      Name = "ccm-sub07"                      NoChange = False                      CmDevices = None                   },             }       }    StateInfo = "...some state info omitted" } This is coming from a non-programming background so that was just the method I came up with (mostly trial and error with the Python interpreter, and lots of forum crawling).  If there is a more efficient or elegant solution I'm definitely in! ... View more