<div dir="ltr">why not DMA upgrade to CM6 and then use the new and improved CM6 BAT to do this? that is what i do.<br><br><div class="gmail_quote">On Tue, Jul 15, 2008 at 9:31 AM, Erik Goppel <<a href="mailto:egoppel@gmail.com">egoppel@gmail.com</a>> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><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>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<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>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<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>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<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>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;"> </span></font></p>
<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><font color="#888888">
<div><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial;">Erik</span></font></div></font></font></span></div>
<br>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">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></blockquote></div><br></div>