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
