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 instated…

The correct answer is C. SELECT SYS.Netbios_Name0 from v_R_System SYS. SELECT computer name FROM table v_R_System (SQL Syntax) WHERE resource ResourceID is NOT IN Add Remove Programs WHERE DisplayName0 = 'App1' SQL INNER JOIN Keyword The INNER JOIN keyword returns rows when there is at least one match in both tables.

Managing Sites and Clients

Question

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 instated. Which query should you use to create the report?

Options

ASELECT SYS.Netbios_Name0, ARP.DisplayName0
BSELECT SYS.Netbios_Name0 from v_R_System SYS
CSELECT SYS.Netbios_Name0 from v_R_System SYS
DSELECT SYS.Netbios_Name0, ARP.DisplayName0

How the community answered

(38 responses)

A
5% (2)
B
11% (4)
C
63% (24)
D
21% (8)

Explanation

SELECT computer name FROM table v_R_System (SQL Syntax) WHERE resource ResourceID is NOT IN Add Remove Programs WHERE DisplayName0 = 'App1' SQL INNER JOIN Keyword The INNER JOIN keyword returns rows when there is at least one match in both tables.

Topics

#SQL query#reporting#application inventory#subquery

Community Discussion

No community discussion yet for this question.

Full 70-243 Practice