1. PDQ Deploy & Inventory Help Center
  2. Community
  3. PDQ Inventory
 

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.

disk usage report

Avatar
itadmin

Is there a way to create a report of used disk space? 

I see we can do free %, and free disk space GB but i would like used disk space ie.. size GB - free space GB

0

Comments

4 comments
Date Votes
  • Avatar
    Permanently deleted user

    You will have to create a SQL report. The database only stores size and free space, not used space. I'll see if I can build that. I've never used SQL reports before, so this will be fun to build :)

    0
  • Avatar
    Stephen Valdinger

    SQL Reports are the bomb. Get at it :)!

    0
  • Avatar
    Permanently deleted user

    Give this a spin:

    select
     Computers.Name as "Computer Name",
     LogicalDisks.LogicalDeviceId as "Drive Letter",
     ( (LogicalDisks.Size - LogicalDisks.FreeSpace) / 1024 / 1024 / 1024 ) as "Used Space GB"
    from Computers inner join
     LogicalDisks on LogicalDisks.ComputerId = Computers.ComputerId
    where <ComputerFilter>
    1
  • Avatar
    itadmin

    Appears to be working great.

     

    Thanks Colby!

    0