asset_user_list

Column	Type
host_identifier	BLOB
host	BLOB
host_identifier:1	BLOB
user_name	BLOB
directory	BLOB
uid	BLOB

SQL DDL

CREATE VIEW asset_user_list AS
SELECT 
    host.host_identifier,
    host.host_identifier as host,
    ss.host_identifier,
    ss.user_name,
    ss.directory,
    ss.uid
FROM surveilr_osquery_ms_node_boundary host
INNER JOIN ur_transform_list_user ss ON ss.host_identifier=host.host_identifier