WebDec 29, 2024 · So the v_Add_Remove_Programs table is the one that would provide you with active data for both 32-bit and 64-bit programs, but you may want to choose to only have 32-bit data, in which case would be v_GS_Add_Remove_Programs table. More Queries. Our full range of SQL and WQL Collection queries are available here. Feedback WebFeb 10, 2024 · and change "Adobe Acrobat%" to the application you want. Remember you can use % in the beginning or the end of a statement to work like a variable. Next is the version number, in the example code the line. SMS_G_System_ADD_REMOVE_PROGRAMS.Version >= "9%". The "9%" is the version, you …
SOLVED - Report Fetching through SQL Query SCCM
WebAdd/remove programs data is data that is (usually) written to the registry in Windows when a program is installed. Execution data is collected by the software metering part of the SCCM client. It monitors the execution of .exe files. An .exe file is not necessarily a program in add/remove programs, and a program in add/remove programs may have ... WebFeb 11, 2010 · This is to list the computers in collection rather report. Create a collection and edit the query ,paste the following into it. select * from SMS_R_System inner join … javascript programiz online
sccm collection for add and remove programs with ms office
WebNov 4, 2024 · It is not supported to query the tables directly. The query took a long time as you don't have join setup. Select R.Name0 as 'Computer Name', R.AD_Site_Name0 as 'AD Name', ARP.DisplayName0 as 'Application Name', ARP.Version0 as 'Version', COUNT (*) as Qty FROM v_R_System R INNER JOIN v_ADD_REMOVE_PROGRAMS ARP ON … WebAug 13, 2024 · Viewed 2k times. 1. I'm having a problem with this part of a SCCM WQL query looking for "less than version 75.0.3770.80": ... where SMS_G_System_ADD_REMOVE_PROGRAMS.Version < "75.0.3770.80". If i'm not mistaken this is the good old problem seen before in other scenarios (file names for example) … WebSimply copy and paste these into the sccm query statement of the query rule. Let me know in the comments below if you need a specific query and I will add it to this ... (select distinct SMS_G_System_ADD_REMOVE_PROGRAMS.ResourceID from SMS_G_System_ADD_REMOVE_PROGRAMS where … javascript print image from url