Hard Drive Stats

In yesterday blog I showed how you can sum the total hard drive space on each PC. Today blog goes along the same vain by  showing the minimum, maximum, average, and total of all hard drive within your SMS database.

 

SELECT

            Min(v_GS_LOGICAL_DISK.Size0) AS ‘Min of HD Size’,

            Max(v_GS_LOGICAL_DISK.Size0) AS ‘Max of HD Size’,

            Avg(v_GS_LOGICAL_DISK.Size0) AS ‘Avg of HD Size’,

            Sum(v_GS_LOGICAL_DISK.Size0) AS ‘Total of all HDs’

FROM

            v_GS_LOGICAL_DISK v_GS_LOGICAL_DISK

Leave a Reply

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