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’
)

Leave a Comment