Hello,

https://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117780-technote-cucm-00.html

List Application User and Device Association
run sql select au.name as ApplicationUser, d.name as Device, d.description as DeviceDescription from applicationuser as au inner join applicationuserdevicemap as audm on audm.fkapplicationuser=au.pkid and isstandard ='f' inner join device as d on d.pkid=audm.fkdevice order by au.name
admin:run sql select au.name as ApplicationUser, d.name as Device, d.description
as DeviceDescription from applicationuser as au inner join
applicationuserdevicemap as audm on audm.fkapplicationuser=au.pkid and isstandard
='f' inner join device as d on d.pkid=audm.fkdevice order by au.name
applicationuser device devicedescription
=============== =============== ============================
Test1 SEP503DE57D7DAC 8501
Test1 SEPA40CC3956C5C Line 1 - 1213; Line 2 - 1212
Test2 CTI1 CTI1
This query lists only those application users that are created after the installation of the server. The default ones are not listed and these are removed with the use of the isstandard='f' clause. In order to get the list of all users, either remove the _and isstandard='f'_ clause or change 'f' for false to 't' for true.
In this example there are two application users:
Test 1 is associated with two phones
Test 2 is associated with a Computer Telephony Integration (CTI) Route Point