We have had a few recent hard drive failures, but no indication in Lansweeper. Is the current SMART not ok report correct? It looks like it is pulling from the floppy table instead of hard disk? Below is the current built in report on build 5308:
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypeIcon16 As icon,
tblFloppy.Manufacturer,
tblFloppy.Model,
tblFloppy.Size,
tblFloppy.FirmwareRevision,
tblFloppy.Status
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
Where tblFloppy.Status Is Not Null And tblFloppy.Status <> 'OK' And
tblAssetCustom.State = 1
Order By tblAssets.AssetName