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

[Nick_H]

Ever wondered how the PC's in your company stacks up department against department? 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 department:

Select Top 1000000 tblADusers.Department,
  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 tblWinSAT
  Inner Join tblAssets On tblAssets.AssetID = tblWinSAT.AssetId
  Inner Join tblADusers On tblAssets.Username = tblADusers.Username And
    tblADusers.Userdomain = tblAssets.Userdomain
Group By tblADusers.Department
Having tblADusers.Department Is Not Null And
  Len(RTrim(LTrim(tblADusers.Department))) > 0