CUCM SQL Query - MGCP EPs IP Addresses

[StewieGriffin]

Hello,

CUCM 9.x.

Could you please advice me the CLI sql query to get registered MGCP endpoints IP addresses?

Thank you in advance.

[Manish Gogna]

Hi,

You can try the following CLI command

show tech gateway

It will provide details of the h323 gateways as well.

HTH

Manish

[StewieGriffin]

 Manish,

It shows only the following fields:

type
name
description
device_pool

I need the table with this data:

name
ip address

[a.janssen · Accepted solution]

Hi,

these IP's aren't stored in the SQL DB.

Try RISDB:

admin:show risdb query gateway
----------- Gateway Information -----------

Number of Gateway entries: 412

#registered, #unregistered, #rejected, StateId, #ExpUnreg
216, 14, 182, 13605, 0

Seq#, Gateway Name, IPAddress, IPv6Address, Desription, DChannel #, DChannel Status, Perf Object, Reg Status, Model Type, Http Support, #Reg Attempts, Prod Id, Box Prod Id, RegStatChg TimeStamp
1, BRI/S0/SU0/P1@test001.de.test.int, 10.14.71.44, , BRI/S0/SU0/P1@test001.de.test.int, 0, UP, 12, unr, 121, no, 0, 90, 30060, 1425375416

...

Regards

Andre