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

[Erik Goppel]

Matthew,

regarding caveat 1, i understand i have checked the ccm 3.x database, and
the field specified are still the same.
regarding caveat 2, ofcourse i understand the risks involved, and fully get
your advise, it just is a risk we need to take.
regarding caveat 3,  i am looking to set the cfwna number, the number should
be based on a prefix + the DN number.
So for instance, dn = 1000, and the prefix is 1# then the cfwna number would
be 1#1000.
can you point me in the right direction for a query that does this for all
the dn`s ?

Regarding a reset of the cluster, that can be done, but yes i understand
that propagation, could become an issue.
I guess, i just need to test it.

thanks,

Erik

On Tue, Jul 15, 2008 at 11:22 PM, Matthew Saskin <matt at saskin.net> wrote:

> 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
>>
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://puck.nether.net/pipermail/cisco-voip/attachments/20080715/b2ee5810/attachment.html>