Important Notice: On February 29th, this community was put into read-only mode. All existing posts will remain but customers are unable to add new posts or comment on existing. Please feel to join our Community Discord for any questions and discussions.

Report on Used hard drive space for servers.

Eric King

July 29, 2019 14:02

We're going with a new backup solution, and i need a report for all used hard drive space on my servers. How would i run a report for all used hard drive space for all hard drives on each server? I just need a simple spreadsheet listing the server names, hard drives, and used disk space.

Comments

5 comments

Brad McClave
July 29, 2019 16:36

There is already a pre-built report called Logical Disks in PDQ Inventory. Just run that against the pre-built collection of Servers and you should have the info you are looking for.

0
Eric King
July 29, 2019 16:42

The prebuilt report from logical disks gives the size of the drive and percentage used. I was hoping to get a report of space used on each drive in GB instead of a percentage.

0
Brad McClave
July 30, 2019 12:30

I see your point. I suppose you could modify the report to include disk size and free space, export it to Excel and just have Excel do the math. It's not elegant but it works.

0
Colby Bouma
July 30, 2019 22:47

Does this SQL Report do what you're looking for? https://gist.github.com/Colby-PDQ/2a207f5f2dd34233faff23f637a179c3

0
Eric King
July 31, 2019 18:58

That worked perfectly Colby. Thanks for the help.

0