<div>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.</div>
<div> </div>
<div>Adel.<br><br></div>
<div class="gmail_quote">On Fri, Jun 4, 2010 at 1:35 PM, Karl Whitson <span dir="ltr"><<a href="mailto:kwhitson@vanticore.com">kwhitson@vanticore.com</a>></span> wrote:<br>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div lang="EN-US" vlink="purple" link="blue">
<div>
<p class="MsoNormal">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.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Thanks.</p>
<p class="MsoNormal"> </p>
<p class="MsoNormal">Karl Whitson</p>
<p class="MsoNormal">Vanticore, LLC</p>
<p class="MsoNormal">2 Commerce Drive, Suite 105</p>
<p class="MsoNormal">Bedford, NH 03110</p>
<p class="MsoNormal">DID: (508) 422-8413</p>
<p class="MsoNormal">Fax: (508) 422-8463</p>
<p class="MsoNormal">My WebEx: <a href="http://vanticore.com/meetkarl" target="_blank"><span style="COLOR: blue">www.vanticore.com/meetkarl</span></a></p>
<p class="MsoNormal"><a href="http://www.vanticore.com/" target="_blank"><span style="COLOR: blue">www.vanticore.com</span></a></p>
<p class="MsoNormal">TO OPEN A SUPPORT CASE EMAIL <b><i><a href="mailto:SUPPORT@VANTICORE.COM" target="_blank"><span style="COLOR: blue">SUPPORT@VANTICORE.COM</span></a> </i></b>OR CALL (508) 422-8429</p>
<p class="MsoNormal"><img border="0" alt="small Dark_logo_color_tif" src="cid:image001.png@01CB0403.F060A670" width="125" height="46"></p>
<p class="MsoNormal"><b><span style="FONT-SIZE: 8pt">a Joint Venture of CMB Technologies, Inc and Alliance Core Technologies, Inc. </span></b></p>
<p class="MsoNormal"> </p></div></div><br>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
<br></blockquote></div><br>