Your network contains a System Center 2012 Configuration Manger environment.
You need to create a report that list all of the client computers that 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_Sytem AS SYS INNER JOIN
v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceID
WHERE ARP.DisplayName0 NOT LIKE ‘App1’

B.
SELECT SYS.Netbios_Name0 from v_R_System SYS
WHERE SYS.ResourceID NOT IN
(SELECT SYS.ResouceID
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, ARP.DisplayName0
FROM v_R_Sytem AS SYS INNER JOIN
v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceID
WHERE ARP.DisplayName0 NOT IN (‘App1’)

D.
SELECT SYS.Netbios_Name0 from v_R_System SYS
WHERE SYS.ResourceID IN
(SELECT SYS.ResouceID
FROM v_R_System AS SYS INNER JOIN
v_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceID
WHERE ARP.DisplayName0 = ‘App1’)

Explanation:
The inner expression listed below would result in an empty result if the client computer does
not have an application named App1.
Inner expression:
(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’)