6/19/2012 · I’m attempting to build a query rule for a collection that contain Microsoft Office Professional Plus 2010 from 32-bit add/remove programs (SMS_G_System_ADD_REMOVE_PROGRAMS.DisplayName) and 64-bit add/remove programs (SMS_ G_System_ADD_REMOVE_PROGRAMS _64.DisplayName).
12/22/2011 · I’m trying to get a list of all installed software on a given computer through the SDK. I have already gotten the computer resourceID, so now it’s just to create a query which allows me to list all installed software. I used the query functionality in ConfigMgr 2007 to create this query: select … · Aye. I changed the query to ‘select * from SMS_G …
9/25/2014 · SMS_ G_System_ADD_REMOVE_PROGRAMS _64.DisplayName = “Microsoft Project 2010” Having one query to find either x86 or x64 software titles is useful when creating a collection of all PCs that do not have a specific software title installed.
to answer to myself: select SMS_R_System.Name, SMS_R_System.Client, SMS_G_System_ADD_REMOVE_PROGRAMS_64.DisplayName, SMS_G_System_ADD_REMOVE_PROGRAMS_64.Version from SMS_R_System inner join SMS_G _System_ADD _REMOVE_PROGRAMS_64 on.
8/14/2017 · The Office 365 32 bits is in the SMS_ G_System_ADD_REMOVE_PROGRAMS _64, so i can’t make a difference between the 32 of 64 bits of Office installed, like is mentioned above! Best regards, Frank, SMS_G_System Server WMI Class . 09/20/2016 2 minutes to read a d In this article. The SMS_G_System Windows Management Instrumentation (WMI) class is an SMS Provider server class, in Configuration Manager, that serves as the abstract base class for all hardware and software system classes, for example, SMS_G_System_CI_ComplianceState Server WMI.
6/14/2016 · Gents, Im a little bit confused with those classes (SMS_ G_System _INSTALLED_SOFTWARE and SMS_G_System_ADD_REMOVE_PROGRAMS). From my point of view SMS_ G_System _INSTALLED_SOFTWARE is inconsistent and does not reflect the reality but.
5/10/2016 · SMS_G_System_ADD_REMOVE_PROGRAMS / SMS_G_System_ADD_REMOVE_PROGRAMS_64 comes from Hardware Inventory, whereas SMS_G_System_INSTALLED_SOFTWARE comes for AI Inventory. Yes, there are a lot of similarities between them, but they are NOT an exact match. The installed software view is a.
where resourceid in (select resourceid from SMS_ G_System_ADD_REMOVE_PROGRAMS _64 where SMS_ G_System_ADD_REMOVE_PROGRAMS _64.DisplayName like Adobe Flash Player%) or select SMS_R_System.Name from SMS_R_System, 1/9/2020 · OR SMS_ G_System_ADD_REMOVE_PROGRAMS _64.Version LIKE [1-6]9.% OR SMS_ G_System_ADD_REMOVE_PROGRAMS _64.Version = 79.0.3945.79 OR SMS_ G_System_ADD_REMOVE_PROGRAMS _64.Version = 79.0.3945.88) All stable Chrome versions less than 79.0.3945.117 will be found. This does, however, only find 64-bit versions …
