<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.EmailStyle20
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle21
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple>
<div class=WordSection1>
<p class=MsoNormal><span style='color:#1F497D'>Ssh to the publisher<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Then type<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>run sql select dnorpattern, e164mask,
tkpatternusage from devicenumplanmap inner join numplan on fknumplan=numplan.pkid
where e164mask <> "YOUNUMBER here"<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>you might want to add an “and
tkpatternusage = “2”” at the end to only get numbers that are
assigned to devices.<br>
<br>
<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>admin:run
sql select * from typepatternusage<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>enum
name
moniker
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>====
================================== ========================================== <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>0
CallPark
PATTERN_CALL_PARK
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>1
Conference
PATTERN_CONF
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>2
Device
PATTERN_DEVICE
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>3
Translation
PATTERN_TRANSLATION
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>4
Call Pick Up
Group
PATTERN_CALL_PICK_UP_GROUP
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>5
Route
PATTERN_ROUTE <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>6
Message
Waiting
PATTERN_MESSAGE_WAITING
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>7
Hunt
Pilot
PATTERN_HUNT_PILOT
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>8
Voice Mail
Port
PATTERN_VOICE_MAIL_PORT
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>9
Domain
Routing
PATTERN_ROUTE_DOMAIN
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>10
IPAddress
Routing
PATTERN_ROUTE_IPNET
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>11
Device
template
PATTERN_DEVICE_TEMPLATE <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>12
Directed Call
Park
PATTERN_DIRECTED_CALL_PARK
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>13
Device
Intercom
PATTERN_DEVICE_INTERCOM
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>14
Translation
Intercom
PATTERN_TRANSLATION_INTERCOM
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>15
Translation Calling Party Number
PATTERN_TRANSLATION_CALLING_PARTY_NUMBER <o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>16
Mobility
Handoff
PATTERN_MOBILITY_HANDOFF
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>17
Mobility
DTMF
PATTERN_MOBILITY_DTMF
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>18
Mobility
IVR
PATTERN_MOBILITY_IVR
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>19
Device Intercom
Template
PATTERN_DEVICE_INTERCOM_TEMPLATE
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Courier New";color:#1F497D'>20
Called Party Number Transformation PATTERN_TRANSFORMATION_CALLED_PARTY_NUMBER<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b>On
Behalf Of </b>Haas, Neal<br>
<b>Sent:</b> Thursday, November 04, 2010 3:28 PM<br>
<b>To:</b> 'Dennis Heim'; 'cisco-voip@puck.nether.net'<br>
<b>Subject:</b> Re: [cisco-voip] External Phone Number Mask<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>Any link on how I can do that, I
am not sure of how to connect to the call manager to do that, I have seen some
command line information but I would really love to complete a query from my
desktop.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'>Thanks<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:#1F497D'>Neal<o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Dennis Heim
[mailto:Dennis.Heim@cdw.com] <br>
<b>Sent:</b> Tuesday, November 02, 2010 4:20 PM<br>
<b>To:</b> Haas, Neal; 'cisco-voip@puck.nether.net'<br>
<b>Subject:</b> RE: External Phone Number Mask<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#1F497D'>External phone mask should be
the e164mask field in the devicenumplanmap table.<o:p></o:p></span></p>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='font-size:10.0pt;font-family:"Arial","sans-serif";color:#1F497D'>Dennis
Heim<br>
Network Voice Engineer<br>
CDW Advanced Technology Services<br>
11711 N. Meridian Street, Suite 225<br>
Carmel, IN 46032<br>
<br>
317.569.4255 Office/Home Office<br>
</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:black'>317.569.4201 Fax<br>
</span><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:#1F497D'>317.694.6070 Cell<o:p></o:p></span></p>
<p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'><span
style='color:#1F497D'><a href="mailto:dennis.heim@cdw.com"
title="mailto:dennis.heim@berbee.com">dennis.heim@cdw.com</a><br>
</span><span style='font-size:12.0pt;font-family:"Times New Roman","serif";
color:#1F497D'><a
href="http://www.cdw.com/content/solutions/unified-communications/">cdw.com/content/solutions/unified-communications/</a><o:p></o:p></span></p>
</div>
<p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b>On
Behalf Of </b>Haas, Neal<br>
<b>Sent:</b> Tuesday, November 02, 2010 7:11 PM<br>
<b>To:</b> 'cisco-voip@puck.nether.net'<br>
<b>Subject:</b> [cisco-voip] External Phone Number Mask<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I need to find which phone has the wrong external MASK. I
have 1 phone out of 1000 with the wrong external Mask. I don’t want to go
through every phone. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Do I need to do a SQL query? If so how do I accomplish this,
I am on 7.1.3.10000-11 Linux!<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks<o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='text-autospace:none'><span style='font-size:10.0pt;
font-family:"Courier New";color:#1F497D'>Neal <o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<DIV>
<p class=MsoNormal><span style='font-size:7.0pt';font-family:'"Helvetica","Tahoma","Arial","sans-serif"'><font color="#666666"><br><br> NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply email and destroy all copies of the original message.</span><o:p></o:p></span></p><BR>
</DIV></body>
</html>