:::: MENU ::::
Monthly Archives: March 2016

Software Updates Installed using SCCM or Manually

SELECT  sys.Name0,ui.BulletinID, ui.ArticleID,ui.Title,

CASE when (ucs.Status=2 and ui.IsDeployed=0 )then ‘Required_General’

when (ucs.Status=2 and ui.IsDeployed=1 )then ‘Required_ITICSDeploy’

WHEN (UCS.Status=3 and ui.IsDeployed=1 ) then ‘Installed_SCCM’

WHEN (UCS.Status=3 and ui.IsDeployed=0 ) then ‘Installed_Manual’

when UCS.Status=0 then ‘Unknown’  end as ‘Status’, case WHEN ui.severity=10 THEN ‘Critical’

WHEN ui.severity=8 THEN ‘Important’

WHEN ui.severity=6 THEN ‘Moderate’

WHEN ui.severity=2 THEN ‘Low’ WHEN ui.severity=0 THEN ‘AddOn’ end as ‘Severity’

FROM v_R_System sys

INNER JOIN v_UpdateComplianceStatus UCS ON   sys.ResourceID = ucs.ResourceID

INNER JOIN v_UpdateInfo UI ON   UCS.CI_ID = UI.CI_ID

WHERE –UI.IsDeployed=1 and

sys.Netbios_Name0=’computer1′

ORDER BY Status