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

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

Forum,

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
usa109-s4cup01.lab.shoregroup.com UC Presence 10.0 Publisher t                9          f          Publisher    CUCM IM and Presence
usa109-s4cup02.lab.shoregroup.com 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.

1 REPLY

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.

 

GTG

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