Which query should you use to create the report?

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 have an application named App1 installed.
Which query should you use to create the report?
A. SELECT SYS.Netbios_Name0, ARP.DisplayName0FROM v_R_Sytem AS SYS INNER JOINv_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceIDWHERE ARP.DisplayName0 NOT LIKE ‘App1’
B. SELECT SYS.Netbios_Name0 from v_R_System SYSWHERE SYS.ResourceID NOT IN(SELECT SYS.ResouceIDFROM v_R_System AS SYS INNER JOINv_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceIDWHERE ARP.DisplayName0 = ‘App1’)
C. SELECT SYS.Netbios_Name0, ARP.DisplayName0FROM v_R_Sytem AS SYS INNER JOINv_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceIDWHERE ARP.DisplayName0 NOT IN (‘App1’)
D. SELECT SYS.Netbios_Name0 from v_R_System SYSWHERE SYS.ResourceID IN(SELECT SYS.ResouceIDFROM v_R_System AS SYS INNER JOINv_GS_ADD_REMOVE_PROGRAMS AS ARP ON SYS.ResourceID = ARP.ResourceIDWHERE ARP.DisplayName0 = ‘App1’)

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.