Windows: Harddrive S.M.A.R.T. Status not OK (Built-in)

[Daniel_B]

Old name: Asset: Harddrive S.M.A.R.T. Status not OK (Built-in)

The report below gives back a list of physical disk drives of active assets where the S.M.A.R.T. status is not OK.

The report will only list assets that meet all of the following criteria:

• The asset is a Windows computer
  
• The computer's state is set to 'Active'
  
• The computer's hard drive status is null or not 'ok'
  
• The computer has been successfully scanned at least once

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tsysOS.OSname As OS,
  tblAssets.SP,
  tblAssets.Lastseen,
  tblAssets.Lasttried,
  tblFloppy.Manufacturer As HDManufacturer,
  tblFloppy.Model As HDModel,
  Cast(tblFloppy.Size / 1024 / 1024 / 1024 As int) As SizeGB,
  tblFloppy.FirmwareRevision,
  tblFloppy.Status
From tblFloppy
  Inner Join tblAssets On tblFloppy.AssetID = tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets.LocationID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblFloppy.Status Is Not Null And tblFloppy.Status <> 'OK' And
  tblState.Statename = 'Active'
Order By tblAssets.Domain,
  tblAssets.AssetName