Under Review

Show the % free disk space - DATA LAKE

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

Its possible????

Thanks

  • 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;