UCM 8.0, console sql query for IP addresses

[George.D.Riddle]

I am looking for a sql statment in Call Manager that will pull IP addresses of IP phones. An example of the type of information I am trying to query is What phones in network X have this CSS space assigned? I can query phones and Assigned CSS space but I want to have the IP information as well. Looking through the data dictionary I have not found a table that has IP addresses?

Any assistance would be appreciated.

[Gordon Ross]

You can't do that, sorry.

The registered IP address isn't stored in the on-disc database (which is what is queried by the "run sql" command)

If you want to get the IP address of devices (and it's purely a "Get me the IP Address of device SEP112233445566" type of API) you need to use the RisPort API suite.

http://developer.cisco.com/web/sxml/home

GTG