Target's scope is set to the broadest "All Resources". A computer collection should have computer as it's scope. This can causes triggers to invalidate too many targets and cause high memory usage and slow collection/target membership updates.
"All Resource" scope used rather than computers for computer filters. This can also happen to other types of resources, but the one most often experienced appear to be computer resources.
Use this SQL to see the filter names:
select i2.Name as 'Collection', i.Name as 'Target', i3.Name as 'Scope', case when i2.Attributes &1 = 1 then 'Hidden' else 'Visible' end as 'Visibility'
from ResourceTarget rt
join ItemReference ir on ir.ParentItemGuid = rt.Guid
and ir.Hint = 'resourcetargetfilter'
join Item i on i.Guid = rt.Guid
join Item i2 on i2.Guid = ir.ChildItemGuid
join Item i3 on i3.Guid = rt.ScopeCollectionGuid
where ScopeCollectionGuid = 'CAFC430C-6705-4A21-8E39-7AA0DA861A87'
order by 4 desc, 1
This will be resolved in 7.5 until that is released do the following:
Applies To
SMP 7.1 +