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