Details for logical drives on the system. A logical drive generally represents a single partition.

Table schema

Name Type Description
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.

Query examples

select * from logical_drives
select free_space from logical_drives where device_id = 'C:'