Custom Software report - List comp. with a specific sw and all installed sw

[CDB]

Hi,

I have been trying to do a report that searches for computers with a specific software and then lists all the other software installed on the computer.
I need this becaus we have a problem with a software and would need to see if there might be some software that interfers with it.

What I would need is:
Computer name, OS, Software that causing problem, Rest of software installed, Computer model

Any help would be great. Kinda stuck on this one...

[CDB]

wow, thanks for the fast replay and it worked like a charm!

thanks for the help!

/Pekka Wikman (Volvo Aero/ Volvo IT)

[Hemoco · Accepted solution]

Try this:

Replace 'Microsoft Outlook 2002'

Select tblComputers.Computername, tblComputers.ComputerUnique,
  tblComputers.Domain, Web40OSName.OSname, tblComputerSystemProduct.Name,
  soft.softwareName As [Problem software], tblSoftware.softwareName As
  [other software]           
From tblComputers Inner Join
  (Select tblsoftware.ComputerName, tblsoftware.softwareName
    From tblsoftware
    Where tblsoftware.softwareName Like 'Microsoft Outlook 2002') soft
  On soft.ComputerName = tblComputers.Computername Inner Join
  Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
  tblComputerSystemProduct On tblComputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblSoftware On tblComputers.Computername = tblSoftware.ComputerName
Order By tblComputers.ComputerUnique, soft.softwareName