Single system required Patch’s report from SQL

---Single system required Patch’s report from SQL

 

SELECT DISTINCT

SYS.Name0

AS [Machine Name], UCS.Status AS [Patch Status Code],

CASE WHEN UCS.Status = '2' THEN 'Applicable' WHEN UCS.Status = '3' THEN 'Installed' ELSE '' END AS 'Patch Status', UI.BulletinID, UI.ArticleID,

UI.Title

FROM

v_R_System AS SYS LEFT OUTER

JOIN

v_Update_ComplianceStatusAll

AS UCS ON SYS.ResourceID = UCS.ResourceID INNER
JOIN

v_UpdateInfo

AS UI ON UCS.CI_ID = UI.CI_ID

WHERE

(UCS.Status IN ('3', '2')) AND (SYS.Name0 = 'ServerName'
)