→ 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: 
JTempleton
Engaged Sweeper III
Afternoon everyone!

I have been able to create most of the things needed, except the OS name and version. What do I need to add those two fields to this report:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblLinuxSoftware.Version,
tblLinuxSoftware.InstallDate
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Where tsysAssetTypes.AssetTypename = 'linux' And tblSoftwareUni.softwareName =
'bash' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
tblSoftwareUni.softwareName

Thanks for your help!
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Please try again with the following report:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblLinuxSoftware.Version,
tblLinuxSoftware.InstallDate,
tblLinuxSystem.OSRelease As OS
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tsysAssetTypes.AssetTypename = 'linux' And tblSoftwareUni.softwareName =
'bash' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
tblSoftwareUni.softwareName

View solution in original post

4 REPLIES 4
JTempleton
Engaged Sweeper III
That did it! Thank you so much!
Hemoco
Lansweeper Alumni
Please try again with the following report:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblLinuxSoftware.Version,
tblLinuxSoftware.InstallDate,
tblLinuxSystem.OSRelease As OS
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tsysAssetTypes.AssetTypename = 'linux' And tblSoftwareUni.softwareName =
'bash' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
tblSoftwareUni.softwareName
JTempleton
Engaged Sweeper III
Thank you for getting back to me on this report. However, when I paste that code in my report and run it, it comes back and says: This report has no results.
Hemoco
Lansweeper Alumni
Please use the following report:

Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblLinuxSoftware.Version,
tblLinuxSoftware.InstallDate,
tsysOS.OSname
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblLinuxSoftware On tblAssets.AssetID = tblLinuxSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID =
tblLinuxSoftware.SoftwareUniID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tsysAssetTypes.AssetTypename = 'linux' And tblSoftwareUni.softwareName =
'bash' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
tblSoftwareUni.softwareName

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now