
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-26-2016 04:39 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2016 05:34 PM
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:
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
2 REPLIES 2
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-27-2016 05:34 PM
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:
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

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-26-2016 09:27 PM
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
tsysOS.OSname As OS,
tsysOS.Image As icon,
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
