02-26-2015 12:09 AM - edited 03-17-2019 02:07 AM
Hello,
CUCM 9.x.
Could you please advice me the CLI sql query to get registered MGCP endpoints IP addresses?
Thank you in advance.
Solved! Go to Solution.
03-04-2015 05:33 AM
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
02-26-2015 01:20 AM
Hi,
You can try the following CLI command
show tech gateway
It will provide details of the h323 gateways as well.
HTH
Manish
02-26-2015 06:20 AM
Manish,
It shows only the following fields:
type
name
description
device_pool
I need the table with this data:
name
ip address
03-04-2015 05:33 AM
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
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide