AXL SQL & Phone Protocol Specific Information

[Gordon Ross]

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

GTG

[tinghche]

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

Regards,

Howard

[Gordon Ross]

But that's just the protocol used by the device. What about the other fields in that section in CCMAdmin. e.g. BLF Presence Group & SUBSCRIBE Calling Search Space ?

GTG

[tinghche]

It will be pretty complicated.

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

https://developer.cisco.com/site/collaboration/management/axl/develop-and-test/documentation/latest-version/datadictiona…

Here is a screenshot of the table relationship to the phone.

Regards,

Howard