SCCM DETAILS DISK

 /********** DETAILS DISK *****************/
 SELECT GD.InterfaceType0,GD.Name0,(GD.Size0),gd.Partitions0,GD.ResourceID
 FROM [dbo].[v_GS_DISK] GD
 WHERE GD.ResourceID=@ResourceID

  /********** DETAILS DISK *****************/
 SELECT Ld.Description0,ld.DeviceID0,Ld.FileSystem0,LD.FreeSpace0,LD.Size0,LD.VolumeName0
 FROM [dbo].[v_GS_LOGICAL_DISK] LD
 WHERE LD.ResourceID=@ResourceID