<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<meta name=Generator content="Microsoft Word 12 (filtered medium)">
<!--[if !mso]>
<style>
v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style>
<![endif]-->
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
-->
</style>
<!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US link=blue vlink=purple style='word-wrap: break-word;
-webkit-nbsp-mode: space;-webkit-line-break: after-white-space'>
<div class=WordSection1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>I’d love to have access to that tool.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'>-Nate<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";
color:#1F497D'><o:p> </o:p></span></p>
<div>
<div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'>
<p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span
style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>
cisco-voip-bounces@puck.nether.net [mailto:cisco-voip-bounces@puck.nether.net] <b>On
Behalf Of </b>stephen.welsh@unifiedfx.com<br>
<b>Sent:</b> Wednesday, October 27, 2010 10:26 AM<br>
<b>To:</b> <James.Brown@barclayswealth.com><br>
<b>Cc:</b> cisco-voip@puck.nether.net<br>
<b>Subject:</b> Re: [cisco-voip] Video enabled handsets<o:p></o:p></span></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Hi James & group,<o:p></o:p></p>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>I created a windows command line utility I called RUNSQL.EXE
ages ago, it basically communicates to UCM remotely and executes SQL statements
on the UCM database (like the one from James and other similar threads before
this one).<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>The primary advantage of having this facility as a command
line utility, was the ability to save the results to a local CSV file etc.
instead of trying to examine a SSH Log file.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>So for John's problem of reporting on video enabled devices
it would save the results to a CSV file for further analysis in Excel etc.<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>I guess two questions:<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>1) Has anyone seen a tool like that before?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>2) Would anyone other than me find it useful?<o:p></o:p></p>
<div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Also,<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal>One feature I used if for was SQL Updates, for example I was
able to bulk configure items that either BAT didn't cover, or was just too
painful to do in certain versions of UCM, for example Bulk Presence Licensing.
Do many people like me perform SQL Updates at points?<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Thanks<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal>Stephen<o:p></o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div>
<p class=MsoNormal><o:p> </o:p></p>
<div>
<div>
<p class=MsoNormal>On 27 Oct 2010, at 09:24, <<a
href="mailto:James.Brown@barclayswealth.com">James.Brown@barclayswealth.com</a>>
<<a href="mailto:James.Brown@barclayswealth.com">James.Brown@barclayswealth.com</a>>
wrote:<o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br>
<o:p></o:p></p>
<div>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Maybe there are more efficient ways, but here is what I would do...</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>1. Connect to CLI</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>2. Execute run sql SELECT <a href="http://a.name">a.name</a> FROM
Device a WHERE a.xml LIKE '%<videoCapability>1</videoCapability>%'</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>Regards</span><o:p></o:p></p>
<p class=MsoNormal> <o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif";
color:blue'>James.</span><o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;
font-family:"Tahoma","sans-serif"'> <a
href="mailto:cisco-voip-bounces@puck.nether.net">cisco-voip-bounces@puck.nether.net</a>
[mailto:cisco-voip-bounces@puck.nether.net] <b>On Behalf Of </b><a
href="mailto:John.VanLaecke@ghd.com">John.VanLaecke@ghd.com</a><br>
<b>Sent:</b> 27 October 2010 03:17<br>
<b>To:</b> cisco-voip@puck.nether.net<br>
<b>Subject:</b> [cisco-voip] Video enabled handsets</span><o:p></o:p></p>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Hey
all,</span> <br>
<br>
<span style='font-size:10.0pt;font-family:"Arial","sans-serif"'>Anyone know how
I can report all devices that have video enabled ?</span> <br>
<br>
<span style='font-size:10.0pt;font-family:"Verdana","sans-serif"'>Regards,<br>
<b><br>
John Van Laecke <span style='color:#5F5F5F'><br>
</span></b></span><b><span style='font-size:7.5pt;font-family:"Verdana","sans-serif";
color:#5F5F5F'>Senior Voice Engineer<br>
</span></b><br>
_____________________ <br>
This email and all attachments are confidential. For further important
information about emails sent to or from GHD or if you have received this email
in error, please refer to <a href="http://www.ghd.com/emaildisclaimer.html">http://www.ghd.com/emaildisclaimer.html</a>
.<br>
_____________________ <br>
This e-mail has been scanned for viruses by MessageLabs.<o:p></o:p></p>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<div class=MsoNormal align=center style='text-align:center'>
<hr size=2 width="100%" align=center>
</div>
<p class=MsoNormal><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>Barclays
Wealth is the wealth management division of Barclays Bank PLC. This email may
relate to or be sent from other members of the Barclays Group.</span><o:p></o:p></p>
<div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
<p><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>The
availability of products and services may be limited by the applicable laws and
regulations in certain jurisdictions. The Barclays Group does not normally
accept or offer business instructions via internet email. Any action that you
might take upon this message might be at your own risk.</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>This email
and any attachments are confidential and intended solely for the addressee and
may also be privileged or exempt from disclosure under applicable law. If you
are not the addressee, or have received this email in error, please notify the
sender immediately, delete it from your system and do not copy, disclose or
otherwise act upon any part of this email or its attachments.</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>Internet
communications are not guaranteed to be secure or without viruses. The Barclays
Group does not accept responsibility for any loss arising from unauthorised
access to, or interference with, any Internet communications by any third
party, or from the transmission of any viruses. Replies to this email may be
monitored by the Barclays Group for operational or business reasons.</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>Any opinion
or other information in this email or its attachments that does not relate to
the business of the Barclays Group is personal to the sender and is not given
or endorsed by the Barclays Group.</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>Barclays Bank
PLC. Registered in England and Wales (registered no. 1026167).<br>
Registered Office: 1 Churchill Place, London, E14 5HP, United Kingdom.</span><o:p></o:p></p>
<p><span style='font-size:7.5pt;font-family:"Arial","sans-serif"'>Barclays Bank
PLC is authorised and regulated by the Financial Services Authority.</span><o:p></o:p></p>
</div>
<p class=MsoNormal>_______________________________________________<br>
cisco-voip mailing list<br>
<a href="mailto:cisco-voip@puck.nether.net">cisco-voip@puck.nether.net</a><br>
https://puck.nether.net/mailman/listinfo/cisco-voip<o:p></o:p></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
</div>
</div>
<DIV>
<p class=MsoNormal><span style='font-size:7.0pt';font-family:'"Helvetica","Tahoma","Arial","sans-serif"'><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.</span><o:p></o:p></span></p><BR>
</DIV></body>
</html>