Queries for Collections for a Specific Machine and All Software In Add/Remove Programs « Deploy. OS. com. Posted on October 1.
Updated on April 4, 2. For a number of years, I have been collecting SQL Server queries that I use regularly. They allow me to get requested data much quicker without having to write a new query each time.
Yes, I know that the builtin Report 97 lists differences between the software inventory reported for two selected computers. BUT! That is not what I want, as this report lists only the discrepancies, and more. Also, as the tables have common fields, you could use a UNION select to produce a combined list of 32 and 64 bit applications, with an identifier column to display if the data is coming from the x86 or x64 data. I have. This is using SCCM 2012 r2. I am a newbie to the reports. I want to create a report to show all the computer's program in add/remove programs for a. One Response to SCCM Report : Count of all instances of software registered with Add or Remove Programs that you want to list. Subselect Query in SCCM Update (1/30/2010): We recently discussed subselect queries at the Minnesota System Center User Group. That discussion prompted me to write an updated post on subselect queries. Please refer to the. Select sys.name0,(select distinct 'Software ARP1' from v_Add_Remove_Programs ARP where (ARP.ResourceID=SYS.ResourceID) and exists (select ARP.DisplayName0 where ARP.DisplayName0='Software ARP1')),(select distinct 'Software.
Today I was asked to create a report in SCCM / ConfigMgr that shows all installed products in Add & Remove Programs. My customer wanted to know all applications installed on all computers… Instead of writing the whole thing.
Below are two queries that I use often and have saved me a lot of time. All Collections that a Specific Machine is In SELECT S3. Name. FROM v_R_System AS S1 INNER JOIN. Full. Collection. Membership AS S2 ON S1. Resource. ID = S2.
Resource. ID INNER JOIN. Collection AS S3 ON S2. Collection. ID = S3. Collection. ID. WHERE (S1. Netbios_Name. 0 = '< < Insert. Machine. Name> > ')All Software In Add/Remove Programs on a Specific Machine (x. SELECT S2. Display.
Select v_Add_Remove_Programs.DisplayName0, v_Add_Remove_Programs.Publisher0, v_Add_Remove_Programs.Version0. SCCM SQL Query to Determine Installed Browsers. I recently wrote the following SQL Query to help identify which browsers are installed across our environment. A straight Add/Remove Programs (v_AddRemovePrograms) query didn’t.
Name. 0 AS 'Display Name', S2. Version. 0, S2. Install. Date. 0. FROM v_R_System AS S1 INNER JOIN. GS_ADD_REMOVE_PROGRAMS AS S2 ON S1. Resource. ID = S2.
Resource. ID. WHERE (S1. Netbios_Name. 0 = 'CM1. SELECT S2. Display. Name. 0 'Display Name', S2. Version. 0, S2. Install. Date. 0. FROM v_R_System AS S1 INNER JOIN.
GS_ADD_REMOVE_PROGRAMS_6. AS S2 ON S1. Resource. ID = S2. Resource. ID. WHERE (S1. Netbios_Name. Insert. Machine. Name> > ').
ORDER BY 'Display Name'Â.