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

disk usage report

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
  • 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
  • SQL Reports are the bomb. Get at it :)!

    0
  • 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
  • Appears to be working great.

     

    Thanks Colby!

    0

Please sign in to leave a comment.

Didn't find what you were looking for?

New post