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

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. And see here for current known issues.

New Member

UCM Data Dictionary SQL Query for Determining IP Address


I am trying to determine the IP address(es) of the UCM cluster servers.  Using the UCM Data Dictionary and tables such as 'processnode' will provide information such as


procnodename                      description                isactive macaddr procnodeid systemnode typenodename typeprocessnode
================================= ========================== ======== ======= ========== ========== ============ ====================
EnterpriseWideData                                           t                1          t          Subscriber   CUCM Voice/Video
usa109-s4pub01                    UCM 10.0 Publisher         t                2          f          Publisher    CUCM Voice/Video
usa109-s4sub01                    UCM 10.0 Subscriber        t                3          f          Subscriber   CUCM Voice/Video UC Presence 10.0 Publisher t                9          f          Publisher    CUCM IM and Presence UC Presence 10.0 Publisher t                11         f          Subscriber   CUCM IM and Presence


'callmanager' table does not provide a field for IP...'processnode' only had 'ipv6name' field...

If the node using DNS to resolve name-to-IP as shown above...I have not found a way to obtain the IP address of the UCM node itself.  I know I can go to the CLI of a node a issue a command to obtain...but I have not found a Data Dictionary table to obtain the results. 

I am open for suggestions...thx.


If, in CCMAdmin, you've got

If, in CCMAdmin, you've got server hostnames rather than IP addresses, CallManager will use DNS to get the IP addresses of the other servers.



Please rate all helpful posts.
CreatePlease login to create content