09-16-2014 01:16 PM - edited 03-17-2019 12:11 AM
Hi,
I need to extract the phone number(s), MAC Address, IP address and description of all the phones in the CUCM cluster. I could not find which table these info resides.
Any Idea which table I need to look for these ?..
Thanks in Advance,
Raghu
Solved! Go to Solution.
09-16-2014 02:01 PM
Hi.
Also phoneextn gives you all dns in risdb with sep
show risdb query phoneextn phone gives you both separately
Regards
Carlo
09-16-2014 01:28 PM
If I recall correctly, it was all in numplan table all the info regarding the DNs and patterns, the IP is in no table in the DB, have you reviewed the data dictionary for your CUCM version??
09-16-2014 01:52 PM
Hi.
try with show risdb query phone if it could work for you
HTH
regards
Carlo
09-16-2014 02:01 PM
Hi.
Also phoneextn gives you all dns in risdb with sep
show risdb query phoneextn phone gives you both separately
Regards
Carlo
09-16-2014 02:24 PM
This worked but I have to run it on every node..
09-16-2014 06:40 PM
risdb shows registered phones on a per node basis.
You can refer to this to extract data from one node for all nodes for registered and un-registered phones,
http://www.cisco.com/c/en/us/support/docs/unified-communications/unified-communications-manager-callmanager/117726-technote-cucm-00.html
I believe IP Address of the phone is seen only in risdb.
09-17-2014 03:29 AM
Carlo! Great answer..Wao The RISDB table is very useful!! Just discovered this today..We learn everyday.
09-17-2014 03:35 AM
Deji.
Thank you my friend!
It's true and that's why this community is great!
Cheers
Carlo
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