You are the network administrator for a company named Contoso, Ltd.
The network contains 1,000 desktop computers and 500 servers.
The network contains a System Center 2012 Configuration Manager environment.
The names of all the desktop computers in the human resources department start with the letters
HR, for example HR001 and HR023.
A device collection named All Server Devices contains all of the servers.
A device collection named All Desktop Devices contains all of the desktop computers. You plan to
create a new collection named All HR Computers and Servers.
The new collection must contain all of the human resources department computers and all of the
servers. The collection must not contain any other computers.
You need to create a membership rule for the new collection.
Which rule should you include in the membership rule? (Choose all that Apply.)
A.
QUERY RULE: select * from SMS_R_System where SMS_R_system.NetbiosName like “HR%”
B.
INCLUDE RULE: All Server Devices
C.
EXCLUDE RULE: All NON HR Computers
D.
EXCLUDE RULE: All Desktop Devices
E.
QUERY RULE- select * from SMS_R_System where
SMS_R_system.OperatingSystemNameandVersion like. *%Workstation*
F.
QUERY RULE-select * from SMS_R_System where
SMS_R_system.OperatingSystemNameandVersion not like. *%Server*
Explanation:
Select * from SMS_R_System where SMS_R_system.NetbiosName like “HR%”
SQL command to select all Systems whose names begin with HR
INCLUDE RULE: All Server Devices Selects all the Server Devices as asked in the question.
Further information:
http://technet.microsoft.com/en-us/library/gg682177.aspx
Introduction to Collections in Configuration Manager
Collections in System Center 2012 Configuration Manager represent logical groupings of resources,
such as users and devices. You can use collections to help you perform many tasks, such as managing
applications, deploying compliance settings, or installing software updates. You can also use
collections to manage groups of client settings.
Additionally, System Center 2012 Configuration Manager uses collections with role-based
administration to specify the collections that an administrative user can access.
Collection Rules
Direct Rule
Query Rule
Query rules dynamically update the membership of a collection based on a query that Configuration
Manager runs on a schedule.
Unlike direct rule collections, this collection membership automatically updates when you add or
remove new users to the Human Resources organizational unit.
Include Collections Rule
The include collections rule lets you include the members of another collection in a Configuration
Manager collection. Configuration Manager updates the membership of the current collection on a
schedule if the membership of the included collection changes.
Exclude Collections Rule The exclude collections rule lets you exclude the members of another
collection from a Configuration Manager collection. Configuration Manager updates the
membership of the current collection on a schedule if the membership of the excluded collection
changes. Note: If a collection includes both include collection and exclude collection rules and there
is a conflict, the exclude rule takes priority over the include rule.
Default Collections in Configuration Manager
All User Groups
All Users
All Users and User Groups
All Mobile Devices
All Systems
All Unknown Computers