PrepAway - Latest Free Exam Questions & Answers

Which query should you use to create the report?

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?

PrepAway - Latest Free Exam Questions & Answers

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’

2 Comments on “Which query should you use to create the report?”

  2. gex says:

    C

    this subquery return computers with App1 installed
    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’

    and main query return all computers that NOT IN subquery result

    Right answer is C




    0



    0

Leave a Reply