How to include full windows OS in a report?

[lznoc]

This OS information is seen when hovering over a host name, I can not seem to add this information to report nor can I find any details on how to do this. The only thing I have found is listed below but it seems the tables are older and no longer part of Lansweeper. I've tried tweaking it but to no avail, any help would be great thank you.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, RTrim(tblOperatingsystem.Caption + ' ' +
tblOperatingsystem.OtherTypeDescription) as OS, tblOperatingsystem.OSType
From tblComputers Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername

[RCorbeil · Accepted solution]

I do the same as esr for the short OS name and icon. If you want the full OS name (e.g. "Microsoft Windows 7 Professional"), look to tblOperatingSystem.Caption.

As far as I know, the bitness can be derived from tblComputerSystem.SystemType:

Case
  When tblComputerSystem.SystemType Like 'X86%' Then '32-bit'
  When tblComputerSystem.SystemType Like 'x64%' Then '64-bit'
  Else ''
End As OSBitness

[esr]

I often use tsysOS.OSname to provide the short version (Win 7, Win 8, Win 10 etc). I'll also use tsysOS.Image as well for the icon-

tsysOS.OSname As OS,
tsysOS.Image As icon,


Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode