CAll Manager 4.1.3 SQL Table information?

Unanswered Question
Jan 27th, 2009
User Badges:

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.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Rob Huffman Tue, 01/27/2009 - 06:35
User Badges:
  • Super Blue, 32500 points or more
  • Hall of Fame,

    Founding Member

  • Cisco Designated VIP,

    2017 IP Telephony, Unified Communications

Jaime Valencia Tue, 01/27/2009 - 06:54
User Badges:
  • Cisco Employee,
  • Hall of Fame,


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



if this helps, please rate

Adam Thompson Wed, 01/28/2009 - 07:31
User Badges:
  • Silver, 250 points or more

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

Use Query Analyzer and run it against the CCM database.

select as device,


numplanindex as Line,

dnorpattern as DN,


from device,devicenumplanmap,numplan

where like 'SEP%'

and device.pkid = devicenumplanmap.fkdevice

and devicenumplanmap.fknumplan = numplan.pkid

Please rate if helpful


This Discussion