Jetzt Ausprobieren

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

Hardware Components

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. Asset Hard drive S.M.A.R.T. status audit

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

Show

Hide