Attention

Zercurity has been acquired by JumpCloud.

This documentation will no longer be maintained or updated. You can read more about the acquisition, or signup to JumpCloud today.

https://jumpcloud.com/press/jumpcloud-acquires-zercurity

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;