[cisco-voip] Bulk update ext phone number mask with BAT

[Reto Gassmann]

Hello Anthony

Thanks for that SQL solution. I tested it on our Test UCM and it worked.

Thanks a lot

Am Donnerstag, 25. Februar 2016 schrieb Anthony Holloway :

> I know you asked for BAT, but I like SQL:
>
> To get a report of the various EPNMs in use in your environment:
> run sql select e164mask, count(e164mask) as count from devicenumplanmap
> group by e164mask order by count desc
>
> To update a certain set of EPNMs with a new one:
> run sql update devicenumplanmap set e164mask = 'YOUR_NEW_MASK' where
> e164mask = 'YOUR_OLD_MASK'
>
> On Thu, Feb 25, 2016 at 3:52 AM, Reto Gassmann <voip at mrga.ch
> <javascript:_e(%7B%7D,'cvml','voip at mrga.ch');>> wrote:
>
>> Hello group
>>
>> Wie have a large phone number area code change. Therefore we have to
>> change most but not all of the external phone number mask entries.
>>
>> I have tried to use BAT for that. But I am not able to provide a list of
>> numbers where the external phone number mask entry needs to be changed.
>>
>> Is there a way to easy change the external phone number mask based on a
>> list with DN and the new external phone number mask.
>>
>> We run UCM 10.5
>>
>> Thanks a lot
>> Regards Reto
>>
>> _______________________________________________
>> cisco-voip mailing list
>> cisco-voip at puck.nether.net
>> <javascript:_e(%7B%7D,'cvml','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/20160226/68982490/attachment.html>