Percentage of free space on server hard drives

[eclark82]

I am trying to generate a report to Get all servers with less than 10% free space.
The built in report does less than 1 Gb free.

On some of our servers have small drives for logging and would rather have a report with percentage free.

[Nick_VDB · Accepted solution]

We added an example report below that will give back all the servers that have hard disks with less than 10% space left

Instructions for adding this report to your Lansweeper installation can be found here. If you are interested in building or modifying reports, we do recommend:

• Reviewing some SQL tutorials, as the Lansweeper report builder is a standard SQL editor. If you know SQL, you know how to build Lansweeper reports as well. This seems like a good tutorial.
  
• Making use of our database dictionary, which explains in great detail what each database table and field stores. More information on the dictionary can be found here.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetUnique As [Unique],
  tsysOS.OSname,
  tblAssets.Description,
  tblDiskdrives.Caption,
  Round(Cast(tblDiskdrives.Freespace / tblDiskdrives.Size As Float) * 100,
  2) As [% Free],
  Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric) As
  [total size],
  tblDiskdrives.Lastchanged As [last changed],
  tsysOS.Image As icon
From tblAssets
  Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID
  Inner Join tblOperatingsystem
    On tblAssets.AssetID = tblOperatingsystem.AssetID
  Inner Join tblComputersystem On tblAssets.AssetID = tblComputersystem.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where Round(Cast(tblDiskdrives.Freespace / tblDiskdrives.Size As Float) * 100,
  2) <= 10 And Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 As numeric)
  <> 0 And tblComputersystem.Domainrole > 1 And tblDiskdrives.DriveType = 3 And
  tblAssetCustom.State = 1