asset_policy_list

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

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,
    host.query_uri
FROM surveilr_osquery_ms_node_boundary host
INNER JOIN surveilr_osquery_ms_node_executed_policy pol ON pol.host_identifier=host.host_identifier
;