cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
clabbadia
Engaged Sweeper II
Under PERFOMANCE INFORMATION, to the right of the COMPONENT label WAT is rated should be spelled What is rated.

Is there a report that can be produced to show each assets Base Score? Possibly to include the Component Scores as well.
11 REPLIES 11
clabbadia
Engaged Sweeper II
Report is spot on .. thanks!
Hemoco
Lansweeper Alumni
clabbadia wrote:
Under PERFOMANCE INFORMATION, to the right of the COMPONENT label WAT is rated should be spelled What is rated.

We'll fix this typo in our next update.

clabbadia wrote:
Is there a report that can be produced to show each assets Base Score? Possibly to include the Component Scores as well.

Sample report:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblWinSAT.CPUScore,
tblWinSAT.D3DScore,
tblWinSAT.DiskScore,
tblWinSAT.GraphicsScore,
tblWinSAT.MemoryScore,
tblWinSAT.WinSPRLevel,
tblWinSAT.LastChanged,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblWinSAT On tblAssets.AssetID = tblWinSAT.AssetId
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName