[cisco-voip] Setting Multiple Description Fields in BAT?

Kris Seraphine baryonyx5 at gmail.com
Sat Jul 18 10:31:49 EDT 2009


I can think of two possible options.

You can Reimport the phones in BAT with the new description. If you check
the 'overwrite existing settings' box it will only modify settings that
differ from those on the existing phone.  I'd suggest testing this on a
small number of phones to get an import file with the fewest number of
fields possible so you don't inadvertently change settings extra settings.

The other option would be to use a sql query at the cli.  something like

run sql update device set description = 'New Description' where description
= 'Old Description' and name like 'SEP%'

Unless there is a pattern to the new and old descriptions, you'll have to
have a separate query for each device but it's doable

This all assumes you're running CM 5 or higher

On Sat, Jul 18, 2009 at 8:55 AM, Miller, Steve <MillerS at dicksteinshapiro.com
> wrote:

>  I cannot figure our a way to change 250 phone descriptions (where each
> description is unique) as a single BAT job.  Is there a way?  It seems that
> I would have to create 250 separate jobs to do this.  We are moving to a new
> building next week and I would like to program all of the room numbers
> (which we program as part of the description field) in advance and then run
> the job when we move. Any BAT advice would be greatly appreciated.
>
>
> *Steve Miller*
> Telecom Engineer
> Dickstein Shapiro LLP
> 1825 Eye Street NW | Washington, DC 20006
> Tel (202) 420-3370| Fax (202) 330-5607
> MillerS at dicksteinshapiro.com
>
>
> --------------------------------------------------------
> This e-mail message and any attached files are confidential and are intended solely for the use of the addressee(s)
> named above. This communication may contain material protected by attorney-client, work product, or other
> privileges. If you are not the intended recipient or person responsible for delivering this confidential
> communication to the intended recipient, you have received this communication in error, and any review, use,
> dissemination, forwarding, printing, copying, or other distribution of this e-mail message and any attached files
> is strictly prohibited. Dickstein Shapiro reserves the right to monitor any communication that is created,
> received, or sent on its network.  If you have received this confidential communication in error, please notify the
> sender immediately by reply e-mail message and permanently delete the original message.
>
> To reply to our email administrator directly, send an email to postmaster at dicksteinshapiro.com
>
> Dickstein Shapiro LLPhttp://www.DicksteinShapiro.com
>
> ==============================================================================
>
>
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip
>
>


-- 
kris seraphine
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20090718/d784b5a7/attachment.html>


More information about the cisco-voip mailing list