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 Visual Studio
installed.
What should you add to the query?
A.
where ARP.DisplayName like “Visual Studio*”
B.
where ARP.DisplayName = “*Visual Studio*”
C.
where ARP.DisplayName = “%%Visual Studio”
D.
where ARP.DisplayName like “Visual studio%”
Explanation:
You need to use “Like” not “=” otherwise the WildCard “%” is seen as a real identifier.
Better to use % compared to *. With % you would only get different versions of Visual Studio
and not other applications with names starting with Visual Studio.