01-27-2009 06:26 AM - edited 03-15-2019 03:47 PM
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.
01-27-2009 06:35 AM
Hi Donald,
This is beyond my scope, but I thought you might find this thread interesting;
Hope this helps!
Rob
01-27-2009 06:54 AM
can't recall exactly but i believe it was either on Device or in DNorPattern table
HTH
java
if this helps, please rate
01-28-2009 07:31 AM
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
Find answers to your questions by entering keywords or phrases in the Search bar above. New here? Use these resources to familiarize yourself with the community: