<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML xmlns="http://www.w3.org/TR/REC-html40" 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"><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.6003" name=GENERATOR><!--[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-face {
font-family: Cambria Math;
}
@font-face {
font-family: Calibri;
}
@font-face {
font-family: Tahoma;
}
@font-face {
font-family: Verdana;
}
@page WordSection1 {size: 8.5in 11.0in; margin: 1.0in 1.0in 1.0in 1.0in; }
P.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
LI.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
DIV.MsoNormal {
FONT-SIZE: 12pt; MARGIN: 0in 0in 0pt; FONT-FAMILY: "Times New Roman","serif"
}
A:link {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlink {
COLOR: blue; TEXT-DECORATION: underline; mso-style-priority: 99
}
A:visited {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
SPAN.MsoHyperlinkFollowed {
COLOR: purple; TEXT-DECORATION: underline; mso-style-priority: 99
}
P {
FONT-SIZE: 12pt; MARGIN-LEFT: 0in; MARGIN-RIGHT: 0in; FONT-FAMILY: "Times New Roman","serif"; mso-style-priority: 99; mso-margin-top-alt: auto; mso-margin-bottom-alt: auto
}
SPAN.EmailStyle18 {
COLOR: #1f497d; FONT-FAMILY: "Calibri","sans-serif"; mso-style-type: personal-reply
}
.MsoChpDefault {
FONT-SIZE: 10pt; mso-style-type: export-only
}
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
style="WORD-WRAP: break-word; webkit-nbsp-mode: space; webkit-line-break: after-white-space"
vLink=purple link=blue>
<DIV dir=ltr align=left><SPAN class=876474617-27102010><FONT face=Arial
color=#0000ff size=2>Hi Stephen,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=876474617-27102010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=876474617-27102010><FONT face=Arial
color=#0000ff size=2>We have used the AXL toolkit (available via
ccmadmin) to perform SELECTs and the occasional UPDATE (but never an
INSERT).</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=876474617-27102010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=876474617-27102010><FONT face=Arial
color=#0000ff size=2>I would also be very grateful for a copy of the
tool.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=876474617-27102010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=876474617-27102010><FONT face=Arial
color=#0000ff size=2>Regards</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=876474617-27102010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=876474617-27102010><FONT face=Arial
color=#0000ff size=2>James.</FONT></SPAN></DIV><BR>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left>
<HR tabIndex=-1>
<FONT face=Tahoma size=2><B>From:</B> Nate VanMaren
[mailto:VanMarenNP@ldschurch.org] <BR><B>Sent:</B> 27 October 2010
18:44<BR><B>To:</B> stephen.welsh@unifiedfx.com; Brown, James : Barclays
Wealth<BR><B>Cc:</B> cisco-voip@puck.nether.net<BR><B>Subject:</B> RE:
[cisco-voip] Video enabled handsets<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV class=WordSection1>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">I’d
love to have access to that tool.<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'">-Nate<o:p></o:p></SPAN></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 11pt; COLOR: #1f497d; FONT-FAMILY: 'Calibri','sans-serif'"><o:p> </o:p></SPAN></P>
<DIV>
<DIV
style="BORDER-RIGHT: medium none; PADDING-RIGHT: 0in; BORDER-TOP: #b5c4df 1pt solid; PADDING-LEFT: 0in; PADDING-BOTTOM: 0in; BORDER-LEFT: medium none; PADDING-TOP: 3pt; BORDER-BOTTOM: medium none">
<P class=MsoNormal><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; 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: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">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: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">1.
Connect to CLI</SPAN><o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">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: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">Regards</SPAN><o:p></o:p></P>
<P class=MsoNormal> <o:p></o:p></P>
<P class=MsoNormal><SPAN
style="FONT-SIZE: 10pt; COLOR: blue; FONT-FAMILY: 'Arial','sans-serif'">James.</SPAN><o:p></o:p></P>
<P class=MsoNormal><o:p> </o:p></P>
<DIV class=MsoNormal style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=2>
</DIV>
<P class=MsoNormal style="MARGIN-BOTTOM: 12pt"><B><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: 'Tahoma','sans-serif'">From:</SPAN></B><SPAN
style="FONT-SIZE: 10pt; 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: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Hey all,</SPAN>
<BR><BR><SPAN style="FONT-SIZE: 10pt; FONT-FAMILY: 'Arial','sans-serif'">Anyone
know how I can report all devices that have video enabled ?</SPAN> <BR><BR><SPAN
style="FONT-SIZE: 10pt; 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; COLOR: #5f5f5f; FONT-FAMILY: 'Verdana','sans-serif'">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 style="TEXT-ALIGN: center" align=center>
<HR align=center width="100%" SIZE=2>
</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-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></FONT>
<P>
<HR>
<FONT face=Arial size=1>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.</FONT></P>
<P><FONT face=Arial size=1>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.</FONT></P>
<P><FONT face=Arial size=1>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.</FONT></P>
<P><FONT face=Arial size=1>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.</FONT></P>
<P><FONT face=Arial size=1>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.</FONT></P>
<P><FONT face=Arial size=1>Barclays Bank PLC. Registered in England and Wales
(registered no. 1026167).<BR>Registered Office: 1 Churchill Place, London, E14
5HP, United Kingdom.</FONT></P>
<P><FONT face=Arial size=1>Barclays Bank PLC is authorised and regulated by the
Financial Services Authority.</FONT></P>
</BODY></HTML>