box.osquery

[ 1 Introduction ] [ 2 Valid tags and data tables ] [ 3 Table structure ]

Introduction

The tags beginning with box.osquery identify events generated by UNIX osquery.

Valid tags and data tables

The full tag must have 4 levels. The first two are fixed as box.osquery. The third level identifies the type of events sent. The fourth level indicates the event subtype.

These are the valid tags and corresponding data tables that will receive the parsers' data:

Product / Service	Tags	Data tables

Product / Service	Tags	Data tables
UNIX osquery	`box.osquery.unix.info`	`box.osquery.unix.info`
UNIX osquery	`box.osquery.unix.results`	`box.osquery.unix.results`

For more information, read more About Devo tags.

Table structure

These are the fields displayed in these tables:

box.osquery.unix.info
box.osquery.unix.results

box.osquery.unix.info

Field	Type	Extra fields

Field	Type	Extra fields
eventdate	`timestamp`
env	`str`
hash	`str`
logdate	`str`
sourcehost	`str`
osqueryd	`str`
severity	`str`
location	`str`
message	`str`
msg	`str`
hostchain	`str`	✓
tag	`str`	✓
rawMessage	`str`	✓

box.osquery.unix.results

Field	Type	Extra fields

Field	Type	Extra fields
eventdate	`timestamp`
env	`str`
hash	`str`
logdate	`str`
sourcehost	`str`
osqueryd	`str`
name	`str`
hostIdentifier	`str`
calendarTime	`str`
unixTime	`int8`
epoch	`int8`
counter	`int4`
numerics	`bool`
decorations_host_uuid	`str`
decorations_username	`str`
columns_cmdline	`str`
columns_name	`str`
columns_path	`str`
columns_pid	`str`
action	`str`
msg	`str`
hostchain	`str`	✓
tag	`str`	✓
rawMessage	`str`	✓