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
