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