Patch Management Solution

 View Only
  • 1.  Software Bulletin Details

    Posted Jul 19, 2016 02:35 PM

    Anyone know what table/view houses the Software Bulletin Details? or a report I can edit to get this information?

    Every month I have to email out what we are patching and I pull this information manually and it is time consuming.

    I bring up resource manager, search bulletin then go Summaries> Software Bulletin Details to get that information.

     

    Any help greatly appreciated



  • 2.  RE: Software Bulletin Details
    Best Answer

    Posted Jul 20, 2016 09:24 AM

    Some Informationen like "Bulletin Name" and "Description" you can find at [dbo].[RM_ResourceSoftware_Bulletin]

    The URL for Information about the KB you´ll find in 

    [dbo].[Inv_Software_Update] and

    [dbo].[Inv_Software_Bulletin]

    and SELECT it via _ResourceGuid



  • 3.  RE: Software Bulletin Details

    Posted Jul 20, 2016 02:43 PM

    I already ran through all of them prior to asking the question... and for some reason I overlooked Summary in 

    [dbo].[Inv_Software_Bulletin]

     

    that is what I wanted...

     

    Now I can spend less time manually getting this info. I think MS changed something as there used to be a (number).. like..

     

    Vulerability on .NET (3144324)

     

     

     Select t0.Name, t0.[Description], t1.Summary
     from [RM_ResourceSoftware_Bulletin] t0
        join [Inv_Software_Bulletin] t1 on t0.Guid = t1._ResourceGuid
    WHERE (datediff(dd,T0.[CreatedDate],getdate()) < 30) 
        and t0.name like 'MS16-%'
    Order by t0.Name

     

    Now I have..

    Name    Description    Summary
    MS16-084    Cumulative Security Update for Internet Explorer    This security update resolves vulnerabilities in Internet Explorer. The most severe of the vulnerabilities could allow remote code execution if a user views a specially crafted webpage using Internet Explorer. An attacker who successfully exploited the vulnerabilities could gain the same user rights as the current user. If the current user is logged on with administrative user rights, an attacker could take control of an affected system. An attacker could then install programs; view, change, or delete data; or create new accounts with full user rights.
    MS16-086    Cumulative Security Update for JScript and VBScript    This security update resolves a vulnerability in the JScript and VBScript scripting engines in Microsoft Windows. The vulnerability could allow remote code execution if a user visits a specially crafted website. An attacker who successfully exploited the vulnerability could gain the same user rights as the current user. If the current user is logged on with administrative user rights, an attacker who successfully exploited the vulnerabilities could take control of an affected system. An attacker could then install programs; view, change, or delete data; or create new accounts with full user rights.
    MS16-087    Security Update for Windows Print Spooler Components    This security update resolves vulnerabilities in Microsoft Windows. The more severe of the vulnerabilities could allow remote code execution if an attacker is able to execute a man-in-the-middle (MiTM) attack on a workstation or print server, or set up a rogue print server on a target network.
    MS16-088    Security Update for Microsoft Office    This security update resolves vulnerabilities in Microsoft Office. The most severe of the vulnerabilities could allow remote code execution if a user opens a specially crafted Microsoft Office file. An attacker who successfully exploited the vulnerabilities could run arbitrary code in the context of the current user. Customers whose accounts are configured to have fewer user rights on the system could be less impacted than those who operate with administrative user rights.
    MS16-090    Security Update for Windows Kernel-Mode Drivers    This security update resolves vulnerabilities in Microsoft Windows. The more severe of the vulnerabilities could allow elevation of privilege if an attacker logs on to an affected system and runs a specially crafted application that could exploit the vulnerabilities and take control of an affected system.
    MS16-091    Security Update for .NET Framework    This security update resolves a vulnerability in Microsoft .NET Framework. The vulnerability could cause information disclosure if an attacker uploads a specially crafted XML file to a web-based application.
    MS16-092    Security Update for Windows Kernel    This security update resolves vulnerabilities in Microsoft Windows. The most severe of the vulnerabilities could allow security feature bypass if the Windows kernel fails to determine how a low integrity application can use certain object manager features.
    MS16-093    Security Update for Adobe Flash Player    This security update resolves vulnerabilities in Adobe Flash Player when installed on all supported editions of Windows 8.1, Windows Server 2012, Windows Server 2012 R2, Windows RT 8.1, and Windows 10.
    MS16-094    Security Update for Secure Boot    This security update resolves a vulnerability in Microsoft Windows. The vulnerability could allow Secure Boot security features to be bypassed if an attacker installs an affected policy on a target device. An attacker must have either administrative privileges or physical access to install a policy and bypass Secure Boot.