surveilr_osquery_ms_node_system_info
| Column |
Type |
PK |
Required |
Default |
| node_key |
|
No |
No |
|
| updated_at |
NUM |
No |
No |
|
| host_identifier |
|
No |
No |
|
| board_model |
|
No |
No |
|
| board_serial |
|
No |
No |
|
| board_vendor |
|
No |
No |
|
| board_version |
|
No |
No |
|
| computer_name |
|
No |
No |
|
| cpu_brand |
|
No |
No |
|
| cpu_logical_cores |
|
No |
No |
|
| cpu_microcode |
|
No |
No |
|
| cpu_physical_cores |
|
No |
No |
|
| cpu_sockets |
|
No |
No |
|
| cpu_subtype |
|
No |
No |
|
| cpu_type |
|
No |
No |
|
| hardware_model |
|
No |
No |
|
| hardware_serial |
|
No |
No |
|
| hardware_vendor |
|
No |
No |
|
| hardware_version |
|
No |
No |
|
| hostname |
|
No |
No |
|
| local_hostname |
|
No |
No |
|
| physical_memory |
|
No |
No |
|
| uuid |
|
No |
No |
|
Foreign Keys
Indexes
SQL DDL
CREATE TABLE surveilr_osquery_ms_node_system_info(
node_key,
updated_at NUM,
host_identifier,
board_model,
board_serial,
board_vendor,
board_version,
computer_name,
cpu_brand,
cpu_logical_cores,
cpu_microcode,
cpu_physical_cores,
cpu_sockets,
cpu_subtype,
cpu_type,
hardware_model,
hardware_serial,
hardware_vendor,
hardware_version,
hostname,
local_hostname,
physical_memory,
uuid
)