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

Wed Jul 16 10:49:29 EDT 2008

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
To: Lelio Fulgenzi
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
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/d8e113a9/attachment-0001.html>