Page 1 of 1

Your network contains a System Center 2012 Configuration Manager environment. You have the following query: Select - R

Posted: Mon Oct 17, 2022 4:05 pm
by answerhappygod
Your network contains a System Center 2012 Configuration Manager environment.
You have the following query:

Select -
R .Name,

U .UserName -

From -

SMS_R_System R -

Join SMS_R_User U -
On R.LastLogonUserName = U.UserName
You need to ensure that all of the client computers are listed in the query results.
Which join type should you use?

A. LEFT
B. FULL
C. INNER
D. RIGHT