Find all PCs with less that 10% free Hard Drive.

This query will can be use to proactively find all workstation that have less than 10% free space.

 

SELECT          v_GS_LOGICAL_DISK.SystemName0 as ‘PC Name’,

            v_GS_LOGICAL_DISK.DeviceID0 ‘Drive Letter’,

            v_GS_LOGICAL_DISK.FreeSpace0 as ‘Free Space’,

            v_GS_LOGICAL_DISK.Size0 as ‘Size’

FROM v_GS_LOGICAL_DISK v_GS_LOGICAL_DISK

WHERE           (v_GS_LOGICAL_DISK.DriveType0=3)

            and Cast(v_GS_LOGICAL_DISK.FreeSpace0 as Float) /v_GS_LOGICAL_DISK.Size0 < 0.1

Order By v_GS_LOGICAL_DISK.SystemName0, v_GS_LOGICAL_DISK.DeviceID0

Leave a Reply

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