Which Updates Supersede Which Updates in Patch Management.
Last Updated June 28, 2017
The Windows Superseded Bulletins report can be used to view which bulletins are superseded and by which bulletins. However, the report is not detailed enough to track individual updates within the bulletins. The following instructions describe how to create and use a custom report that shows every individual update and which updates supersede it.
1. Create the Custom Report
In the Symantec Management Console go to Manage>Reports
Right-click on any desired folder and select New>Report>SQL Report
In the new SQL Report paste the following SQL query in the Parameterized Query box over the default query
SELECT update1.Name [Update],
update2.Name [Superseded By],
bull2.Name [Superseding Bulletin]
FROM vSoftwareUpdate update1
LEFT JOIN ResourceAssociation update2bull
ON update2bull.ChildResourceGuid = update1.Guid
AND update2bull.ResourceAssociationTypeGuid = '7EEAB03A-839C-458D-9AF2-55DB6B173293' --Bulletin to Update
LEFT JOIN vRM_Software_Bulletin_Item bull1
ON bull1.Guid = update2bull.ParentResourceGuid
LEFT JOIN ResourceAssociation super
ON super.ChildResourceGuid = update1.Guid
AND super.ResourceAssociationTypeGuid = '644A995E-211A-4D94-AA8A-788413B7BE5D'--Update Supersedes Update
LEFT JOIN vSoftwareUpdate update2
ON update2.Guid = super.ParentResourceGuid
LEFT JOIN ResourceAssociation update2bull2
ON update2bull2.ChildResourceGuid = update2.Guid
AND update2bull2.ResourceAssociationTypeGuid = '7EEAB03A-839C-458D-9AF2-55DB6B173293' --Bulletin to Update
LEFT JOIN vRM_Software_Bulletin_Item bull2
ON bull2.Guid = update2bull2.ParentResourceGuid
ORDER BY bull1.Name DESC, update1.Name ASC
Name the report something appropriate, such as "Superseded Updates"
Finally click Save Changes.
2. Use the Custom Report
Use the search bar in the upper left corner to search for an update by its KB number; for example, “KB2910910”
Confirm that the results are filtered down and a row for the desired update appears in the Update column
Look in the Superseded By column to find what update (if any) supersedes that update; for example, KB2910910 was superseded by KB2956086
Write down the superseding update and then search for it in the search bar to find out if it too is superseded; for example, KB2956086 was superseded by KB2965304
Repeat this process to follow the chain of superseded updates until the newest (non-superseded) update is found
Please note that Symantec Support does not support custom reports so further modifications must be made by the user.
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe