This discussion has been locked. The information referenced herein may be inaccurate due to age, software updates, or external references.
You can no longer post new replies to this discussion. If you have a similar question you can start a new discussion in this forum.

Simple Disk Usage Report (v1.01)

This is a simple report that displays GBs used, capacity and % usage for all logical drives because the built-ins weren't quite right. Requires that the volumes be licensed but doesn't use any SAM licenses.

Screenshot:

DiskUsage.JPG

Datasource is this custom SQL query (updated to fix a potential divide by zero error for 0 capacity volumes):

SELECT n.Caption, d.DeviceID, d.VolumeName, CAST(ROUND(d.FreeSpaceB * 0.000000001, 2) AS DECIMAL(10,2)) AS 'FreeSpace', CAST(ROUND(d.CapacityB * 0.000000001, 2) AS DECIMAL(10,2)) AS 'Capacity', CAST(COALESCE(ROUND(((d.CapacityB - d.FreeSpaceB) * 0.000000001) / (NULLIF(d.CapacityB, 0) * 0.000000001) * 100, 0), 0) AS INT) AS 'PercentInUse'
FROM AssetInventory_LogicalDrive d

     INNER JOIN Nodes n ON d.NodeID= n.NodeID
ORDER BY PercentInUse DESC, FreeSpace DESC