Here's 1 way. If you only want the ones that deserve the update but don't have
it, then add in to the where clause... and ucs.status=2
select s1.netbios_name0, ucs.ci_id, ucs.status,case when ucs.status=3 then
'installed'when ucs.status=2 then 'required/missing'when ucs.status=0 then
'unknown'else 'something different'end as 'result',ui.title, ui.articleidfrom
v_updateComplianceStatus ucsjoin v_r_system s1 on
s1.resourceid=ucs.resourceidjoin v_updateinfo ui on ui.ci_id=ucs.ci_idwhere
ui.ArticleID='3112343'order by ucs.status
On Friday, January 22, 2016 10:22 AM, David McSpadden <[email protected]>
wrote:
<!--#yiv2649625388 _filtered #yiv2649625388 {font-family:"Cambria
Math";panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv2649625388
{font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #yiv2649625388
{font-family:Montserrat;} _filtered #yiv2649625388
{font-family:Consolas;panose-1:2 11 6 9 2 2 4 3 2 4;}#yiv2649625388
#yiv2649625388 p.yiv2649625388MsoNormal, #yiv2649625388
li.yiv2649625388MsoNormal, #yiv2649625388 div.yiv2649625388MsoNormal
{margin:0in;margin-bottom:.0001pt;font-size:11.0pt;font-family:"Calibri",
sans-serif;}#yiv2649625388 a:link, #yiv2649625388
span.yiv2649625388MsoHyperlink
{color:#0563C1;text-decoration:underline;}#yiv2649625388 a:visited,
#yiv2649625388 span.yiv2649625388MsoHyperlinkFollowed
{color:#954F72;text-decoration:underline;}#yiv2649625388
span.yiv2649625388EmailStyle17 {font-family:"Calibri",
sans-serif;color:windowtext;}#yiv2649625388 .yiv2649625388MsoChpDefault
{font-family:"Calibri", sans-serif;} _filtered #yiv2649625388 {margin:1.0in
1.0in 1.0in 1.0in;}#yiv2649625388 div.yiv2649625388WordSection1 {}-->I am
running this sql query to find all machines that have 3112343 SELECT
n.[DNSHostName0],n.IPAddress0,
q.[HotFixID0],q.Description0,q.InstalledOn0 FROM
[CM_SC1].[SCCM_Ext].[vex_GS_QUICK_FIX_ENGINEERING] q,
[CM_SC1].SCCM_Ext.vex_GS_NETWORK_ADAPTER_CONFIGURATION n where
q.ResourceID=n.ResourceID and q.HotFixID0 like '%3112343%' and n.IPAddress0
!= '' order by n.IPAddress0 I would like to know which machines do not have
the patch. Is there a better query in SQL or a report in SCCM 2012 R2?
David McSpadden System Administrator Indiana Members Credit Union P:
317.554.8190 This e-mail and any files transmitted with it are
property of Indiana Members Credit Union, are confidential, and are intended
solely for the use of the individual or entity to whom this e-mail is
addressed. If you are not one of the named recipient(s) or otherwise have
reason to believe that you have received this message in error, please notify
the sender and delete this message immediately from your computer. Any other
use, retention, dissemination, forwarding, printing, or copying of this email
is strictly prohibited.
Please consider the environment before printing this email.
