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

Find S.M.A.R.T. Errors 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 can cause severe data loss and downtime costing the company. Therefore, it is important that you detect possible drive issues before a critical failure takes place. Below, you can run our report to check for hard drive S.M.A.R.T. errors.

The audit below will lists all the hard drives or SSDs within your network if their S.M.A.R.T. status is not ok. You can easily discover which drives are having issues and check them before it is too late. In addition to running the audit, you can also use the audit to set up an alert. The alert will automatically notify you when a drive is reporting issues.

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,
  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