linux software report

[marc_dub]

looking to get an inventory of all my Linux machines that have mysql installed.

Anyone have this report working.

thanks

[marc_dub · Accepted solution]

Got sorted

used this...http://www.lansweeper.com/forum/yaf_postst8903_Linux-Software-Installed-Reporting.aspx


Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename As Type,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblSoftwareUni.softwareName,
tblLinuxSoftware.Version,
tblSoftwareUni.SoftwarePublisher,
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 =
'mysql' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric,
tblSoftwareUni.softwareName