Missing entries from tsysOS table

[sticky]

I've just created the Lansweeper report provided here to get an idea of the installed LSAgent versions in our environment.

I noticed that the OS column is only populated for Windows machines. This column is the OSname column in the tsysOS table, joined via the OScode column in the tblAssets table. The column is blank in the report because there's no corresponding entry in the tsysOS table. Sample OScode values:

Android
Linux
maxOS
OS X

Am I missing entries in the tsysOS table that would exist in new installs (our Lansweeper DB has been upgraded over many years). Can anyone tell me if they have entries for non-Windows OSes in the tsysOS table?

[KevinA-REJIS · Accepted solution]

I created a test report using tsysOS.OScode and tsysOS.OSname, and it's only returning Windows entries so I guess tsysOS might be Windows only. 

[sticky]

Yes it does look like that's the case. I've setup a clean install of Lansweeper, and the only entries in there are Windows entries. I don't really see why it couldn't have other OSes in it though.

So for now I've worked around this by adding the tblAssets.OSCode and tblAssets.AssetTypename to the report. I also tweaked the report by excluding rows with blank LSAgentVersion, as it returned a bunch monitors and other random devices. So FWIW, my tweaked report for LSAgent versions is:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tsysAssetTypes.AssetTypename,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tblAssets.OScode,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.LsAgentVersion,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where IsNull(tblAssets.LsAgentVersion, '') <> '' And tblState.Statename =
'Active'
Order By tblAssets.Domain,
tblAssets.AssetName