[cisco-voip] Help wanted on Callmanager 3.3.5 SQL query (URGENT!!!)

[Matthew Saskin]

Caveat 1: I don't have a CM3 box available for reference, this is an 
update based on the 4.x database, 4.2(3) specifically

Caveat 2: I wouldn't advise doing the update this way, at least not 
without reviewing my SQL below

Caveat 3: If you don't listen to caveat 2, I hold 0 responsibility for 
you blowing up your cluster

update NumPlan set CFADestination="DESTINATION_NUMBER" where DNOrPattern 
= "DN_TO_FORWARD"

So to forward DN 12345 to 912125551212 run the following:
update NumPlan set CFADestination="912125551212" where DNOrPattern="12345"

Make sure that your CFA CSS is set appropriately, etc.  In addition, I'm 
not sure about whether these changes will propagate up to the 
application via dbl monitor or if a reset from within CCM (or a bounce 
of the CCM services...) may be necessary.

And one more time, please don't do this in production.

-matt




Lelio Fulgenzi wrote:
> Two options I can think of....1) learn AXL.
>  
> The other option, which could probably be done with some thought is to 
> hack the ccmuser pages. When you press the submit button on forward page 
> it will check which items are checked and submit the value to the 
> publisher for update.
>  
> I'm sure you could get a half decent web programmer to come up with a 
> system that could mimic this. By doing an SQL query and outputing the 
> pkid for each extension you want to forward and building a whole bunch 
> of posts, I'll bet it could be done.
>  
>  
> Lelio
> --------------------------------------------------------------------------------
> Lelio Fulgenzi, B.A.
> Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1
> (519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)
> ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
> ...seen on a Geek Squad patch cord: "While it is the same length, this 
> 7' crossover cable
> is not regulation issue for most competitive Manhattan double dutch leagues.
> 
>     ----- Original Message -----
>     *From:* Erik Goppel <mailto:egoppel at gmail.com>
>     *To:* cisco-voip at puck.nether.net <mailto:cisco-voip at puck.nether.net>
>     *Sent:* Tuesday, July 15, 2008 9:31 AM
>     *Subject:* [cisco-voip] Help wanted on Callmanager 3.3.5 SQL query
>     (URGENT!!!)
> 
>     Hi,
> 
>      
> 
>     Currently we are facing a customer migration scenario, where we need
>     to set the Call Forward No Answer of the lines in their old cluster
>     to a specific value.
> 
>     BAT does not cover this functionality in this version, so we need to
>     do some SQL stuff here.
> 
>      
> 
>     What we need is to set the CFWNA for the line, for example:
> 
>     DN 1000 needs to have the CFWNA set to 1#1000
> 
>     DN 1001 needs to have the CFWNA set to 1#1001
> 
>     DN 1002 needs to have the CFWNA set to 1#1002
> 
>     ,etc………
> 
>      
> 
>     Can ayone provide my with some SQL help here to accomplish this?
> 
>     We need to do this for around 8000 DN`s, and our migration starts
>     this weekend.
> 
>      
> 
>      
> 
>     Many thanks in advance,
>      
>     Erik
> 
>     ------------------------------------------------------------------------
> 
>     _______________________________________________
>     cisco-voip mailing list
>     cisco-voip at puck.nether.net
>     https://puck.nether.net/mailman/listinfo/cisco-voip
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> cisco-voip mailing list
> cisco-voip at puck.nether.net
> https://puck.nether.net/mailman/listinfo/cisco-voip