Windows: Windows Experience Index (Built-in)

[Daniel_B]

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