Over time the ResourceTargetContainerChanges table grows out of control into the GB of wasted space. The busier the NS the quicker this table grows. ----
Steps to duplicate: 1. Create a saved target and make sure it is not applied to any policies 2. Run the Patch Management Solution for Windows PMImport. 3. Stage a bulletin after the PMImport has completed. 4. Look at the ResourceTargetContainerChanges table to see that there are a large number of resources that should not be in a target such as files and inventory rules. 5. Run the NS.Complete Resource Membership update schedule to cleanup the table. 6. Look at the contents of the table again to verify that there is data that should not exist.
The following queries can be run to verify the issue:
--Count of Filters\Targets by Target\Filter SELECT i.Name, rtcc.ResourceTargetGuid, COUNT (rtcc.ResourceTargetGuid) FROM ResourceTargetContainerChanges rtcc JOIN Item i ON i.Guid = rtcc.ResourceTargetGuid GROUP BY i.Name, rtcc.ResourceTargetGuid ORDER BY i.Name
--Name of target and resource SELECT tar.Name, res.Name FROM ResourceTargetContainerChanges rtcc LEFT JOIN vItem tar ON tar.Guid = rtcc.ResourceTargetGuid LEFT JOIN vItem res ON res.Guid = rtcc.ResourceGuid order by tar.name
--total count of the table select COUNT (1) from ResourceTargetContainerChanges
--Resource Targets that do not have a policy applied to them. SELECT * FROM ResourceTargetContainerChanges rtcc LEFT JOIN ItemAppliesTo iat ON iat.ResourceTargetGuid = rtcc.ResourceTargetGuid WHERE iat.ResourceTargetGuid IS NULL
--Count of resources that are not a computer or user. SELECT COUNT (1) FROM ResourceTargetContainerChanges rtcc LEFT JOIN vResource r ON r.Guid = rtcc.ResourceGuid AND r.ResourceTypeGuid IN ('493435F7-3B17-4C4C-B07F-C23E7AB7781F',--Computer '2C3CB3BB-FEE9-48DF-804F-90856198B600',--Virtual Computer '4C94C174-795B-4DF1-B6E8-D6F1A9B1017D',--Computer 'FD864F19-4437-4A4F-8709-58EB5E3AE0A4')--User LEFT JOIN ItemAppliesTo iat ON iat.ResourceTargetGuid = rtcc.ResourceTargetGuid WHERE iat.ResourceTargetGuid IS NULL AND r.Guid IS NULL
The ResourceTargetContainerChanges table is getting populated with items that are not resources and targets\filters that are not applied to a policy.
This issue has been reported to Symantec Development Team. A fix is targeted for the next release (SMP 7.0 MR4 and SMP 7.1 MP1)
In the meantime, you can truncate ResourceTargetContainerChanges table in order to regain space, if you follow with an iisreset after the truncation.
Symantec Management Platform 7.0 SP5 and earlier, 7.1
ID: 2236604, 2207371
Imported Document ID: TECH157997
Subscribing will provide email updates when this Article is updated. Login is required.