This works!  One more question, if there are multiple versions of the product and in add remove programs they are listed under different names how to change the below parms to look for multiple program names in add remove programs?

Query #1 (devices with software X)

declare @ProductName varchar(100)

set @ProductName = 'Microsoft Office Communicator 2005'

select

      [sys].[AD_Site_Name0] as 'AD Site Name'

      ,[sys].[Name0] as 'Name'

      ,[progs].[DisplayName0] as 'Display Name'

      ,[progs].[Version0] as 'Version'

from [v_R_System] [sys]

join [v_GS_Add_Remove_Programs] [progs] on [sys].[ResourceID] = [progs].[ResourceID]

where

      [sys].[Obsolete0] = 0

      and [progs].[DisplayName0] = @ProductName

Query #2 (devices without software X)

declare @ProductName varchar(100)

set @ProductName = 'Microsoft Office Communicator 2005'

select

      [sys].[AD_Site_Name0] as 'AD Site Name'

      ,[sys].[Name0] as 'Name'

from [v_R_System] [sys]

where

      [sys].[ResourceID] not in

      (

            select

                  [sys].[ResourceID]

            from [v_R_System] [sys]

            join [v_GS_Add_Remove_Programs] [progs] on [sys].[ResourceID] = [progs].[ResourceID]

            where

                  [sys].[Obsolete0] = 0

                  and [progs].[DisplayName0] = @ProductName

      )

      and [sys].[Obsolete0] = 0

Trevor Sullivan | Systems Engineer

End User Technology | IT Operations

OfficeMax Corporation

263 Shuman Boulevard, 1W775

Naperville, IL 60563

P: (630) 864-5211

C: (630) 346-4437

E: TrevorSullivan@OfficeMax.com

I have two reports created that look for a certain file; one report shows what systems have the file and one report shows what systems do not have the file.  I have about 20 systems that are reporting they do not have the file when in fact they do. 

I need to create two more reports that list systems that do and do not have a certain program installed in Add remove programs.  I cannot figure out how to do this, can someone please help?

Thank you!

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/

==============
Missed an email? Check out the list archive:
http://myitforum.com/cs2/blogs/smslist/