cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Walkthrough Wednesdays
239
Views
5
Helpful
7
Replies
r.boloor.rao
Beginner

CUCM SQL help

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

1 ACCEPTED SOLUTION

Accepted Solutions

Hi.

Also phoneextn gives you all dns in risdb with sep

 

show risdb query phoneextn phone gives you both separately

 

Regards

 

 

Carlo

Please rate all helpful posts "The more you help the more you learn"

View solution in original post

7 REPLIES 7
Jaime Valencia
Hall of Fame Cisco Employee

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??

HTH

java

if this helps, please rate

Hi.

try with show risdb query phone if it could work for you

 

HTH

 

regards

 

 

Carlo

Please rate all helpful posts "The more you help the more you learn"

Hi.

Also phoneextn gives you all dns in risdb with sep

 

show risdb query phoneextn phone gives you both separately

 

Regards

 

 

Carlo

Please rate all helpful posts "The more you help the more you learn"

View solution in original post

This worked but I have to run it on every node.. 

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.

Carlo! Great answer..Wao The RISDB table is very useful!! Just discovered this today..We learn everyday.

Please rate all useful posts

Deji.

Thank you my friend!

It's true and that's why this community is great!

 

Cheers

 

Carlo

Please rate all helpful posts "The more you help the more you learn"
Content for Community-Ad

Spotlight Awards 2021