SQL query to find IP addresses in CUCM

[Aman Soi]

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

[Anirudh Mavilakandy]

Try this,

run sql select name, ipaddr from appserver

[Aman Soi]

Anirudh,I would try and get back to you.

regds,

aman

[Aman Soi]

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

[Anirudh Mavilakandy]

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.

[Aman Soi]

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

[Anirudh Mavilakandy · Accepted solution]

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.