Old name: Asset: Windows Experience Index (Built-in)
The report below gives back a list of information found in the Windows System Assessment Tool (WinSAT). This tool can be found in a Windows computer's Control Panel, under Performance Information & Tools, and measures the computer's processor, memory, 2D graphics, 3D graphics and primary hard disk performance. An overall score, called the Windows Experience Index (WEI) score is then calculated.
The report will only list assets that meet all of the following criteria:
- The assets state is set to 'Active'
- The asset has been successfully scanned at least once
- The asset is a Windows computer
- The computer has WinSAT information
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblWinSAT.WinSPRLevel As Basescore,
tblWinSAT.CPUScore As Processor,
tblWinSAT.MemoryScore As [Memory(RAM)],
tblWinSAT.GraphicsScore As Graphics,
tblWinSAT.D3DScore As GamingGraphics,
tblWinSAT.DiskScore As PrimaryHD
From tblAssets
Inner Join tblWinSAT On tblAssets.AssetID = tblWinSAT.AssetId
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName
