cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sata
Engaged Sweeper

Hello,

I have detected that a customized report is not showing updated data for field tblVolume.FreeSpace.

Disk free space was changed 3 days ago 😕

Scan is performed daily.

If I access the Asset infromation screen, I can see the updated information.

If I run the following report, infomation shown for tblVolume.FreeSpace value, is not valid. 

How is that?

Thanks for your help,

 

 

Select Top (1000000) tblAssets.AssetID,
tblVolume.DriveLetter,
tblVolume.Label As LogicalDiskName,
Case tblVolume.DriveType
When 0 Then 'Unknown'
When 1 Then 'No Root Directory'
When 2 Then 'Removable Disk'
When 3 Then 'Local Disk'
When 4 Then 'Network Drive'
When 5 Then 'Compact Disk'
Else 'RAM Disk'
End As DriveType,
Format(Cast(tblVolume.FreeSpace / 1024 / 1024 / 1024 As numeric) /
Cast(tblVolume.Capacity / 1024 / 1024 / 1024 As numeric), 'P0') As
freePercentage,
Cast(tblVolume.FreeSpace / 1024 / 1024 / 1024 As numeric) As FreeGB,
Cast(tblVolume.Capacity / 1024 / 1024 / 1024 As numeric) As TotalSizeGB,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tsysOS.OSname As OS,
tblAssets.SP
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblVolume On tblAssets.AssetID = tblVolume.AssetID
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblState On tblState.State = tblAssetCustom.State
Where tblVolume.DriveLetter <> '' And Cast(tblVolume.Capacity / 1024 /
1024 / 1024 As numeric) > 0 And tblState.Statename = 'Active'
Order By tblVolume.DriveLetter,
Cast(tblVolume.FreeSpace / 1024 / 1024 / 1024 As numeric) /
Cast(tblVolume.Capacity / 1024 / 1024 / 1024 As numeric),
FreeGB,
TotalSizeGB,
tsysIPLocations.IPLocation,
tblAssets.AssetName

1 ACCEPTED SOLUTION
Mister_Nobody
Honored Sweeper II

You can try change logics as realized in built-in *"free disk space" reports.

View solution in original post

4 REPLIES 4
Mister_Nobody
Honored Sweeper II

What is your scan interval for disks? 

Floppy, harddisk, volume?

Hello,

In /Scanning/Itemwaittime/Scanned Item Interval, the HARDDDISK and VOLUME rows show the same values for the Enable and Refresh columns:

  • Enable: "Scan Server and LsAgent"
  • Refresh: "0"

I have little experience with LanSweeper, but I understand that the hard disk values are scanned properly since Free Space is shown correctly when I inspect the asset screen. The issue is that the report does not reflect the same data.

Thanks for your help,

Mister_Nobody
Honored Sweeper II

You can try change logics as realized in built-in *"free disk space" reports.