Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- Cisco Community
- :
- About derek.fraser
Online
Stats
Member since
09-26-2013
25
Posts
19
Helpful
1
Solution
Created by
derek.fraser
in Contact Center
in Contact Center
08-16-2019
11:40 AM
08-16-2019
11:40 AM
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
Created by
derek.fraser
in Contact Center
in Contact Center
04-02-2019
02:54 PM
04-02-2019
02:54 PM
Awesome info Deepak! +5 sir, very much appreciated. I've done this with the API but a direct SQL query is really helpful. I can verify it's working with 11.6.1.10000-51
... View more
03-13-2019
01:14 PM
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
Created by
derek.fraser
in Management
in Management
12-28-2018
12:35 PM
12-28-2018
12:35 PM
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
12-21-2018
06:23 AM
Thanks for the reference Anthony! Retro debugging vs reactive...very cool. Your posts are awesome and definitely a benefit to the community. Much appreciated sir!
... View more
12-20-2018
03:35 PM
Thank you Jonathan for the tip! +5!!! It was painful performing a reactive debug over a WAN circuit through VPN. Painful enough to google a solution while the editor was taking a slow stroll through the script. Some enjoy long walks on the beach...but it's well worth the effort to install the CCX editor on a VM or jumpbox in the data center/onsite.
... View more
Created by
derek.fraser
in Contact Center
in Contact Center
12-13-2018
12:04 PM
12-13-2018
12:04 PM
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
Created by
derek.fraser
in Other Collaboration Subjects
in Other Collaboration Subjects
11-05-2018
08:41 AM
11-05-2018
08:41 AM
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
Created by
derek.fraser
in IP Telephony and Phones
in IP Telephony and Phones
10-24-2018
10:12 AM
10-24-2018
10:12 AM
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
Created by
derek.fraser
in Other Collaboration Subjects
in Other Collaboration Subjects
10-01-2018
01:51 PM
10-01-2018
01:51 PM
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
Created by
derek.fraser
in IP Telephony and Phones
in IP Telephony and Phones
10-01-2018
01:12 PM
10-01-2018
01:12 PM
Thank you Mark and Brian, nice work +5. I can confirm this works on CUCM 11.5 and was helpful when querying MOH settings for devices (CTI Ports from CCX Triggers).
... View more
Created by
derek.fraser
in Management
in Management
09-04-2018
07:36 AM
09-04-2018
07:36 AM
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
Created by
derek.fraser
in Management
in Management
08-20-2018
01:05 PM
08-20-2018
01:05 PM
I've struggled with this one before as well. Not sure what CUCM version you're running but on 11.5 the phonetemplate table uses tkmodel as the identifier for phone button templates which is stored as a numeric value instead of a string. To view Cisco's defined correlation between numeric value/models you can query the typeproduct table:
select name,tkmodel from typeproduct
The enum value exists in the phonetemplate table as tkmodel so you can inner join on that value:
select p.name from phonetemplate as p inner join typemodel as tm on p.tkmodel=tm.enum where tm.name='Cisco 6961'
... View more
Created by
derek.fraser
in Collaboration, Voice and Video Documents
in Collaboration, Voice and Video Documents
08-16-2018
11:38 AM
08-16-2018
11:38 AM
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
Created by
derek.fraser
in Management
in Management
05-07-2018
10:27 AM
05-07-2018
10:27 AM
There a couple client choices for python to generate a soap request to access data from CUCM. Not trying to reinvent the wheel I used examples that were readily available online for another client that hasn't been updated/supported in a while. At the recommendation of another engineer I wanted to challenge myself to migrate to a modern/actively maintained soap client for python, which leads us to zeep. Some benefits of zeep is the project is actively maintained, python2/3 support, faster than other clients (definitely noticeable on larger UC clusters), good documentation and some nice helper features. There are limited examples available with zeep (especially UC related) so I thought I'd share a RISPort70 request to CUCM 11.5 and some of the hurdles I had getting it working in hopes it might benefit others. First off, read the docs. Zeep has some good documentation and an active community. Familiarize yourself with the wsdl you're working with, Cisco provides really nice docs in the DevNet API Developer Guide: https://developer.cisco.com/site/sxml/documents/api-reference/risport/ Another tool that helped me out was using SoapUI to examine the wsdl, zeep also comes bundled with a wsdl inspector that helps view the client operations.
python -mzeep <wsdl>
I got tripped up on selectCmDevice as it has some nested complex data objects. I tried passing the client straight kwargs for the selection criteria, which worked but did not honor the complex data "SelectItems" (at least with child dictionaries in the parent kwargs). This led me to creating a factory with zeep that we can use to send the nested data to CUCM. The zeep history plugin really helped me out, you can view your sent/received soap envelope to see if your constructing the xml the way the DevNet guide expects. My use case is more focused towards all registered phones in the cluster, but included is a loop to iterate over a list of mac addresses in case individual devices are desired. Hopefully the below can help, thanks again for the great community! Python 3.5.2 Zeep 2.5.0 CUCM 11.5.1(SU4)
from zeep import Client
from zeep.cache import SqliteCache
from zeep.transports import Transport
from zeep.plugins import HistoryPlugin
from requests import Session
from requests.auth import HTTPBasicAuth
from lxml import etree
import urllib3
urllib3.disable_warnings(urllib3.exceptions.InsecureRequestWarning)
username = 'username'
password = 'password'
wsdl = 'file:///path/to/RISService70.wsdl'
session = Session()
session.verify = False
session.auth = HTTPBasicAuth(username, password)
transport = Transport(cache=SqliteCache(), session=session, timeout=20)
history = HistoryPlugin()
client = Client(wsdl=wsdl, transport=transport, plugins=[history])
factory = client.type_factory('ns0')
macs = ['SEP111122223333', 'SEP222233334444'] #'*' for all
item=[]
for mac in macs:
item.append(factory.SelectItem(Item=mac))
Item = factory.ArrayOfSelectItem(item)
stateInfo = ''
criteria = factory.CmSelectionCriteria(
MaxReturnedDevices = 1000,
DeviceClass='Phone',
Model=537, #255 for all
Status='Registered',
NodeName='',
SelectBy='Name',
SelectItems=Item,
Protocol='Any',
DownloadStatus='Any'
)
result = client.service.selectCmDevice(stateInfo, criteria)
print(result)
#troubleshooting soap envelope
for hist in [history.last_sent, history.last_received]:
print(etree.tostring(hist["envelope"], encoding="unicode", pretty_print=True))
... View more
Labels:
Created by
derek.fraser
in Contact Center
08-16-2019
08-16-2019
This is a great thread/discussion. I landed here researching get/set
enterprise call info steps to p...
Created by
derek.fraser
in Contact Center
04-02-2019
04-02-2019
Awesome info Deepak! +5 sir, very much appreciated. I've done this with
the API but a direct SQL que...
03-13-2019
Nice fix J_B(+5). I ran into the same problem as you and dawson. Call
Manager allows you to create a...
Created by
derek.fraser
in Management
12-28-2018
12-28-2018
Hi Josh, I faced the same issue researching a solution to reboot Contact
Centers at set intervals fo...
12-21-2018
Thanks for the reference Anthony! Retro debugging vs reactive...very
cool. Your posts are awesome an...
12-20-2018
Thank you Jonathan for the tip! +5!!! It was painful performing a
reactive debug over a WAN circuit ...
Created by
derek.fraser
in Contact Center
12-13-2018
12-13-2018
Searching around the internet and support forums led me to this thread.
There still doesn't look to ...
Created by
derek.fraser
in Other Collaboration Subjects
11-05-2018
11-05-2018
Thanks Sriram! +5, I couldn't find any documented database dictionaries
for CER and your post led me...
10-24-2018
Hi Chi, not sure if you found a resolution to your issue but looking at
the screenshot you sent, I'v...
Created by
derek.fraser
in Other Collaboration Subjects
10-01-2018
10-01-2018
In case anyone runs into this thread in CUCM v11.5 if a file in Media
Resources/Music On Hold Audio ...
Created by
derek.fraser
in IP Telephony and Phones
10-01-2018
10-01-2018
Thank you Mark and Brian, nice work +5. I can confirm this works on CUCM
11.5 and was helpful when q...
09-04-2018
There are some tricks you can do to get around the 1000 limit query
result, but as you mentioned it'...
Created by
derek.fraser
in Management
08-20-2018
08-20-2018
I've struggled with this one before as well. Not sure what CUCM version
you're running but on 11.5 t...
08-16-2018
Excellent article Sreekanth, I've referenced many times as bulk gateway
modification isn't a normal ...
Public Statistics
| Date Registered | 09-26-2013 09:50 AM |
| Date Last Visited | 08-16-2019 11:31 AM |
| Total Messages Posted | 25 |
| Total Helpful Votes Received | 19 |
Helpful Votes Given To
