Hi Team , How to create a list of all workstations that are failing windows upgrade due to space issue. Please suggest me.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Answers ( 2 )
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
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’