SELECT TOP (100) PERCENT dbo.v_R_System.Name0 AS [System Name], dbo.v_GS_LOGICAL_DISK.Name0 AS [C Drive], dbo.v_GS_LOGICAL_DISK.Size0 AS [Total Size],
dbo.v_GS_LOGICAL_DISK.FreeSpace0 AS FreeSpace, dbo.v_GS_LOGICAL_DISK.Size0 AS Used
FROM dbo.v_R_System INNER JOIN
dbo.v_GS_LOGICAL_DISK ON dbo.v_R_System.ResourceID = dbo.v_GS_LOGICAL_DISK.ResourceID INNER JOIN
dbo.v_FullCollectionMembership ON dbo.v_FullCollectionMembership.ResourceID = dbo.v_R_System.ResourceID
WHERE (dbo.v_GS_LOGICAL_DISK.DriveType0 = 3) AND (dbo.v_FullCollectionMembership.CollectionID = ‘sms00001’) AND (dbo.v_GS_LOGICAL_DISK.Name0 = ‘c:’)
ORDER BY FreeSpace

Leave a Reply

Your email address will not be published. Required fields are marked *