Jetzt Ausprobieren

Windows Server Overview

Hardware Hardware Components Operating System

Find All Windows Servers and Their Details

Discover all your Windows servers and their details and get an overview of which servers are within your IT environment. List all Windows servers along with their OS version, model, domain role, CPU and number of cores and IP Location by using the report below.
Windows Server Overview

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],
tblDomainroles.Domainrolename as [Domain Role],
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
inner join tblDomainroles on tblDomainroles.Domainrole = tblComputersystem.Domainrole 
where tblComputersystem.Domainrole > 1
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,
tblDomainroles.Domainrolename
Order By tblAssets.AssetName

Show

Hide