[cisco-voip] Specific SQL command on CM 7 for External hone Number MAsk

[Karl Whitson]

Thank you Dennis.  

 

For anyone that is curious how to do this here is the SQL select that
you can run from the CLI.

 

run sql select * from devicenumplanmap where e164mask like "XXXXXXXXXX"
(replace Xs with any combination of numbers or Xs)

 

Karl Whitson

DID:  (508) 422-8413

My WebEx:  www.vanticore.com/meetkarl <http://vanticore.com/meetkarl> 

TO OPEN A SUPPORT CASE EMAIL SUPPORT at VANTICORE.COM OR CALL (508)
422-8429

 

a Joint Venture of CMB Technologies, Inc and Alliance Core Technologies,
Inc. 

 

From: Dennis Heim [mailto:Dennis.Heim at cdw.com] 
Sent: Saturday, June 05, 2010 8:02 PM
To: Karl Whitson; cisco-voip at puck.nether.net
Subject: RE: [cisco-voip] Specific SQL command on CM 7 for External hone
Number MAsk

 

I don't have a box infront of me but I can tell you this.

 

The external mask is found in the devicenumplanmap table and the field
is e164mask.

 

 

The Device table is related to the devicenumplanmap via device.pkid =
devicenumplanmap.fkdevice

 

 

Therefore once you connect the tables together then you can just do a
"where e164mask = 'xyz'

 

Dennis Heim
Network Voice Engineer
CDW  Advanced Technology Services
11711 N. Meridian Street, Suite 225
Carmel, IN  46032

317.569.4255 Office
317.569.4201 Fax
317.694.6070 Cell

dennis.heim at cdw.com
cdw.com/content/solutions/unified-communications/
<http://www.cdw.com/content/solutions/unified-communications/> 

 

 

From: cisco-voip-bounces at puck.nether.net
[mailto:cisco-voip-bounces at puck.nether.net] On Behalf Of Karl Whitson
Sent: Friday, June 04, 2010 4:35 PM
To: cisco-voip at puck.nether.net
Subject: [cisco-voip] Specific SQL command on CM 7 for External hone
Number MAsk

 

Can someone provide me with a CM 7.1.x SQL query that I may run to see
if any of my phones have a specific number configured on the External
Phone Number Mask field in Call Manager.  I am looking for a specific
phone or multiple phones that may have this field configured for a
specific number.  Let's say this number is 1112223333.

 

Thanks.

 

Karl Whitson

Vanticore, LLC

2 Commerce Drive, Suite 105

Bedford, NH  03110

DID:  (508) 422-8413

Fax:  (508) 422-8463

My WebEx:  www.vanticore.com/meetkarl <http://vanticore.com/meetkarl> 

www.vanticore.com <http://www.vanticore.com/> 

TO OPEN A SUPPORT CASE EMAIL SUPPORT at VANTICORE.COM OR CALL (508)
422-8429



a Joint Venture of CMB Technologies, Inc and Alliance Core Technologies,
Inc. 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100607/4651cf4d/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 3329 bytes
Desc: image001.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100607/4651cf4d/attachment.png>