cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
CDB
Engaged Sweeper
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...
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
CDB
Engaged Sweeper
wow, thanks for the fast replay and it worked like a charm!

thanks for the help!

/Pekka Wikman (Volvo Aero/ Volvo IT)
Hemoco
Lansweeper Alumni
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