What should you add to the query?

Your network contains a System Center 2012 Configuration Manger environment.
You write the following query:
Select SYS.Name from SMS_R_System SYS
Join SMS_G_System_ADD_REMOVE_PROGRAMS ARP
On ARP.ResourceID = SYS.ResourceId
You need to create a list of all the client computers that have a version of Microsoft Office
installed.
What should you add to the query?

Your network contains a System Center 2012 Configuration Manger environment.
You write the following query:
Select SYS.Name from SMS_R_System SYS
Join SMS_G_System_ADD_REMOVE_PROGRAMS ARP
On ARP.ResourceID = SYS.ResourceId
You need to create a list of all the client computers that have a version of Microsoft Office
installed.
What should you add to the query?

A.
where ARP.DisplayName like “Microsoft Office*”

B.
where ARP.DisplayName = “Microsoft Office*”

C.
where ARP.DisplayName like “Microsoft Office%”

D.
where ARP.DisplayName = “%Microsoft Office”

Explanation:
For relational operators that perform LIKE comparisons (“is like” or “is not
like”), you can use wildcard characters within the string. You can use the following
wildcards.
Wildcard Description
%
Any string of zero or more characters
_ (underscore)
Any single character
[]
Any single character within the range or set (for example [a-f] or [abcdef])
[^]
Any single character not within the specified range (for example [^a-f] or [^abcdef])



Leave a Reply 1

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


Kiran

Kiran

where ARP.DisplayName like “Microsoft Office%”