Details for logical drives on the system. A logical drive generally represents a single partition.
Please be aware that some queries can only be run against certain platforms. Below is a list of the supported platforms that this query supports. Zercurity will automatically pause queries from running if errors are detected. Running a query against an unsupported platform will result in the following error:
no such table: logical_drives
|device_id||TEXT||The drive id, usually the drive name, e.g., ‘C:’.|
|type||TEXT||The type of disk drive this logical drive represents.|
|free_space||BIGINT||The amount of free space, in bytes, of the drive.|
|size||BIGINT||The total amount of space, in bytes, of the drive.|
|file_system||TEXT||The file system of the drive.|
|boot_partition||INTEGER||True if Windows booted from this drive.|
select * from logical_drives
select free_space from logical_drives where device_id = 'C:'