70-243 · Question #172
You have a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) deployment. You need to create a Configuration Manager solution to retrieve only the client computers that do not have…
The correct answer is A. Not in. To find computers that do NOT have a specific application installed, the WQL subquery must use 'Not in' to exclude resources that appear in a subquery matching the installed software.
Question
You have a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) deployment. You need to create a Configuration Manager solution to retrieve only the client computers that do not have Microsoft Office 2013 installed. You create a query. What should you include in the subquery?
Options
- ANot in
- BNot like
- C< =
- D!=
How the community answered
(61 responses)- A77% (47)
- B7% (4)
- C3% (2)
- D13% (8)
Why each option
To find computers that do NOT have a specific application installed, the WQL subquery must use 'Not in' to exclude resources that appear in a subquery matching the installed software.
'Not in' is the correct WQL/SQL operator for a subquery that returns a set of resource IDs where Office 2013 is installed, and then excludes those resource IDs from the outer query result. This pattern - 'SELECT ResourceID FROM ... WHERE ResourceID Not in (SELECT ResourceID FROM ... WHERE software matches Office 2013)' - is the standard Configuration Manager approach for negation subqueries against inventory data.
'Not like' is a pattern-matching operator used for string exclusion on a direct column value, not for excluding results returned by a subquery.
'<=' is a numeric comparison operator and has no logical relationship to excluding a set of results produced by a subquery.
'!=' compares a single value against another single value and cannot be used to exclude an entire result set produced by a subquery.
Concept tested: SCCM WQL subquery negation with Not in operator
Source: https://learn.microsoft.com/en-us/mem/configmgr/core/servers/manage/create-queries
Topics
Community Discussion
No community discussion yet for this question.