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

1 comments:

ammar hasayen said...

check this out https://gallery.technet.microsoft.com/Configuration-Manager-Most-071cfd38

Post a Comment