How Much Disk Space is Left in Your Entire Network?

Monitoring the free space on your hard disks is an essential activity as a network administrator. Computer hard drives are getting bigger and bigger, and there’s lots of stuff you can hold on to. To avoid performance issues and the unpleasant message telling you that there is not enough free disk space to save, copy or paste something, one can only acknowledge the importance of monitoring your hard disk’s free space. Did you know? We like an interesting network statistic now and then. Following other posts in our #DiscoverIT series like the longest running device uptime without a reboot or this post about finding that dinosaur device in your network, we now present you a ‘total sum’ report. Don’t you want to know what’s the total amount of free disk space in your network? Just run the report below and in a matter of seconds, you’ll know how many terabytes of free disk space you have.

How To Run This Report

Open the report builder in the Lansweeper web console under Reports/Create New Report.
Paste the SQL query (report) below at the bottom of the page, replacing the default SQL query.
Left-click somewhere in the upper section of the page so the query applies.
Give the report a title.
Hit the Save & Run button to save the report. Export options are listed on the left.

The Report: Select Top 1000000 (Windows.TotalWindows + SSH.TotalLinux) As TotalFreeSpaceTB From (Select Top 1000000 Sum(Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 / 1024 / 1024 / 1024 As numeric)) As TotalWindows From tblAssets Inner Join tblDiskdrives On tblAssets.AssetID = tblDiskdrives.AssetID) As Windows, (Select Top 1000000 Sum(Cast(Cast(tblLinuxHardDisks.Available As bigint) / 1024 / 1024 / 1024 As numeric)) As TotalLinux From tblLinuxHardDisks Inner Join tblAssets On tblAssets.AssetID = tblLinuxHardDisks.AssetID) As SSH