
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-01-2015 06:33 PM
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
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
Solved! Go to Solution.
Labels:
- Labels:
-
Report Center
1 ACCEPTED SOLUTION

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2015 01:28 PM
Table tblFloppy is correct, it lists physical disk drives. You need to consider that Lansweeper does not rescan all details on each scan. Under Configuration\Item Wait Time, you need to reduce the scanning interval for FLOPPY. Alternatively open the asset page of a computer you are interested in and hit Rescan asset. This will trigger a full rescan of this single machine.
2 REPLIES 2

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2015 06:07 PM
A long time ago I set the rescan for Hard Disk to 1 day thinking this was were it was stored. I have now adjusted floppy to 1 day. Thanks for your support, this is the 1st time in 4+ years of using your product I have needed assistance.

Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎07-02-2015 01:28 PM
Table tblFloppy is correct, it lists physical disk drives. You need to consider that Lansweeper does not rescan all details on each scan. Under Configuration\Item Wait Time, you need to reduce the scanning interval for FLOPPY. Alternatively open the asset page of a computer you are interested in and hit Rescan asset. This will trigger a full rescan of this single machine.
