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…

The correct answer is D. SELECT SYS.Netbios_Name0 from v_R_System SYS. SELECT computer name FROM table v_R_System (SQL Syntax) WHERE resource ResourceID is 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.

Deploying and Administering Applications

Question

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?

Options

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

How the community answered

(38 responses)

A
5% (2)
B
3% (1)
C
11% (4)
D
82% (31)

Explanation

SELECT computer name FROM table v_R_System (SQL Syntax) WHERE resource ResourceID is 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

#SSRS reporting#SQL view query#application inventory#v_R_System

Community Discussion

No community discussion yet for this question.

Full 70-243 Practice