<div dir="ltr">minor typo. corrected below<div>table name in the select should be "enduser" not "end user"</div><div><br></div><div><span style="font-family:arial,sans-serif;font-size:13px">admin:run sql update device set fkenduser=(select pkid from <b>enduser </b>where userid ='USERID') where name = 'DEVICENAME' ;</span><br>
</div></div><div class="gmail_extra"><br><br><div class="gmail_quote">On Thu, Aug 15, 2013 at 10:37 PM, Pavan K <span dir="ltr"><<a href="mailto:pav.ccie@gmail.com" target="_blank">pav.ccie@gmail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><p>Matthew,</p><p dir="ltr">Try the following with a dummy device. Tested on an 8.6(2) box.<br></p><p>=====<br>
</p><p dir="ltr">admin:run sql update device set fkenduser=(select pkid from end user where userid ='USERID') where name = 'DEVICENAME' ;</p>
<p dir="ltr">======</p><span class="HOEnZb"><font color="#888888"><p>-Pavan</p></font></span><div><div class="h5"><p><br></p>
<div class="gmail_quote">On Aug 15, 2013 7:34 PM, "Matthew Loraditch" <<a href="mailto:MLoraditch@heliontechnologies.com" target="_blank">MLoraditch@heliontechnologies.com</a>> wrote:<br type="attribution">
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div dir="auto">
<div>I almost have the perl script working but ill take SQL too if someone can point me to the right query. I couldn't use an input file but I could make a a command list easily enough<br>
<br>
Sent from my iPad</div>
<div><br>
On Aug 15, 2013, at 7:33 PM, "Nate VanMaren" <<a href="mailto:VanMarenNP@ldschurch.org" target="_blank">VanMarenNP@ldschurch.org</a>> wrote:<br>
<br>
</div>
<blockquote type="cite">
<div>
<div>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d">But why not just do it in SQL, then you can just run it on the CLI<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1f497d"><u></u> <u></u></span></p>
<p class="MsoNormal"><b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif"">From:</span></b><span style="font-size:11.0pt;font-family:"Calibri","sans-serif""> cisco-voip [<a href="mailto:cisco-voip-bounces@puck.nether.net" target="_blank">mailto:cisco-voip-bounces@puck.nether.net</a>]
<b>On Behalf Of </b>Florian Kroessbacher<br>
<b>Sent:</b> Thursday, August 15, 2013 12:24 PM<br>
<b>To:</b> Ed Leatherman<br>
<b>Cc:</b> <a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a><br>
<b>Subject:</b> Re: [cisco-voip] AXL/Perl/SOAP newbie help<u></u><u></u></span></p>
<p class="MsoNormal"><u></u> <u></u></p>
<div>
<p class="MsoNormal">must it be perl, i think i've one in java<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal">--<br>
Florian Kroessbacher<br>
gmail: <a href="mailto:florian.kroessbacher@gmail.com" target="_blank">florian.kroessbacher@gmail.com</a><u></u><u></u></p>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
<div>
<p>On Thu, Aug 15, 2013 at 7:15 PM, Ed Leatherman <<a href="mailto:ealeatherman@gmail.com" target="_blank">ealeatherman@gmail.com</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<p class="MsoNormal">I have a couple that I have hacked up that might at least point in the right direction, i'll try and look thru them this afternoon and see if one is using updatephone and send you one.<u></u><u></u></p>
</div>
<div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><u></u> <u></u></p>
<div>
<p class="MsoNormal">On Thu, Aug 15, 2013 at 12:25 PM, Matthew Loraditch <<a href="mailto:MLoraditch@heliontechnologies.com" target="_blank">MLoraditch@heliontechnologies.com</a>> wrote:<u></u><u></u></p>
<blockquote style="border:none;border-left:solid #cccccc 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<div>
<div>
<p class="MsoNormal">All,<u></u><u></u></p>
<p class="MsoNormal">I would like a perl scrip I can run that reads a CSV file with 2 fields (device name and owner user id) and then uses the updatephone axl function and sets said value on each item
from the csv.<u></u><u></u></p>
<p class="MsoNormal">I have the soap request tested and validated, but my programming from scratch skills aren’t so hot, and I can’t find an example close enough that I could hack it, so I am fumbling
around on my own, so if anyone has something they would be willing to share, I would be grateful. Also if you go to Live next year there would be beer in it for you!<u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif""> </span><u></u><u></u></p>
<p class="MsoNormal">Matthew G. Loraditch – CCNP-Voice, CCNA-R&S, CCDA<br>
<span style="font-size:9.0pt;font-family:"Arial","sans-serif""><br>
1965 Greenspring Drive</span><br>
<span style="font-size:9.0pt;font-family:"Arial","sans-serif"">Timonium, MD 21093</span><br>
<span style="font-size:9.0pt;font-family:"Arial","sans-serif""><br>
voice. <a href="tel:410.252.8830" target="_blank">410.252.8830</a><br>
fax. <a href="tel:410.252.9284" target="_blank">410.252.9284</a> <br>
<br>
<a href="http://twitter.com/heliontech" target="_blank">Twitter</a> | <a href="http://www.facebook.com/#!/pages/Helion/252157915296" target="_blank">
Facebook</a> | <a href="http://www.heliontechnologies.com/" target="_blank">Website</a> |
<a href="mailto:support@heliontechnologies.com?subject=Technical%20Support%20Request" target="_blank">
Email Support</a></span><u></u><u></u></p>
<p class="MsoNormal" style="margin-bottom:12.0pt"> <u></u><u></u></p>
<p class="MsoNormal"> <u></u><u></u></p>
</div>
</div>
<p class="MsoNormal" style="margin-bottom:12.0pt"><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><u></u><u></u></p>
</blockquote>
</div>
<p class="MsoNormal"><br>
<br clear="all">
<u></u><u></u></p>
<div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<p class="MsoNormal">-- <br>
Ed Leatherman<u></u><u></u></p>
</div>
</blockquote>
</div>
<p class="MsoNormal"><u></u> <u></u></p>
</div>
<div>
<p class="MsoNormal"><span><font color="#666666"><br>
<br>
NOTICE: This email message is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact
the sender by reply email and destroy all copies of the original message.</font></span><font color="#666666"><u></u><u></u></font></p>
<font color="#666666"><br>
</font></div>
<font color="#666666"></font></div>
</blockquote>
<blockquote type="cite">
<div><span>_______________________________________________</span><br>
<span>cisco-voip mailing list</span><br>
<span><a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a></span><br>
<span><a href="https://puck.nether.net/mailman/listinfo/cisco-voip" target="_blank">https://puck.nether.net/mailman/listinfo/cisco-voip</a></span><br>
</div>
</blockquote>
</div>
<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></blockquote></div>
</div></div></div>
</blockquote></div><br><br clear="all"><div><br></div>-- <br>- Pavan
</div>