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

[Wes Sisk]

Hi Rossella,

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.  
https://<your_cm_server_ip_or_hostname/ccmadmin

It is technically possible to do the updates directly via SQL.  However, 
SQL knowledge is necessary.  CCMAdmin is likely your 'path of least 
resistance'.

Regards,
Wes

On Friday, April 24, 2009 6:00:01 PM, Rossella Mariotti-Jones 
<rossella at chemeketa.edu> wrote:
>
> 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 <mailto: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 <mailto: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/20090425/7880dc38/attachment.html>