asset_software_list

Column Type
host_identifier BLOB
host BLOB
name BLOB
source BLOB
type BLOB
version BLOB
platform BLOB

SQL DDL

CREATE VIEW asset_software_list AS
SELECT 
    host.host_identifier,
    host.host_identifier as host,
    sw.name,
    sw.source,
    sw.type,
    sw.version,
    sw.platform
FROM surveilr_osquery_ms_node_boundary host
INNER JOIN surveilr_osquery_ms_node_installed_software sw ON sw.host_identifier=host.host_identifier
;