<div dir="ltr"><div>Matthew,</div>
<div> </div>
<div>regarding caveat 1, i understand i have checked the ccm 3.x database, and the field specified are still the same.</div>
<div>regarding caveat 2, ofcourse i understand the risks involved, and fully get your advise, it just is a risk we need to take.</div>
<div>regarding caveat 3, i am looking to set the cfwna number, the number should be based on a prefix + the DN number.</div>
<div>So for instance, dn = 1000, and the prefix is 1# then the cfwna number would be 1#1000.</div>
<div>can you point me in the right direction for a query that does this for all the dn`s ?</div>
<div> </div>
<div>Regarding a reset of the cluster, that can be done, but yes i understand that propagation, could become an issue.</div>
<div>I guess, i just need to test it.</div>
<div> </div>
<div>thanks,</div>
<div> </div>
<div>Erik<br><br></div>
<div class="gmail_quote">On Tue, Jul 15, 2008 at 11:22 PM, Matthew Saskin <<a href="mailto:matt@saskin.net">matt@saskin.net</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">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<br>
<br>Caveat 2: I wouldn't advise doing the update this way, at least not without reviewing my SQL below<br><br>Caveat 3: If you don't listen to caveat 2, I hold 0 responsibility for you blowing up your cluster<br><br>
update NumPlan set CFADestination="DESTINATION_NUMBER" where DNOrPattern = "DN_TO_FORWARD"<br><br>So to forward DN 12345 to 912125551212 run the following:<br>update NumPlan set CFADestination="912125551212" where DNOrPattern="12345"<br>
<br>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.<br>
<br>And one more time, please don't do this in production.<br><br>-matt<br><br><br><br><br>Lelio Fulgenzi wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div class="Ih2E3d">Two options I can think of....1) learn AXL.<br> 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.<br>
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.<br>
Lelio<br>--------------------------------------------------------------------------------<br>Lelio Fulgenzi, B.A.<br>Senior Analyst (CCS) * University of Guelph * Guelph, Ontario N1G 2W1<br>(519) 824-4120 x56354 (519) 767-1060 FAX (JNHN)<br>
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^<br>...seen on a Geek Squad patch cord: "While it is the same length, this 7' crossover cable<br>is not regulation issue for most competitive Manhattan double dutch leagues.<br>
<br> ----- Original Message -----<br></div>
<div>
<div></div>
<div class="Wj3C7c"> *From:* Erik Goppel <mailto:<a href="mailto:egoppel@gmail.com" target="_blank">egoppel@gmail.com</a>><br> *To:* <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a> <mailto:<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>><br>
*Sent:* Tuesday, July 15, 2008 9:31 AM<br> *Subject:* [cisco-voip] Help wanted on Callmanager 3.3.5 SQL query<br> (URGENT!!!)<br><br> Hi,<br><br> <br> Currently we are facing a customer migration scenario, where we need<br>
to set the Call Forward No Answer of the lines in their old cluster<br> to a specific value.<br><br> BAT does not cover this functionality in this version, so we need to<br> do some SQL stuff here.<br><br> <br>
What we need is to set the CFWNA for the line, for example:<br><br> DN 1000 needs to have the CFWNA set to 1#1000<br><br> DN 1001 needs to have the CFWNA set to 1#1001<br><br> DN 1002 needs to have the CFWNA set to 1#1002<br>
<br> ,etc………<br><br> <br> Can ayone provide my with some SQL help here to accomplish this?<br><br> We need to do this for around 8000 DN`s, and our migration starts<br> this weekend.<br><br> <br> <br> Many thanks in advance,<br>
Erik<br><br> ------------------------------------------------------------------------<br><br> _______________________________________________<br> cisco-voip mailing list<br> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br><br><br></div></div>------------------------------------------------------------------------
<div class="Ih2E3d"><br><br>_______________________________________________<br>cisco-voip mailing list<br><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a><br>
</div></blockquote><br></blockquote></div><br></div>