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