smart_drive_info

Drive information read by SMART controller utilizing autodetect.

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: smart_drive_info

  • Linux
  • Mac OSX

Table schema

Name Type Description
device_name TEXT Name of block device
disk_id INTEGER Physical slot number of device, only exists when hardware storage controller exists
driver_type TEXT The explicit device type used to retrieve the SMART information
model_family TEXT Drive model family
device_model TEXT Device Model
serial_number TEXT Device serial number
lu_wwn_device_id TEXT Device Identifier
additional_product_id TEXT An additional drive identifier if any
firmware_version TEXT Drive firmware version
user_capacity TEXT Bytes of drive capacity
sector_sizes TEXT Bytes of drive sector sizes
rotation_rate TEXT Drive RPM
form_factor TEXT Form factor if reported
in_smartctl_db INTEGER Boolean value for if drive is recognized
ata_version TEXT ATA version of drive
transport_type TEXT Drive transport type
sata_version TEXT SATA version, if any
read_device_identity_failure TEXT Error string for device id read, if any
smart_supported TEXT SMART support status
smart_enabled TEXT SMART enabled status
packet_device_type TEXT Packet device type
power_mode TEXT Device power mode
warnings TEXT Warning messages from SMART controller

Query examples

Select all the results for the given table.

SELECT * FROM smart_drive_info;