→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Jaycee1964
Engaged Sweeper
Hi,

I need a custom report that shows only the

Computer name
Windows version
Version of Internet Explorer

I can get all but the IE version

Thanks in advance.

John
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
Take your existing query and add links to tblSoftware and tblSoftwareUni.
FROM tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID

and add a filter on the software name to your WHERE clause
Where tblSoftwareUni.softwareName Like 'Windows Internet Explorer%'

View solution in original post

1 REPLY 1
RCorbeil
Honored Sweeper II
Take your existing query and add links to tblSoftware and tblSoftwareUni.
FROM tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID

and add a filter on the software name to your WHERE clause
Where tblSoftwareUni.softwareName Like 'Windows Internet Explorer%'