→ 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: 
AlanMarquez
Engaged Sweeper II

I would like to know if is possible to have two or + Colums of software where displaying just the software choosing in each column, at this moment this is the querty that I have.

Select Top 1000000 tblassets.AssetID,
tblassets.AssetName,
tblassets.Username,
tsysassettypes.AssetTypename,
tsysassettypes.AssetTypeIcon10 As icon,
tblassets.IPAddress,
tblassetcustom.Location,
tblSoftwareUni.softwareName As [Software 1],
tblSoftwareUni.softwareName As [Software 2],
tblSoftwareUni.softwareName As [Software 3]
From tblassets
Inner Join tblassetcustom On tblassets.AssetID = tblassetcustom.AssetID
Inner Join tsysassettypes On tsysassettypes.AssetType = tblassets.Assettype
Inner Join tblSoftware On tblassets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Where tsysassettypes.AssetTypename Like 'windows'

At this moment this is what I get when I run the report is showinme the same

 

 

 

1 REPLY 1
Jacob_H
Lansweeper Employee
Lansweeper Employee

I think you might be trying to do what I've written about in a Pro-Tip:  https://www.lansweeper.com/blog/pro-tips/reporting-on-compliance/

It makes a column check (yes or no) if the software is found for an asset, and explains the process.