<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
>From the admin CLI (ssh to CM server):<br>
<br>
<tt>admin:run sql select
dnorpattern,tkstatus_usefullyqualcallingpartynum from numplan where
tkpatternusage=5 order by tkpatternusage<br>
dnorpattern tkstatus_usefullyqualcallingpartynum<br>
=========== ====================================<br>
8.661XXXX&nbsp;&nbsp; 1<br>
7568100&nbsp;&nbsp;&nbsp;&nbsp; 0<br>
</tt><br>
0&nbsp; = not checked<br>
1 = checked<br>
<br>
/Wes<br>
<br>
On Friday, April 24, 2009 3:27:42 PM, Rossella Mariotti-Jones
<a class="moz-txt-link-rfc2396E" href="mailto:rossella@chemeketa.edu">&lt;rossella@chemeketa.edu&gt;</a> wrote:<br>
<blockquote
 cite="mid:D63A25821E9AE349ADBAB6BB1F0A766C0CE5C7C4@cccmail2.chemeketa.network"
 type="cite">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta name="Generator" content="Microsoft Word 12 (filtered medium)">
  <style>
<!--
 /* Font Definitions */
 @font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Wingdings;
        panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
        {font-family:Calibri;
        panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
        {font-family:"Lucida Console";
        panose-1:2 11 6 9 4 5 4 2 2 4;}
@font-face
        {font-family:Webdings;
        panose-1:5 3 1 2 1 5 9 6 7 3;}
 /* 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.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
        {mso-style-priority:34;
        margin-top:0in;
        margin-right:0in;
        margin-bottom:0in;
        margin-left:.5in;
        margin-bottom:.0001pt;
        font-size:11.0pt;
        font-family:"Calibri","sans-serif";}
span.EmailStyle17
        {mso-style-type:personal-compose;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
 /* List Definitions */
 @list l0
        {mso-list-id:1501120831;
        mso-list-type:hybrid;
        mso-list-template-ids:977424652 1429786678 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
        {mso-level-start-at:0;
        mso-level-number-format:bullet;
        mso-level-text:\F0B7;
        mso-level-tab-stop:none;
        mso-level-number-position:left;
        text-indent:-.25in;
        font-family:Symbol;
        mso-fareast-font-family:Calibri;
        mso-bidi-font-family:"Times New Roman";}
ol
        {margin-bottom:0in;}
ul
        {margin-bottom:0in;}
-->
  </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]-->
  <div class="Section1">
  <p class="MsoNormal">Hi all, is there a way to bulk check this field?<o:p></o:p></p>
  <p class="MsoNormal">Under Route Pattern Configuration / Calling
Party
Transformations<o:p></o:p></p>
  <p class="MsoListParagraph" style="text-indent: -0.25in;"><!--[if !supportLists]--><span
 style="font-family: Symbol;"><span style="">&middot;<span
 style="font-family: &quot;Times New Roman&quot;; font-style: normal; font-variant: normal; font-weight: normal; font-size: 7pt; line-height: normal; font-size-adjust: none; font-stretch: normal;">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
  </span></span></span><!--[endif]-->Use Calling Party's External Phone
Number Mask<o:p></o:p></p>
  <p class="MsoNormal">Thanks!<o:p></o:p></p>
  <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
  <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
  <p class="MsoNormal"><span style="font-size: 10.5pt;">rossella
mariotti-jones |
network analyst | chemeketa community college | <a class="moz-txt-link-abbreviated" href="mailto:rossella@chemeketa.edu">rossella@chemeketa.edu</a>
|
503-589-7775<o:p></o:p></span></p>
  <p class="MsoNormal"><span
 style="font-size: 20pt; font-family: Webdings; color: green;">P</span><span
 style="font-size: 9pt; font-family: &quot;Arial&quot;,&quot;sans-serif&quot;; color: green;">
  </span><b><i><span
 style="font-size: 9pt; font-family: &quot;Lucida Console&quot;; color: green;">To
reduce waste, please consider not printing this email unless
necessary</span></i></b><span style="font-size: 9pt; color: navy;"><o:p></o:p></span></p>
  <p class="MsoNormal"><o:p>&nbsp;</o:p></p>
  </div>
  <pre wrap="">
<hr size="4" width="90%">
_______________________________________________
cisco-voip mailing list
<a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a>
<a class="moz-txt-link-freetext" href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a>
  </pre>
</blockquote>
<br>
</body>
</html>