memory_devices

Physical memory device (type 17) information retrieved from SMBIOS.

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

  • Linux

  • Mac OSX

Table schema

Name

Type

Description

handle

TEXT

Handle, or instance number, associated with the structure in SMBIOS

array_handle

TEXT

The memory array that the device is attached to

form_factor

TEXT

Implementation form factor for this memory device

total_width

INTEGER

Total width, in bits, of this memory device, including any check or error-correction bits

data_width

INTEGER

Data width, in bits, of this memory device

size

INTEGER

Size of memory device in Megabyte

set

INTEGER

Identifies if memory device is one of a set of devices. A value of 0 indicates no set affiliation.

device_locator

TEXT

String number of the string that identifies the physically-labeled socket or board position where the memory device is located

bank_locator

TEXT

String number of the string that identifies the physically-labeled bank where the memory device is located

memory_type

TEXT

Type of memory used

memory_type_details

TEXT

Additional details for memory device

max_speed

INTEGER

Max speed of memory device in megatransfers per second (MT/s)

configured_clock_speed

INTEGER

Configured speed of memory device in megatransfers per second (MT/s)

manufacturer

TEXT

Manufacturer ID string

serial_number

TEXT

Serial number of memory device

asset_tag

TEXT

Manufacturer specific asset tag of memory device

part_number

TEXT

Manufacturer specific serial number of memory device

min_voltage

INTEGER

Minimum operating voltage of device in millivolts

max_voltage

INTEGER

Maximum operating voltage of device in millivolts

configured_voltage

INTEGER

Configured operating voltage of device in millivolts

Query examples

Select all the results for the given table.

SELECT * FROM memory_devices;