You problem is that you have an inner join between the x86 and x64 view. Therefore you will only see data from the x64 computers. Instead use an outer join to get either x86 or x64.
From: [email protected] [mailto:[email protected]] On Behalf Of sms sccm Sent: Wednesday, February 11, 2015 1:03 PM To: [email protected] Subject: RE: [mssms] query Add Remove Programs (32 and 64) [cid:[email protected]] ________________________________ From: [email protected]<mailto:[email protected]> To: [email protected]<mailto:[email protected]> Subject: RE: [mssms] query Add Remove Programs (32 and 64) Date: Wed, 11 Feb 2015 17:57:13 +0000 What exactly does your query look like? How exact did you write you "joins"? From: [email protected]<mailto:[email protected]> [mailto:[email protected]] On Behalf Of sms sccm Sent: Wednesday, February 11, 2015 12:33 PM To: [email protected]<mailto:[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
