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

Erik Goppel egoppel at gmail.com
Tue Jul 15 17:44:44 EDT 2008


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


More information about the cisco-voip mailing list