Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
New Member

UCM 8.0, console sql query for IP addresses

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.

1 REPLY

UCM 8.0, console sql query for IP addresses

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

Please rate all helpful posts.
301
Views
0
Helpful
1
Replies
CreatePlease to create content