<!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.3676" name=GENERATOR></HEAD>
<BODY text=#000000 bgColor=#ffffff>
<DIV dir=ltr align=left><FONT face=Arial color=#0000ff
size=2></FONT> </DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2><B>From:</B> Wes Sisk [mailto:wsisk@cisco.com] <BR><B>Sent:</B> 12 July
2010 20:26<BR><B>To:</B> Brown, James : Barclays Wealth<BR><B>Cc:</B>
cisco-voip@puck.nether.net<BR><B>Subject:</B> Re: [cisco-voip] Orphaned User
Device Profiles<BR></FONT><BR></DIV>
<DIV></DIV>
<DIV><SPAN class=717384719-12072010><FONT face=Arial color=#0000ff
size=2> <FONT face=Tahoma color=#000000>>
</FONT> </FONT></SPAN><TT>admin:run sql select name,pkid from device where
tkdeviceprofile=1 and pkid not in (select fkdevice from
enduserdevicemap)<BR><SPAN class=717384719-12072010><FONT face=Arial
color=#0000ff size=2> <FONT face="Courier New" color=#000000 size=3>>
</FONT> </FONT></SPAN>admin:run sql select distinct(fkdevice) from
enduserdevicemap<BR></TT><BR><SPAN class=717384719-12072010><FONT face=Arial
color=#0000ff size=2> <FONT face="Courier New" color=#000000 size=3>>
</FONT> </FONT></SPAN>/Wes<BR><BR><SPAN class=717384719-12072010><FONT
face=Arial color=#0000ff size=2>Thanks very much Wes, that did the
trick. My query earlier (with the LEFT OUTER JOIN) also seemed to work
fine.</FONT></SPAN></DIV>
<DIV><SPAN class=717384719-12072010><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=717384719-12072010><FONT face=Arial color=#0000ff size=2>All
the best,</FONT></SPAN></DIV>
<DIV><SPAN class=717384719-12072010><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=717384719-12072010><FONT face=Arial color=#0000ff
size=2>James.</FONT></SPAN></DIV>
<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>