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. .. code-block:: sql SELECT * FROM memory_devices;