<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2900.6003" name=GENERATOR></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=372192308-27102010><FONT face=Arial
color=#0000ff size=2>Maybe there are more efficient ways, but here is what I
would do...</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=372192308-27102010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=372192308-27102010><FONT face=Arial
color=#0000ff size=2>1. Connect to CLI</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=372192308-27102010><FONT face=Arial
color=#0000ff size=2>2. Execute run sql SELECT a.name FROM Device a WHERE a.xml
LIKE '%<videoCapability>1</videoCapability>%'</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=372192308-27102010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=372192308-27102010><FONT face=Arial
color=#0000ff size=2>Regards</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=372192308-27102010><FONT face=Arial
color=#0000ff size=2></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=372192308-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> cisco-voip-bounces@puck.nether.net
[mailto:cisco-voip-bounces@puck.nether.net] <B>On Behalf Of
</B>John.VanLaecke@ghd.com<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<BR></FONT><BR></DIV>
<DIV></DIV><FONT face=sans-serif size=2>Hey all,</FONT> <BR><BR><FONT
face=sans-serif size=2>Anyone know how I can report all devices that have video
enabled ?</FONT> <BR><BR><FONT face=Verdana size=2>Regards,<BR><B><BR>John Van
Laecke </B></FONT><FONT face=Verdana color=#5f5f5f
size=2><B><BR></B></FONT><FONT face=Verdana color=#5f5f5f size=1><B>Senior Voice
Engineer<BR></B></FONT><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
http://www.ghd.com/emaildisclaimer.html .<BR>_____________________ <BR>This
e-mail has been scanned for viruses by MessageLabs.<BR>
<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>