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;