boundary_asset_count_list

Column Type
boundary_name BLOB
host_count

SQL DDL

CREATE VIEW boundary_asset_count_list AS
SELECT 
    boundary.boundary AS boundary_name,
    COUNT(DISTINCT boundary.host_identifier) AS host_count
FROM surveilr_osquery_ms_node_boundary boundary
LEFT JOIN surveilr_osquery_ms_node_detail nodeDet 
    ON nodeDet.host_identifier = boundary.host_identifier
GROUP BY boundary.boundary
ORDER BY host_count DESC
;