Deepak brings up a good point, CUIC doesn't seem to allow compounding filters, like Application AND Custom Variable 1.  Thanks lleweyiss (+5) for your solution, I can confirm as well that it works on CUIC 11.6 Standard (co-resident).   The documentation says CUIC appends a wildcard before and after the string, in my testing %Value% is the same as Value and both return Value1 and Value2.  In lleweyiss' example you can also filter explicit strings with a comma, it looks like CUIC supports filtering multiple strings with a wildcard too. Op%, Cl% returned Open Closed   Setting the Enterprise Call Info string with a known suffix could also work for filtering, I guess it's all how your data is structured.  It would definitely be nice to filter on Application AND not null (_%).   Field Filters   For String , select an Operator from Equal To, Not Equal To, or Matches and then enter a value for the string; for example, Operator = Matches and Value = Team Green. If you select Matches as the Operator, you must specify an SQL pattern to match the string field. The system appends the wild card character % automatically to the beginning and end of the string. You can also use any SQL wild card pattern in between the string. If the filter field is associated with a Value List , then specify any value or move one, all, or some items in the list to the Selected column to filter.   https://www.cisco.com/c/en/us/td/docs/voice_ip_comm/cust_contact/contact_center/intelligence_suite/intelligence_suite_1106/user/guide/cuic_b_cisco-unified-intelligence-center-user/cuic_b_cisco-unified-intelligence-center-user_chapter_010.html#topic_3030E7957CDBD62CD1E491930AA5139D  ... View more

This is a great thread/discussion.  I landed here researching get/set enterprise call info steps to pass variables to the Post Call Survey (more for CUIC reporting purposes, but this is excellent info).  Thanks Bruno and Anthony! +5 ... View more

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