<div dir="ltr"><div>I have seen that the value is passed onto the subs, after i modify it on the pub.</div>
<div>to actually make it work, an update of the line will also make it active, so restarting the services should not be necesarry.</div>
<div><br><br> </div>
<div class="gmail_quote">On Wed, Jul 16, 2008 at 4:09 PM, Ryan Ratliff <<a href="mailto:rratliff@cisco.com">rratliff@cisco.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div style="WORD-WRAP: break-word">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.
<div><br><font color="#888888">
<div>
<p style="MARGIN: 0px"><font style="FONT: 12px Helvetica" face="Helvetica" size="3">-Ryan</font></p></div></font>
<div>
<div></div>
<div class="Wj3C7c"><br>
<div>
<div>On Jul 15, 2008, at 5:55 PM, Erik Goppel wrote:</div><br>
<div dir="ltr">
<div>So,</div>
<div> </div>
<div>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.</div>
<div>and ofcourse restart the services.</div>
<div><br><br> </div>
<div class="gmail_quote">On Tue, Jul 15, 2008 at 11:47 PM, Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div bgcolor="#ffffff">
<div><font face="Arial" size="2">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. </font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">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.</font></div>
<div>
<div><font face="Arial" size="2"></font> </div>
<div>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.</div>
</div>
<blockquote dir="ltr" style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<div>
<div style="FONT: 10pt arial">----- Original Message ----- </div>
<div style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><b>From:</b> <a title="egoppel@gmail.com" href="mailto:egoppel@gmail.com" target="_blank">Erik Goppel</a> </div></div>
<div>
<div></div>
<div>
<div style="FONT: 10pt arial"><b>To:</b> <a title="lelio@uoguelph.ca" href="mailto:lelio@uoguelph.ca" target="_blank">Lelio Fulgenzi</a> </div>
<div style="FONT: 10pt arial"><b>Cc:</b> <a title="cisco-voip@puck.nether.net" href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a> </div>
<div style="FONT: 10pt arial"><b>Sent:</b> Tuesday, July 15, 2008 5:44 PM</div>
<div style="FONT: 10pt arial"><b>Subject:</b> Re: [cisco-voip] Help wanted on Callmanager 3.3.5 SQL query (URGENT!!!)</div>
<div><br></div>
<div dir="ltr">
<div>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</div>
<div>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.</div>
<div>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.</div>
<div>I know people have faced this before, so i am counting on some experience facts to be shared here.</div>
<div>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.</div>
<div>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.</div>
<div>We have achieved that, however the prereq is to set the cfwna on the old cluster.</div>
<div> </div>
<div>So if anyone can help me out with an sql query that will update about 8000 dn`s, that would be excellent.</div>
<div>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.</div>
<div> </div>
<div>Many thanks,</div>
<div> </div>
<div>Erik<br><br></div>
<div class="gmail_quote">On Tue, Jul 15, 2008 at 10:47 PM, Lelio Fulgenzi <<a href="mailto:lelio@uoguelph.ca" target="_blank">lelio@uoguelph.ca</a>> wrote:<br>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">
<div bgcolor="#ffffff">
<div><font face="Arial" size="2">Two options I can think of....1) learn AXL. </font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">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. </font></div>
<div><font face="Arial" size="2"></font> </div>
<div><font face="Arial" size="2">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.</font></div>
<div><font face="Arial" size="2"></font> </div>
<div> </div>
<div>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.</div>
<blockquote style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<div>
<div></div>
<div>
<div style="FONT: 10pt arial">----- Original Message ----- </div>
<div style="BACKGROUND: #e4e4e4; FONT: 10pt arial"><b>From:</b> <a title="egoppel@gmail.com" href="mailto:egoppel@gmail.com" target="_blank">Erik Goppel</a> </div>
<div style="FONT: 10pt arial"><b>To:</b> <a title="cisco-voip@puck.nether.net" href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a> </div>
<div style="FONT: 10pt arial"><b>Sent:</b> Tuesday, July 15, 2008 9:31 AM</div>
<div style="FONT: 10pt arial"><b>Subject:</b> [cisco-voip] Help wanted on Callmanager 3.3.5 SQL query (URGENT!!!)</div>
<div><br></div>
<div dir="ltr"><span><font color="#008000">
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Hi,</span></font></p>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font> <br></div>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">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.</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">BAT does not cover this functionality in this version, so we need to do some SQL stuff here.</span></font></p>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font> <br></div>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">What we need is to set the CFWNA for the line, for example:</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">DN 1000 needs to have the CFWNA set to 1#1000</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">DN 1001 needs to have the CFWNA set to 1#1001</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">DN 1002 needs to have the CFWNA set to 1#1002</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">,etc………</span></font></p>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font> <br></div>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Can ayone provide my with some SQL help here to accomplish this?</span></font></p>
<p><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">We need to do this for around 8000 DN`s, and our migration starts this weekend.</span></font></p>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font> <br></div>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font> <br></div>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Many thanks in advance,</span></font></div>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial"></span></font> </div>
<div><font face="Arial" size="2"><span style="FONT-SIZE: 10pt; FONT-FAMILY: Arial">Erik</span></font></div></font></span></div></div></div>
<div><br></div>
<hr>
<div>
<div><br></div>_______________________________________________<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>
<div><br></div>
<div><br></div>
<div><br></div>
<div><br></div></blockquote></div></blockquote></div><br></div></div></div></blockquote></div></blockquote></div><br></div>
<div style="MARGIN: 0px">_______________________________________________</div>
<div style="MARGIN: 0px">cisco-voip mailing list</div>
<div style="MARGIN: 0px"><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></div>
<div style="MARGIN: 0px"><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></div></div><br></div></div></div></div></blockquote></div><br>
</div>