70-243 · Question #42
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_Syatem_ADD_REMOVE_PROGRAMS ARP on…
The correct answer is D. where ARP.DisplayName like "Visual studio%". 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.
Question
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_Syatem_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?
Options
- Awhere ARP.DisplayName like "Visual Studio*"
- Bwhere ARP.DisplayName = "Visual Studio"
- Cwhere ARP.DisplayNarae = "%%Visual Studio"
- Dwhere ARP.DisplayName like "Visual studio%"
How the community answered
(56 responses)- A13% (7)
- B2% (1)
- C5% (3)
- D80% (45)
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.
Topics
Community Discussion
No community discussion yet for this question.