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