Added value for Mgmt.: Avg. Windows computer scores per domain

[Nick_H]

Ever wondered how the PC's in your company stacks up domain against domain? A report using the Windows Experience Index is one way to find out.

The Windows Experience Index is a measurement that tells you how well your PC works with Windows and uses a base score to rate the experience you can expect. A higher base score usually means that your PC will be faster and more responsive than a PC with a lower base score.
This feature rates the performance of key hardware components such as the CPU, disk drive, and graphics card. The PC is then given a score between 1.0 and 7.9.Lists

The report below will show the average scores per domain:

Select Top 1000000 tblAssets.Domain,
  Convert(Decimal(5,2),Avg(tblWinSAT.WinSPRLevel)) As [Base score],
  Convert(Decimal(5,2),Avg(tblWinSAT.CPUScore)) As Processor,
  Convert(Decimal(5,2),Avg(tblWinSAT.MemoryScore)) As [Memory (RAM)],
  Convert(Decimal(5,2),Avg(tblWinSAT.GraphicsScore)) As Graphics,
  Convert(Decimal(5,2),Avg(tblWinSAT.D3DScore)) As [Gaming graphics],
  Convert(Decimal(5,2),Avg(tblWinSAT.DiskScore)) As [Primary hard disk]
From tblAssets
  Inner Join tblWinSAT On tblAssets.AssetID = tblWinSAT.AssetId
Group By tblAssets.Domain