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

Thanks for the code example dstaudt!  I can verify the suds-jurko client connection is successful with CUCM11.5. Python 2.7.12 suds-jurko 0.6 I was having trouble parsing the SOAP/suds selectCmDevice response with Python.  Some of the examples in the support forums and other blogs/sites were referencing the below for loop: for node in result['SelectCmDeviceResult']['CmNodes']:     for device in node['CmDevices']:         print device['Name'], device['DirNumber'], device['Description'] This would result in an error for me with: Traceback (most recent call last):   File "<stdin>", line 2, in <module> TypeError: tuple indices must be integers, not str I might be missing something simple not coming from a programming background but I thought I'd provide the solution I came up with to parse the SOAP response in case anyone else is struggling. for node in result['SelectCmDeviceResult']['CmNodes']['item']:     if node['CmDevices'] != None:         for device in node['CmDevices']['item']:              print device['Name'], device['DirNumber'], device['Description'] Suds also supports the dot notation to specify nested types so the below works as well: for node in result.SelectCmDeviceResult.CmNodes.item:     if node.CmDevices != None:         for device in node.CmDevices.item:              print device.Name, device.DirNumber, device.Description ... View more

Hi jszapipes,   Not sure if you found a solution but if you're not tied to using paramiko I was able to develop a script that reboots/restarts UC servers with pexpect from Dragan's info in the thread below.  I use this method with cron to schedule reboots, maint windows, etc.  Has been tested on 8.6 and 11.5 UC systems (CUCM, CUC, CCX, IMP).   https://supportforums.cisco.com/t5/ip-telephony/schedule-restart-of-cucm-service-in-cli-or-gui/td-p/1347232     ... View more

Hi Jacob, I'm experiencing the same thing.  Migrating from CUCM 8.6 to 11.5 the MGCP registration process is overwriting the mgcp call-agent ip defined to the FQDN that is in CUCM System>Server.  Since ip domain lookup is disabled on the gateway the registration fails.   Original Command mgcp call-agent 10.10.10.10 2427 service-type mgcp version 0.1 Command Observed in IOS mgcp call-agent sub01.company.com 2427 service-type mgcp version 0.1   VGW#show ccm-manager MGCP Domain Name: VGW.company.com Priority        Status                   Host ============================================================ Primary         Domain Name Unresolvable sub01.company.com   Gateway is a 2901 with IOS is 155-3.M5.   The only resolution I've found is putting the configuration in a second time, again with IP's and it works.   This is not observed with SCCP, limited to the MGCP portion (referencing IP's) of the IOS config and only on the initial 8.6 to 11.5 migration.   mgcp call-agent 10.10.10.10 2427 service-type mgcp version 0.1 ccm-manager redundant-host 10.10.10.11 10.10.10.12   ... View more

Thanks for the info Franck, after upgrading to OpenSSH 7.2 CCX 8.5.1.11004-25 DRS stopped working with the error: CiscoDRFFailure: Reason: Unable to access SFTP server or SFTP server too slow to respond. All other UC elements (CUCM, CUC, CER, CUPS) continued to work as expected. The ciphers that CCX 8.5 supports can be found in the OpenSSH logs /var/log/auth.log fatal: Unable to negotiate with x.x.x.x port xxxxx: no matching cipher found. Their offer: aes128-cbc,3des-cbc,blowfish-cbc,aes192-cbc,aes256-cbc,arcfour,arcfour128,arcfour256 [preauth] To re-enable aes256-cbc you can add the below to the /etc/ssh/sshd_config file, restart the sshd service on your SFTP server and DRS will continue to work. Ciphers +aes256-cbc OpenSSH man page for sshd_config: Ciphers specifies the ciphers allowed.  Multiple ciphers must be comma-separated.  If the specified value begins with a ‘+’ character, then the specified ciphers will be appended to the default set instead of replacing them. The supported ciphers are: 3des-cbc, aes128-cbc, aes192-cbc, aes256-cbc, aes128-ctr, aes192-ctr, aes256-ctr,    aes128-gcm@openssh.com, aes256-gcm@openssh.com, arcfour, arcfour128, arcfour256, blowfish-cbc, cast128-cbc, chacha20-poly1305@openssh.com The default is: chacha20-poly1305@openssh.com,aes128-ctr,aes192-ctr,aes256-ctr,aes128-gcm@openssh.com, aes256-gcm@openssh.com The list of available ciphers may also be obtained using the -Q option of ssh(1) with an argument of “cipher”. ... View more

Thanks for sharing that info Dragan.  I used your script to reboot UCCX servers periodically, I just needed to modify the poweroff statements to what the UCCX (or any UC cli) will expect/output. child.sendline('utils system restart') child.expect('Enter (yes/no)?') child.sendline('yes') child.expect(' Appliance is being Restarted ...') ... View more