Show the % free disk space - DATA LAKE

Please i need the query for Show the % free disk space on DATA LAKE.

Its possible????

Thanks

Victor Domingo

Karl_Ackerman over 3 years ago

Sorry the data lake does not have disk usage information. The device would have to be online.

The query below is for Live Discover where you have to select the device to run the query on:

SELECT 
   device_id Drive,
   description,
   boot_partition,
   file_system,
   printf("%.2f", (CAST (free_space AS FLOAT)/CAST(size AS FLOAT) ) * 100.0  ) || '%' Percent_Free,
   printf("%.2f", CAST(free_space AS FLOAT)/1024.0/1024.0/1024.0) 'Free_Space(GB)',
   printf("%.2f", CAST(size AS FLOAT)/1024.0/1024.0/1024.0) 'Size(GB)',   
   type
FROM logical_drives;