→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Daniel_B
Lansweeper Alumni
Old name: Asset: Harddrive S.M.A.R.T. Status not OK (Built-in)

The report below gives back a list of physical disk drives of active assets where the S.M.A.R.T. status is not OK.

The report will only list assets that meet all of the following criteria:
  • The asset is a Windows computer
  • The computer's state is set to 'Active'
  • The computer's hard drive status is null or not 'ok'
  • The computer has been successfully scanned at least once



Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.Manufacturer,
tblAssetCustom.Model,
tsysOS.OSname As OS,
tblAssets.SP,
tblAssets.Lastseen,
tblAssets.Lasttried,
tblFloppy.Manufacturer As HDManufacturer,
tblFloppy.Model As HDModel,
Cast(tblFloppy.Size / 1024 / 1024 / 1024 As int) As SizeGB,
tblFloppy.FirmwareRevision,
tblFloppy.Status
From tblFloppy
Inner Join tblAssets On tblFloppy.AssetID = tblAssets.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblFloppy.Status Is Not Null And tblFloppy.Status <> 'OK' And
tblState.Statename = 'Active'
Order By tblAssets.Domain,
tblAssets.AssetName
0 REPLIES 0

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now