maxwell.2k19
Member
- Messages
- 8
- Reaction score
- 0
- Points
- 1
Hi Experts
i have a collection lets say TEST which has windows 2012R2 Servers, Windows 2016 Servers and Windows 2019 servers.
Some servers in this collection have browsers installed. i want to pull all the servers which have Google Chrome installed from this collection and create a new collection
of servers having chrome installed lets say TEST_Chrome. in the same way i want to do for firefox as well. will the below query fetch me the browser information and how to create a collection from query.
In Add/Remove programs for chrome i can see Google Chrome, for firefox on one server i can see Mozilla Firefox 80.0.1 (x64 en-US)(servers may have different versions)
For firefox will the below query work(in Add/Remove Programs its Mozilla Firefox 80.0.1 (x64 en-US) on one server)
SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Firefox%"
For Chrome will the below query work(in Add/Remove Programs its Google Chrome)
SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Google Chrome%"
if there is any 32bit version how do i pull that also, i dont want to combine two queries iwant to create separate collection one for Firefox and one for chrome
i have a collection lets say TEST which has windows 2012R2 Servers, Windows 2016 Servers and Windows 2019 servers.
Some servers in this collection have browsers installed. i want to pull all the servers which have Google Chrome installed from this collection and create a new collection
of servers having chrome installed lets say TEST_Chrome. in the same way i want to do for firefox as well. will the below query fetch me the browser information and how to create a collection from query.
In Add/Remove programs for chrome i can see Google Chrome, for firefox on one server i can see Mozilla Firefox 80.0.1 (x64 en-US)(servers may have different versions)
For firefox will the below query work(in Add/Remove Programs its Mozilla Firefox 80.0.1 (x64 en-US) on one server)
SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Firefox%"
For Chrome will the below query work(in Add/Remove Programs its Google Chrome)
SMS_R_SYSTEM.ResourceID,SMS_R_SYSTEM.ResourceType,SMS_R_SYSTEM.Name,SMS_R_SYSTEM.SMSUniqueIdentifier,SMS_R_SYSTEM.ResourceDomainORWorkgroup,SMS_R_SYSTEM.Client from SMS_R_System inner join SMS_G_System_ADD_REMOVE_PROGRAMS_64 on SMS_G_System_ADD_REMOVE_PROGRAMS_64.ResourceID = SMS_R_System.ResourceId where SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName like "%Google Chrome%"
if there is any 32bit version how do i pull that also, i dont want to combine two queries iwant to create separate collection one for Firefox and one for chrome
