Collection creation

Question

Hi Team , How to create a list of all workstations that are failing windows upgrade due to space issue. Please suggest me.

solved 0
BalaVamsi Chowdary 5 months 2 Answers 99 views Beginner 0

Answers ( 2 )

  1. The following might help

    This is sql query to find out free disk space but remember you need to make sure that you enable the inventory to collect the details from client

    This query will help you to find devices with less than 15 gb free disk space for windows 10 upgrade

    SELECT distinct
    SYS.Name,
    LDISK.Description0,
    LDISK.DeviceID0,
    LDISK.VolumeName0,
    LDISK.FileSystem0,
    LDISK.Size0,
    LDISK.FreeSpace0,
    sys.SiteCode
    FROM
    v_FullCollectionMembership_Valid SYS
    join v_GS_LOGICAL_DISK LDISK on SYS.ResourceID = LDISK.ResourceID
    WHERE LDISK.DriveType0 = 3 AND ((LDISK.FreeSpace0 <= ((LDisk.Size0 * 10)/100)) or (LDISK.FreeSpace0 <= 15360)) and sys.CollectionID = ‘SMS00001’

    Best answer

Leave an answer

Sorry, you do not have a permission to answer to this question .