
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-25-2011 09:59 AM
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...
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...
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-25-2011 10:10 AM
Try this:
Replace 'Microsoft Outlook 2002'
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
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-25-2011 11:24 AM
wow, thanks for the fast replay and it worked like a charm!
thanks for the help!
/Pekka Wikman (Volvo Aero/ Volvo IT)

thanks for the help!
/Pekka Wikman (Volvo Aero/ Volvo IT)

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-25-2011 10:10 AM
Try this:
Replace 'Microsoft Outlook 2002'
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
