Windows Server Overview

Find All Windows Servers and Their Details

List all Windows server along with their OS version, model, CPU and number of cores and IP Location. This report provides a convenient overview of your Windows servers and their most vital information.

This report can only be run on a SQL Server Installation.
Windows Server Overview
Click to Open - Windows Server Overview Query
Select Top (1000000) tblAssets.AssetName As [Name],
  tblAssets.AssetID,
  tsysOS.Image As icon,
  RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
  Coalesce(tblOperatingsystem.OtherTypeDescription, ''))) As [OS Version],
  tblAssetCustom.Model As [Model/Platform],
  tblAssets.Processor As [Model CPU],
  tblAssets.NrProcessors,
  Sum(tblProcessor.NumberOfCores) As [CPU Cores],
  dbo.tsysIPLocations.IPLocation
From tblComputersystem
  Inner Join tblAssets On tblComputersystem.AssetID = tblAssets.AssetID
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
  Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
    tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Group By tblAssets.AssetName,
  tblAssets.AssetID,
  tsysOS.Image,
  RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
  Coalesce(tblOperatingsystem.OtherTypeDescription, ''))),
  tblAssetCustom.Model,
  tblAssets.Processor,
  tblAssets.NrProcessors,
  tblAssets.AssetUnique,
  tsysIPLocations.IPLocation
Having RTrim(LTrim(Coalesce(tblOperatingsystem.Caption, '') + ' ' +
  Coalesce(tblOperatingsystem.OtherTypeDescription, ''))) Like '%Server%'
Order By tblAssets.AssetName

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