Your network contains a System Center 2012 Configuration Manager environment.
You need to create a report that lists all of the client computers that do not have an Application
named App1 installed.
Which query should you use to create the report?
A.
SELECT SYS.Netbios_Name0, ARP.DisplayName0
FROM v_R_System AS SYS INNER JOIN
v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP. ResourceID WHERE
ARP.DisplayName0 NOT IN (‘App1’)
B.
SELECT SYS.Netbios_Name0 from v_R_System SYS
WHERE SYS.ResourceID IN
(SELECT SYS.ResourceID
FROM v_R_System AS SYS INNER JOIN
v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID – ARP.ResourceID. WHERE
ARP.DisplayName0 = ‘App1’)
C.
SELECT SYS.Netbios_Name0 from v_R_System SYS
WHERE SYS.ResourceID NOT IN
(SELECT SYS.ResourceID
FROM v_R_System AS SYS INNER JOIN
v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceID WHERE
ARP.DisplayName0 = ‘App1’)
D.
SELECT SYS.Netbios_Name0, ARP.DisplayName0
FROM v_R_System AS SYS INNER JOIN
V_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID – ARP.ResourceID WHERE
ARP.DisplayName0 NOT LIKE ‘App1’
Explanation:
SELECT computer name FROM table v_R_System (SQL Syntax)
WHERE resource ResourceID is NOT IN
Add Remove Programs WHERE DisplayName0 = ‘App1’
http://www.w3schools.com/sqlHYPERLINK
“http://www.w3schools.com/sql/sql_join_inner.asp”/HYPERLINK
“http://www.w3schools.com/sql/sql_join_inner.asp”sql_join_inner.asp
SQL INNER JOIN Keyword
The INNER JOIN keyword returns rows when there is at least one match in both tables.