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

[Lelio Fulgenzi]

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