Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements

Welcome to Cisco Support Community. We would love to have your feedback.

For an introduction to the new site, click here. If you'd prefer to explore, try our test area to get started. And see here for current known issues.

New Member

CAll Manager 4.1.3 SQL Table information?

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.

3 REPLIES
Hall of Fame Super Red

Re: CAll Manager 4.1.3 SQL Table information?

Cisco Employee

Re: CAll Manager 4.1.3 SQL Table information?

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

www.cisco.com/go/pdi

Re: CAll Manager 4.1.3 SQL Table information?

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

366
Views
0
Helpful
3
Replies