Purpose

These script shows all of the patch bulletins for the specified Operating Systems listed toward the end of the script.

Overview

--Run in sql management studio.

--In the below commands a few Windows Operating Systems are shown, you may add more or subtract by following the pattern.

USE PLUS

SELECT DISTINCT B.Bulletin_Name

FROM Reports_To_OperatingSystems RO

JOIN REPORTS R ON R.Report_ID = RO.Report_ID

JOIN OperatingSystems OS ON OS.OperatingSystem_ID = RO.OperatingSystem_ID

JOIN Bulletins B ON B.Bulletin_ID = R.Bulletin_ID

WHERE OperatingSystem_Name LIKE '%Windows 8%'

OR OperatingSystem_Name LIKE '%Server 2012%'

OR OperatingSystem_Name LIKE '%Server 2016%'

ORDER BY B.Bulletin_Name

Additional Information

Affected Products

EMSS