Deployment Solution

Hello, I am using the below code for a filter listing all computers that have a certain software installed (The software does not show in Add/remove programs). I am trying to create a software that lists all the computers that do NOT have that certain software installed. Any ideas would be much appreciated!!

The code for the computer list (installed):

SELECT
   [vri1_Computer].[Guid],
   [vri1_Computer].[Name]
FROM
   [vRM_Computer_Item] AS [vri1_Computer]
      LEFT OUTER JOIN [Inv_AeX_AC_NT_Services] AS [dca2_AeX AC NT Services]
         ON ([vri1_Computer].[Guid] = [dca2_AeX AC NT Services].[_ResourceGuid])
WHERE
   (
      (
         ([dca2_AeX AC NT Services].[Description] = N'Software X')
      )
   )

 

What do you want to do with the filter?

If for a Policy or task then just exclude computers in <filter> "my filter with computers with a certain software installed"

That makes sense. I have a filter for laptops, so I can just include all laptops and exclude the above filter. Thanks!