How Much Disk Space is Left in Your Entire Network?

Total-Hard-Disk-Free-Space

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

Receive the Latest Network Reports for FREE

Count Me In!

Dig Deeper

Now that you know this appealing network statistic, it's time to dig a little deeper. Using the built-in disk space reports, you can proactively manage your servers and workstations which are about to run out of disk space. Below, you can find some of our built-in disk reports. You can easily edit these reports according to your specific network needs or browse through the report center on our forum for additional reports.

If you haven't already, download a free trial of Lansweeper to run the report and check how many terabytes of free disk space you have available across your network.

Try Lansweeper for Free

Learn why Lansweeper is used by thousands of enterprises worldwide.​