Your network contains a System Center 2012 Configuration Manager 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:
You need to use “LIKE” not “=” otherwise the WildCard “%” is seen as a real identifier.