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)
Loading.
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,

    2011

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


HTH


java


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

Actions

This Discussion