cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dsegel
Engaged Sweeper
I have Linux servers that show the correct OS when editing the asset (e.g. "Ubuntu 14.04.5 LTS") but I can't get that to show up in a report. I've tried both tsysOS and tblOperatingsystem and neither contain the info that shows up in the asset itself.

Where else should I be looking?
1 ACCEPTED SOLUTION
Nick_VDB
Champion Sweeper III
The operating system for Linux computers is stored in the tblLinuxSystem table. In this table you can find the OS release name, Kernel name and version. We added an example report below with these fields.

Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblLinuxSystem.KernelName,
tblLinuxSystem.KernelRelease,
tblLinuxSystem.KernelVersion,
tblLinuxSystem.OSRelease,
tblLinuxSystem.OperatingSystem
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

View solution in original post

1 REPLY 1
Nick_VDB
Champion Sweeper III
The operating system for Linux computers is stored in the tblLinuxSystem table. In this table you can find the OS release name, Kernel name and version. We added an example report below with these fields.

Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:
  • Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  • Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblLinuxSystem.KernelName,
tblLinuxSystem.KernelRelease,
tblLinuxSystem.KernelVersion,
tblLinuxSystem.OSRelease,
tblLinuxSystem.OperatingSystem
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

New to Lansweeper?

Try Lansweeper For Free

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

Try Now