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
