→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
3 weeks ago
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
3 weeks ago
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.
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now