Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 

CTS Manager - Verify device associations in CUCM

We have received a few cases when customer have at least 2 CTS-Man  servers active; as of now we only support 1. Both CTS Manager servers  are pushing multiple notifications for same meeting causing CTS to dial  incorrect meeting id when doing OBTP.

Unfortunately Cisco Unified Communication Manager Dependency Records  does not have the option to verify which Application Users are  associated to a particular Phone.
In order to do that, please verify the following:

1. Login via SSH to CUCM Publisher
2. Execute the following command:

run sql SELECT device.name, applicationuser.name FROM device INNER  JOIN applicationuserdevicemap ON device.pkid =  applicationuserdevicemap.fkdevice JOIN applicationuser ON  applicationuser.pkid = applicationuserdevicemap.fkapplicationuser
WHERE device.name = 'SEPMACADDRESS'

Replace SEPMACADDRESS with your Device Name, you can use LIKE sentence as well (For reference verify SQL Documentation)

Query above will return DeviceName and All Application Users associated to the Device

Example:

admin:run sql SELECT device.name, applicationuser.name FROM device  JOIN applicationuserdevicemap ON device.pkid =  applicationuserdevicemap.fkdevice JOIN applicationuser ON  applicationuser.pkid = applicationuserdevicemap.fkapplicationuser WHERE  device.name = 'SEP0019AA043E58'

name name
=============== ==========
SEP0019AA043E58 CTMappuser

1302
Views
0
Helpful
0
Comments