Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

Software not installed

Created: 12 Mar 2013 • Updated: 12 Mar 2013 | 2 comments
This issue has been solved. See 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')
      )
   )

 

Operating Systems:

Comments 2 CommentsJump to latest comment

AngelD's picture

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"

 

SOLUTION
richietheprogrammer's picture

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