SQL: Show All Patch Bulletins

Version 2

    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