<!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">
Hi Rossella,<br>
<br>
SQL was just the simplest way to "bulk check" per your original
request. The output allows you to see route patterns and the
configuration value. Use that to identify the route patterns you want
to change. Once you have that list the easiest way to perform the
updates is to use CCMAdministration web page.
<a class="moz-txt-link-freetext" href="https://">https://</a><your_cm_server_ip_or_hostname/ccmadmin<br>
<br>
It is technically possible to do the updates directly via SQL.
However, SQL knowledge is necessary. CCMAdmin is likely your 'path of
least resistance'. <br>
<br>
Regards,<br>
Wes<br>
<br>
On Friday, April 24, 2009 6:00:01 PM, Rossella Mariotti-Jones
<a class="moz-txt-link-rfc2396E" href="mailto:rossella@chemeketa.edu"><rossella@chemeketa.edu></a> wrote:<br>
<blockquote
cite="mid:D63A25821E9AE349ADBAB6BB1F0A766C0CE5C8C0@cccmail2.chemeketa.network"
type="cite">
<meta http-equiv="Content-Type" content="text/html; ">
<meta name="Generator" content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@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;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 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";
color:black;}
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;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";
color:black;}
tt
{mso-style-priority:99;
font-family:"Courier New";}
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";
color:black;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;
color:black;}
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 Section1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
{page:Section1;}
-->
</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"><span style="color: rgb(31, 73, 125);">Thanks,
so I’m totally
unfamiliar with sql, is this just to check with the cli what we have
right now or is it to change it? If I had this pattern:<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">91.503779XXXX
91.503779 Woodburn
- RP Woodburn
911 - P Woodburn
to local Salem – RL<o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);">In this
case my </span><tt><span style="font-size: 10pt;">dnorpattern is </span></tt><span
style="color: rgb(31, 73, 125);">91.503779XXXX</span><tt><span
style="font-size: 10pt;"> and my tkstatus_usefullyqualcallingpartynum
is
0, I don’t see here how we change it to 1</span></tt><span
style="color: rgb(31, 73, 125);"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<p class="MsoNormal"><span
style="font-size: 10.5pt; color: rgb(31, 73, 125);">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: "Arial","sans-serif"; color: green;">
</span><b><i><span
style="font-size: 9pt; font-family: "Lucida Console"; 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>
</div>
<p class="MsoNormal"><span style="color: rgb(31, 73, 125);"><o:p> </o:p></span></p>
<div>
<div
style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">
<p class="MsoNormal"><b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: windowtext;">From:</span></b><span
style="font-size: 10pt; font-family: "Tahoma","sans-serif"; color: windowtext;">
Wes Sisk [<a class="moz-txt-link-freetext" href="mailto:wsisk@cisco.com">mailto:wsisk@cisco.com</a>] <br>
<b>Sent:</b> Friday, April 24, 2009 1:21 PM<br>
<b>To:</b> Rossella Mariotti-Jones<br>
<b>Cc:</b> <a class="moz-txt-link-abbreviated" href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Re: [cisco-voip] bulk check Calling Party's External
Phone
Number Mask<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
<p class="MsoNormal">From the admin CLI (ssh to CM server):<br>
<br>
<tt><span style="font-size: 10pt;">admin:run sql select
dnorpattern,tkstatus_usefullyqualcallingpartynum
from numplan where tkpatternusage=5 order by tkpatternusage</span></tt><span
style="font-size: 10pt; font-family: "Courier New";"><br>
<tt>dnorpattern tkstatus_usefullyqualcallingpartynum</tt><br>
<tt>=========== ====================================</tt><br>
<tt>8.661XXXX 1</tt><br>
<tt>7568100 0</tt><br>
</span><br>
0 = not checked<br>
1 = checked<br>
<br>
/Wes<br>
<br>
On Friday, April 24, 2009 3:27:42 PM, Rossella Mariotti-Jones <a
moz-do-not-send="true" href="mailto:rossella@chemeketa.edu"><rossella@chemeketa.edu></a>
wrote:<br>
<br>
<o:p></o:p></p>
<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;">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></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<p class="MsoNormal"><span style="font-size: 10.5pt;">rossella
mariotti-jones |
network analyst | chemeketa community college | <a
moz-do-not-send="true" href="mailto:rossella@chemeketa.edu">rossella@chemeketa.edu</a>
| 503-589-7775</span><o:p></o:p></p>
<p class="MsoNormal"><span
style="font-size: 20pt; font-family: Webdings; color: green;">P</span><span
style="font-size: 9pt; font-family: "Arial","sans-serif"; color: green;">
</span><b><i><span
style="font-size: 9pt; font-family: "Lucida Console"; color: green;">To
reduce waste, please consider not printing this email unless
necessary</span></i></b><o:p></o:p></p>
<p class="MsoNormal"> <o:p></o:p></p>
<pre><o:p> </o:p></pre>
<pre style="text-align: center;">
<hr align="center" size="4" width="90%">
</pre>
<pre><o:p> </o:p></pre>
<pre>_______________________________________________<o:p></o:p></pre>
<pre>cisco-voip mailing list<o:p></o:p></pre>
<pre><a moz-do-not-send="true"
href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><o:p></o:p></pre>
<pre><a moz-do-not-send="true"
href="https://puck.nether.net/mailman/listinfo/cisco-voip">https://puck.nether.net/mailman/listinfo/cisco-voip</a><o:p></o:p></pre>
<pre> <o:p></o:p></pre>
<p class="MsoNormal"><span
style="font-size: 12pt; font-family: "Times New Roman","serif";"><o:p> </o:p></span></p>
</div>
</blockquote>
<br>
</body>
</html>