none
Disk Size, Free Space for a collection? RRS feed

  • Question

  • Hello,

    Does a can report, query, or console view, show the disk size and free disk space for a collection?

    I have a custom report just needed to format it...

    select 
    v_R_SYSTEM.Name0, 
    v_GS_LOGICAL_DISK.Caption0,
    v_GS_LOGICAL_DISK.Size0,
    v_GS_LOGICAL_DISK.FreeSpace0
    from v_R_System 
    inner join v_GS_LOGICAL_DISK on v_GS_LOGICAL_DISK.ResourceID = v_R_System.ResourceId
    join v_FullCollectionMembership on v_FullCollectionMembership.ResourceID = v_R_System.ResourceID
    --where SMS_G_System_LOGICAL_DISK.DeviceID = "C:" and SMS_G_System_LOGICAL_DISK.FreeSpace <= 1000
    where v_FullCollectionMembership.CollectionID = 'UCP002A7'
    and v_GS_LOGICAL_DISK.Caption0 = 'F:'

    Thanks,

    Dom


    Security / System Center Configuration Manager Current Branch / SQL


    • Edited by Felyjos Friday, February 14, 2020 3:17 PM
    Friday, February 14, 2020 3:03 PM

All replies