logical_drives
==============

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

Platform support
----------------
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``

- Windows

Table schema
------------

==============  =======  =================================================================================
Name            Type     Description                                                                      
==============  =======  =================================================================================
device_id       TEXT     The drive id, usually the drive name, e.g., 'C:'.                                
type            TEXT     Deprecated (always 'Unknown').                                                   
description     TEXT     The canonical description of the drive, e.g. 'Logical Fixed Disk', 'CD-ROM Disk'.
free_space      BIGINT   The amount of free space, in bytes, of the drive (-1 on failure).                
size            BIGINT   The total amount of space, in bytes, of the drive (-1 on failure).               
file_system     TEXT     The file system of the drive.                                                    
boot_partition  INTEGER  True if Windows booted from this drive.                                          
==============  =======  =================================================================================

Query examples
--------------

.. code-block:: sql

   select * from logical_drives


.. code-block:: sql

   select free_space from logical_drives where device_id = 'C:'