ConfigMgr Report to show available Hard Drive space on machines with its client version

select

v_R_System.Name0, client_version0,v_GS_LOGICAL_DISK.Name0 as Drive,

v_GS_LOGICAL_DISK.Size0 as Size,

v_GS_LOGICAL_DISk.FreeSpace0 as FreeSpace, size0 as Used

from

v_R_System inner join v_GS_LOGICAL_DISK on v_R_System

.ResourceID = v_GS_LOGICAL_DISK.ResourceID inner join v_FullCollectionMembership on v_FullCollectionMembership.ResourceID=v_R_System

.ResourceID

where

v_GS_LOGICAL_DISK.DriveType0 = 3 and v_FullCollectionMembership.CollectionID = @CollectionID

order

by FreeSpace

Create a prompt Query with a variable “CollectionID”

select CollectionID,Name from v_Collection