Hello,
I'm trying to get all the Linux Servers with their Summary, Hardware & User Info. See the below sample:
Currently, here's the SQL code I'm using.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblLinuxSystem.KernelName,
tblLinuxSystem.KernelRelease,
tblLinuxSystem.OSRelease,
tblLinuxSystem.OperatingSystem,
tblAssets.Processor,
tblAssetCustom.Contact,
tblAssetCustom.Model
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Where tblAssetCustom.State = 1
Thank you in advance! Happy new year! 🎆
PB
