cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
lznoc
Engaged Sweeper
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
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
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

View solution in original post

2 REPLIES 2
RCorbeil
Honored Sweeper II
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
Champion Sweeper
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

New to Lansweeper?

Try Lansweeper For Free

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

Try Now