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
