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

Wed Jul 16 10:52:16 EDT 2008

It is something that i need to decide on, BAT for the update will probably
the choice, as we want to be sure, that all the line have a cfwna css as
well, and that i can set using bat.

On Wed, Jul 16, 2008 at 4:49 PM, Ryan Ratliff <rratliff at cisco.com> wrote:

> So is it easier for you to update 8000 lines or restart some services?
>  Using BAT to do some small update to all of them may work for you but you
> are going to see some cpu spikes while those change notifications are
> generated and processed.
>
> -Ryan
>
>  On Jul 16, 2008, at 10:24 AM, Erik Goppel wrote:
>
>  I have seen that the value is passed onto the subs, after i modify it on
> the pub.
> to actually make it work, an update of the line will also make it active,
> so restarting the services should not be necesarry.
>
>
>
> On Wed, Jul 16, 2008 at 4:09 PM, Ryan Ratliff <rratliff at cisco.com> wrote:
>
>> Once you get your query working then just run it on the pub and SQL
>> replication will take care of the subs.  You will need to restart services
>> on all servers to get them to pick up the change.
>>  -Ryan
>>
>>  On Jul 15, 2008, at 5:55 PM, Erik Goppel wrote:
>>
>>  So,
>>
>> Regarding that, if i have a good working query, the issue would be to
>> execute them on all subs, to be sure the db change has been executed.
>> and ofcourse restart the services.
>>
>>
>>
>> On Tue, Jul 15, 2008 at 11:47 PM, Lelio Fulgenzi <lelio at uoguelph.ca>
>> wrote:
>>
>>>  The biggest problem, however, with updating via SQL is the fact that
>>> the RIS subsystem or whatever will not know you have made a change.
>>>
>>> I've done this before where I have used SQL to update a field and the
>>> change did not take place. So basically, the database had a DN forwarded but
>>> when you called the DN it rang.
>>>
>>> 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 <egoppel at gmail.com>
>>>   *To:* Lelio Fulgenzi <lelio at uoguelph.ca>
>>> *Cc:* cisco-voip at puck.nether.net
>>> *Sent:* Tuesday, July 15, 2008 5:44 PM
>>> *Subject:* Re: [cisco-voip] Help wanted on Callmanager 3.3.5 SQL query
>>> (URGENT!!!)
>>>
>>>  AXL is one of things i`m focusing on myself for 4.x and higher, however
>>> ccm 3.3.5 does not provide an axl interface, since that was introduced since
>>> 4.x
>>> Our company has built quite some progs based on AXL to CCM, so not a
>>> problem there. However since AXL cannot be used, and BAT is not sufficient
>>> now, we need to use SQL.
>>> As i am not a SQL guru, but do know some stuff, i am asking for help in
>>> ways to manipulate the SQL database for the CFWNA item.
>>> I know people have faced this before, so i am counting on some experience
>>> facts to be shared here.
>>> Yes i am fully aware, this is not officially supported by Cisco, however
>>> this is a very short term solution (about a week), that the ccm 3.x cluster
>>> needs to stay alive.
>>> It is is just that during the transition to the new cluster (which
>>> unfortunately cannot be a big bang), we need to be able to dynamically
>>> migrate phones, as people use extension mobility, we do not know when
>>> certain dn`s will be logging in to the new system, so routing between both
>>> should be seamless.
>>> We have achieved that, however the prereq is to set the cfwna on the old
>>> cluster.
>>>
>>> So if anyone can help me out with an sql query that will update about
>>> 8000 dn`s, that would be excellent.
>>> Also some advise regarding the update in the sql query, regarding
>>> the need of restarting the ccm service, or creating the necesarry dbnotify`s
>>> to the subs, would be welcome as well.
>>>
>>> Many thanks,
>>>
>>> Erik
>>>
>>> On Tue, Jul 15, 2008 at 10:47 PM, Lelio Fulgenzi <lelio at uoguelph.ca>
>>> 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 <egoppel at gmail.com>
>>>> *To:* 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/20080716/b0de5b55/attachment.html>