Hard Drive S.M.A.R.T. Status

Get an Overview of S.M.A.R.T. Statuses in Your Network

S.M.A.R.T. or Self-Monitoring, Analysis and Reporting Technology, is a feature in all modern hard drives and SSDs (solid-state drives) designed to detect issues before a critical hardware failure. Drive failures are not only inconvenient, but it can also result in data loss and extended downtime of the device they were installed in. You can check the hard drive S.M.A.R.T. status with out report.

Hard Drive S.M.A.R.T. Status Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypeIcon16 As icon,
  tblFloppy.Manufacturer As [HD Manufacturer],
  tblFloppy.Model As [HD Model],
  tblFloppy.Size,
  tblFloppy.FirmwareRevision,
  tblFloppy.Status,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  tsysIPLocations.IPLocation,
  tsysOS.OSname As OS,
  tblAssets.SP As SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblFloppy
  Inner Join tblAssets On tblFloppy.AssetID = tblAssets.AssetID
  Inner Join tsysAssetTypes On tblAssets.Assettype = tsysAssetTypes.AssetType
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
  Left Join tsysIPLocations On tblAssets.LocationID = tsysIPLocations.LocationID
Where tblFloppy.Status Is Not Null And tblFloppy.Status = 'OK' And
  tblAssetCustom.State = 1
Order By tblAssets.AssetName