Quickly find Patch Policies where all Advertisements in a policy have been disabled
Last Updated March 12, 2019
Windows updates can use a large amount of space on site servers. This provides a way to help identifiy policies that are no longer needed so they can be deleted and disabled allowing the space to be reclaimed.
Typically advertisements are disabled because the associated software update has been superseded. When all advertisements are disabled there is no longer any reason to keep the policy and associated files on the server.
Windows updates can use a large amount of space on site servers.
The following script can be used in an SQL report in the Symantec Management platform.
The report then provides the ability to multi-select Software Update policies and delete them.
After this is done follow the steps in TECH232757 to complete the cleanup process.
Script to be used in the report.
select i.Guid _ItemGuid, substring (i.Name, 0, 50), count (distinct ir.ChildItemGuid) 'TotalAdverts', sum (cast (ia2.Enabled as int)) 'EnabledAdverts', i.createdDatefrom vItem ijoin Itemreference ir on ir.ParentItemGuid = i.Guidand ir.Hint = 'swuadvert'join Item i2 on i2.Guid = ir.childItemGuidjoin ItemActive ia on ia.Guid = i.Guidjoin ItemActive ia2 on ia2.Guid = i2.Guidwhere i.ClassGuid = '49fe4304-e09d-4382-9026-715868ffb856'group by i.Name, i.Guid, i.createdDatehaving sum (cast (ia2.Enabled as int)) = 0order by [EnabledAdverts], i.CreatedDate
Subscribing will provide email updates when this Article is updated. Login is required to Subscribe