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