cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
briancs
Engaged Sweeper
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 .
1 ACCEPTED SOLUTION
MikeMc
Champion Sweeper II
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

View solution in original post

1 REPLY 1
MikeMc
Champion Sweeper II
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