topic Re: AXL SQL & Phone Protocol Specific Information in Management

AXL SQL & Phone Protocol Specific Information

Gordon Ross — Thu, 03 Apr 2014 16:30:03 GMT

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

GTG

Re: AXL SQL & Phone Protocol Specific Information

tinghche — Thu, 03 Apr 2014 16:51:05 GMT

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

Re: AXL SQL & Phone Protocol Specific Information

Gordon Ross — Thu, 03 Apr 2014 17:23:17 GMT

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

Re: AXL SQL & Phone Protocol Specific Information

tinghche — Wed, 09 Apr 2014 20:46:02 GMT

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