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. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

VIP Purple

SQL query to find IP addresses in CUCM

Hi ,

 

we are using CUCM version 7 and need to find the IP addresses of applications like Unity connection, UCCX,Third party billing server  by running SQL instead of seeing through GUI.

 

Please advise.

 

regds,

aman

1 ACCEPTED SOLUTION

Accepted Solutions
Cisco Employee

I haven't worked with Biling

I haven't worked with Biling Software and hence can't comment on that. Anything that you see under 'System > Application Server' should show up in the appserver table. 

6 REPLIES
Cisco Employee

Try this,run sql select name,

Try this,

run sql select name, ipaddr from appserver

 

 

VIP Purple

Anirudh,I would try and get

Anirudh,I would try and get back to you.

 

regds,

aman

VIP Purple

Hi Anirudh, Bit confused.

Hi Anirudh,

 

Bit confused. 

What do we need to write in  name  under query?

If possible, can u share any working snapshot on the same.

regds,

aman

Cisco Employee

admin:run sql select name,

admin:run sql select name, ipaddr from appserver

name             ipaddr        

=========   ============= 

CUC8            10.x.x.x.

CUC9            10.x.x.x 

 

This will give all entries under System > Application Server.

VIP Purple

Hi Anirudh,I tried running

Hi Anirudh,

I tried running the command  and got output only for Call managers in a cluster.

Can't I get for third party servers which are integrated with CUCM like Billing Software?

regds,

aman

Cisco Employee

I haven't worked with Biling

I haven't worked with Biling Software and hence can't comment on that. Anything that you see under 'System > Application Server' should show up in the appserver table. 

173
Views
5
Helpful
6
Replies