[cisco-voip] bulk check Calling Party's External Phone Number Mask

[Rossella Mariotti-Jones]

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:

91.503779XXXX 91.503779 Woodburn - RP            Woodburn 911 - P
Woodburn to local Salem - RL

 

In this case my dnorpattern is 91.503779XXXX  and my
tkstatus_usefullyqualcallingpartynum is 0, I don't see here how we
change it to 1

 

rossella mariotti-jones | network analyst | chemeketa community college
| rossella at chemeketa.edu | 503-589-7775

P To reduce waste, please consider not printing this email unless
necessary

 

From: Wes Sisk [mailto:wsisk at cisco.com] 
Sent: Friday, April 24, 2009 1:21 PM
To: Rossella Mariotti-Jones
Cc: cisco-voip at puck.nether.net
Subject: Re: [cisco-voip] bulk check Calling Party's External Phone
Number Mask

 

>From the admin CLI (ssh to CM server):

admin:run sql select dnorpattern,tkstatus_usefullyqualcallingpartynum
from numplan where tkpatternusage=5 order by tkpatternusage
dnorpattern tkstatus_usefullyqualcallingpartynum
=========== ====================================
8.661XXXX   1
7568100     0

0  = not checked
1 = checked

/Wes

On Friday, April 24, 2009 3:27:42 PM, Rossella Mariotti-Jones
<rossella at chemeketa.edu> <mailto:rossella at chemeketa.edu>  wrote:



Hi all, is there a way to bulk check this field?

Under Route Pattern Configuration / Calling Party Transformations

Use Calling Party's External Phone Number Mask

Thanks!

 

 

rossella mariotti-jones | network analyst | chemeketa community college
| rossella at chemeketa.edu | 503-589-7775

P To reduce waste, please consider not printing this email unless
necessary

 

 


________________________________



 
_______________________________________________
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/20090424/e1510aee/attachment.html>