Câu 33: 70-243: Administering and Deploying System Center 2012 Configuration Manager (SCCM)

Your network contains a System Center 2012 R2 Configuration Manager Service Pack 1 (SP1) 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?

1. A. SELECTSYS.Netbios_Name0, ARP.DisplayName0FROM v_R_System AS SYS INNER JOINv_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP. ResourceID WHERE ARP.DisplayName0 NOT IN ('App1')
2. B. SELECT SYS.Netbios_Name0 from v_R_System SYSWHERE SYS.ResourceID IN(SELECT SYS.ResourceIDFROM v_R_System ASSYS INNER JOINv_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID - ARP.ResourceID. WHERE ARP.DisplayName0 = 'App1')
3. C. SELECT SYS.Netbios_Name0 from v_R_System SYSWHERE SYS.ResourceID NOT IN(SELECT SYS.ResourceIDFROM v_R_SystemAS SYS INNER JOINv_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceID WHERE ARP.DisplayName0 = 'App1') — đáp án hiện tại
4. D. SELECT SYS.Netbios_Name0, ARP.DisplayName0FROM v_R_System AS SYS INNER JOINV_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID - ARP.ResourceID WHERE ARP.DisplayName0NOT LIKE 'App1'