‎10-17-2013 02:14 PM
‎10-17-2013 03:30 PM
‎10-17-2013 02:58 PM
clabbadia wrote:
Under PERFOMANCE INFORMATION, to the right of the COMPONENT label WAT is rated should be spelled What is rated.
clabbadia wrote:
Is there a report that can be produced to show each assets Base Score? Possibly to include the Component Scores as well.
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now