Osquery uses basic SQL commands to leverage a relational data-model to describe a device.

osquery

```+------+------------------------------------------------------------------+----------------------+-------------+
| path | sha256                                                           | remote_address       | remote_port |
+------+------------------------------------------------------------------+----------------------+-------------+
|      | 9e1797de8e2e0c3e8b477727f764f08954eae5dfc97def295b2d100[REDACTED]| <http://XXX.XXX.XXX.XXX|XXX.XXX.XXX.XXX>      | 8983        |
+------+------------------------------------------------------------------+----------------------+-------------+```