asset_policy_list

Column	Type
host_identifier	BLOB
host	BLOB
host_identifier:1	BLOB
policy_name	BLOB
policy_result	BLOB
resolution	BLOB

SQL DDL

CREATE VIEW asset_policy_list AS
SELECT 
    host.host_identifier,
    host.host_identifier as host,
    pol.host_identifier,
    pol.policy_name,
    pol.policy_result,
    pol.resolution
FROM surveilr_osquery_ms_node_boundary host
INNER JOIN surveilr_osquery_ms_node_executed_policy pol ON pol.host_identifier=host.host_identifier