Linux Report: All Server with its all Summary, Hardware & User Info

[PeakyBlinder]

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

[PeakyBlinder]

Hello Guys, badly need your help 😞