Tables

Fleet uses osquery tables to query operating system, hardware, and software data. Each table provides specific data for analysis and filtering.

Apple

Linux

Windows

ChromeOS

memory_devices

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

Column	Type	Description
array_handle	text	The memory array that the device is attached to
asset_tag	text	Manufacturer specific asset tag of memory device
bank_locator	text	String number of the string that identifies the physically-labeled bank where the memory device is located
configured_clock_speed	integer	Configured speed of memory device in megatransfers per second (MT/s)
configured_voltage	integer	Configured operating voltage of device in millivolts
data_width	integer	Data width, in bits, of this memory device
device_locator	text	String number of the string that identifies the physically-labeled socket or board position where the memory device is located
form_factor	text	Implementation form factor for this memory device
handle	text	Handle, or instance number, associated with the structure in SMBIOS
manufacturer	text	Manufacturer ID string
max_speed	integer	Max speed of memory device in megatransfers per second (MT/s)
max_voltage	integer	Maximum operating voltage of device in millivolts
memory_type	text	Type of memory used
memory_type_details	text	Additional details for memory device
min_voltage	integer	Minimum operating voltage of device in millivolts
part_number	text	Manufacturer specific serial number of memory device
serial_number	text	Serial number of memory device
set	integer	Identifies if memory device is one of a set of devices. A value of 0 indicates no set affiliation.
size	integer	Size of memory device in Megabyte
total_width	integer	Total width, in bits, of this memory device, including any check or error-correction bits