CAll Manager 4.1.3 SQL Table information?

D0nprintup_2 · ‎01-27-2009

Can someone tell me what DB the "External phone number mask" is stored in?

I have an issue were I need to verify all our DN's (4 different exchanges totalling over 600 DN's) externl phone number mask.

I am not sure how to do this. I was thinking if I could open SQL enterprise manager and find what DB and table its stored in. I can just do a mass search. I then can compare that list to the spreadsheet I have. My problem is I do not know where to look in the call manager SQL tables.

Rob Huffman · ‎01-27-2009

Hi Donald,

This is beyond my scope, but I thought you might find this thread interesting;

http://forum.cisco.com/eforum/servlet/NetProf?page=netprof&forum=Unified%20Communications%20and%20Video&topic=IP%20Telephony&CommCmd=MB%3Fcmd%3Dpass_through%26location%3Doutline%40%5E1%40%40.2cbf69a6/6#selected_message

Hope this helps!

Rob

Jaime Valencia · ‎01-27-2009

can't recall exactly but i believe it was either on Device or in DNorPattern table

HTH

java

if this helps, please rate

HTH

java

if this helps, please rate

Adam Thompson · ‎01-28-2009

Here is a query that may help you. This will display all Cisco Phones (if you want to view everything, remove 'device.name like 'SEP%' and').

Use Query Analyzer and run it against the CCM database.

select device.name as device,

device.description,

numplanindex as Line,

dnorpattern as DN,

E164Mask

from device,devicenumplanmap,numplan

where device.name like 'SEP%'

and device.pkid = devicenumplanmap.fkdevice

and devicenumplanmap.fknumplan = numplan.pkid

Please rate if helpful