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