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 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
