Help with Disk Drive Inventory

[briancs]

Would like to do reporting for what type of Disk Drive is in each workstation but have not been able to get it to work. I added an asset Group and have it set to detect the model of the drives but it always comes up as nothing found. Tried to create a report and was not successful there either. Any help would be gratefully appreciated .

[MikeMc · Accepted solution]

I wasn't sure if you meant physical or logical drives, but this report will list all non-USB drives detected by Lansweeper.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tblFloppy.Model,
  tblFloppy.Name,
  tblFloppy.InterfaceType,
  Cast(Cast(tblFloppy.Size As DECIMAL) / 1024 / 1024 / 1024 As DECIMAL(18,2)) As
  TotalSizeGB,
  tblFloppy.SerialNumber
From tblAssets
  Inner Join tblAssetCustom On tblAssetCustom.AssetID = tblAssets.AssetID
  Inner Join tblFloppy On tblFloppy.AssetID = tblAssets.AssetID
Where tblFloppy.InterfaceType <> 'USB' And tblAssetCustom.State = 1 And
  tblFloppy.Size <> 0
Order By tblAssets.AssetName,
  tblFloppy.Name