Collections without Queries that have Update Schedules

Chris.Kibble

Administrator
Staff member
#1
Based on a conversation in this thread:

SQL:
select v_collection.CollectionID
     , v_collection.Name
  from v_collection
  left join v_CollectionRuleQuery
    on v_collection.CollectionID = v_CollectionRuleQuery.CollectionID
 where v_collection.RefreshType != 1 -- (Has a schedule or periodic updates) https://blogs.technet.microsoft.com/leesteve/2017/08/22/sccm-for-those-nasty-incremental-collections/
   and v_CollectionRuleQuery.CollectionID is null -- Has no queries
 
Top