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

[Dennis Heim]

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<mailto: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<mailto:SUPPORT at VANTICORE.COM> OR CALL (508) 422-8429
[cid:image001.png at 01CB04E9.F722B890]
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/20100605/b9f5ea4b/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: image001.png
Type: image/png
Size: 3329 bytes
Desc: image001.png
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100605/b9f5ea4b/attachment.png>