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

[Adel Abushaev]

Select * from devicenumplanmap where e164mask='1112223333', to refer back to
the device use fkdevice as a key to 'device' table. Or use 'label' and
'display' fields of this record if they are configured properly.

Adel.

On Fri, Jun 4, 2010 at 1:35 PM, Karl Whitson <kwhitson at vanticore.com> wrote:

>  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
>
> TO OPEN A SUPPORT CASE EMAIL *SUPPORT at VANTICORE.COM *OR CALL (508)
> 422-8429
>
> [image: small Dark_logo_color_tif]
>
> *a Joint Venture of CMB Technologies, Inc and Alliance Core Technologies,
> Inc. *
>
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100604/d8cf0a54/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/png
Size: 3329 bytes
Desc: not available
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20100604/d8cf0a54/attachment.png>