AXL SQL & Phone Protocol Specific Information

Problem:

Where is the phone's Protocol Specific Information stored in the database?

Solution: 

The Protocol information is in the table typedeviceprotocol

To retrieve what protocol a phone is using, you can use join to get from the database directly.

select  typedeviceprotocol.name from device inner join typedeviceprotocol on device.tkdeviceprotocol =  typedeviceprotocol.enum where device.name='SEPXXX'

Or, you can use getPhone API, to get the same information

Also you can refer to the Common Table Relationships section in the AXL Data Dictionary document below for more details

https://developer.cisco.com/docs/axl/#!12-5-cucm-data-dictionary