Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

An empty Configuration Manager query based collection membership rule returns all systems


Summary

Consider the following scenario:

1. You are using System Center Configuration Manager 2007 (ConfigMgr 2007) and create a new collection.

2. A new query-based membership rule is selected but no further criteria defined.

This results in a default query statement of "Select * from SMS_R_System" being used which is the same query used as a membership rule for the All Systems collection. 

↑ Back to the top


More Information

This is expected behavior in System Center Configuration Manager 2007.

↑ Back to the top


Keywords: vkball, kb

↑ Back to the top

Article Info
Article ID : 2692589
Revision : 1
Created on : 1/8/2017
Published on : 9/4/2012
Exists online : False
Views : 108