Operating System Overview

Discover All Operating Systems in Your Network

Get an audit of all the operating systems that are present in your environment with the exact operating system version and additional details like possible service packs, domain, user, IP address and more. This helps you to identify exactly what kind of operating systems are in your network as it can be difficult to find out exactly what version of an operating system is running on a computer by merely taking a look at it. No need to use PowerShell or CMD scripts, Lansweeper scans the information without the need of an agent and provides you the overview.

Operating system overview

Operating System Overview Query

Select Top 1000000 tsysOS.Image As icon,
  tblAssets.AssetID,
  tblAssets.AssetName,
  tsysOS.OSname As OS,
  tblOperatingsystem.Caption,
  tblAssets.SP As SP,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Inner Join tblOperatingsystem On
    tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblAssetCustom.State = 1
Order By OS,
  tblAssets.AssetName,
  tblOperatingsystem.Caption

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting