Add OS name to report

[JTempleton]

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!

[JTempleton]

That did it! Thank you so much!

[Hemoco · Accepted solution]

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]

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]

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