disk usage report

• 

  Permanently deleted user

  January 25, 2017 17:14

  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
• 

  Stephen Valdinger

  January 25, 2017 17:15

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

  0
• 

  Permanently deleted user

  January 25, 2017 17:28

  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
• 

  IT Dept

  January 25, 2017 19:51

  Appears to be working great.

   

  Thanks Colby!

  0

Please sign in to leave a comment.