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.



            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’



Leave a Reply

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