CUCM SQL user CTI control device

To find the devices that a particular user has control of, where for example the user ID is rmaslanka1:

• run sql select enduser.userid, device.name from enduser,device,enduserdevicemap where enduserdevicemap.fkenduser=enduser.pkid and enduserdevicemap.fkdevice=device.pkid and enduser.userid = 'rmaslanka1'

To find the users that have control of a particular device, where for example the device name is SEPAAAABBBBCCC:

• run sql select enduser.userid, device.name from enduser,device,enduserdevicemap where enduserdevicemap.fkenduser=enduser.pkid and enduserdevicemap.fkdevice=device.pkid and device.name = 'SEPAAAABBBBCCC'