Check Resource Explorer first to see where the data is populating? Don't just write the query and see what works, go look where the data is reporting first.
Most likely you want 'Installed Software' not 'Installed Applications'. Daniel Ratliff From: [email protected] [mailto:[email protected]] On Behalf Of sms sccm Sent: Wednesday, February 11, 2015 12:33 PM To: [email protected] Subject: [mssms] query Add Remove Programs (32 and 64) Dear all, I need a query for systems (x32 and x64) not having .NET 4.5.2 first I did a query that should give me all .NET 4.5.2 installations: [cid:[email protected]] but it only returns records for x64 OS I know there are records for x32: [cid:[email protected]] this returns x32 Systems why does the first query not work for "Installed Applications (64).Display Name" OR "Installed Applications.Display Name"??? The built-in report "Computers with specific software registered in Add Remove Programs" does return all records because it is using the view "v_Add_Remove_Programs". I need the same data with a query to create a collection. Thanks for any insights The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.
