[dbo].[uapm_v_inv_dis_sw]
create view uapm_v_inv_dis_sw as
select d.label host_name,
d.tenant_id tenant_id,
d.dis_hw_uuid host_uuid,
s.sw_def_uuid,
s.dis_sw_uuid,
s.label,
s.serial_number,
s.creation_user,
s.creation_date,
s.last_update_user,
s.product_guid,
s.version_number,
s.last_update_date,
s.install_path,
s.last_accessed,
s.asset_source_uuid,
s.license_uuid,
s.auto_rep_version,
s.exclude_registration,
s.delete_time,
s.is_managed_by_service,
s.is_ignored_by_vuln_impact,
s.trustlevel,
s.origin,
s.def_source_type_id,
s.dis_source_type_id
from ca_discovered_software s, ca_discovered_hardware d
where d.dis_hw_uuid=s.asset_source_uuid
GO
GRANT SELECT ON [dbo].[uapm_v_inv_dis_sw] TO [ca_itrm_group]
GRANT SELECT ON [dbo].[uapm_v_inv_dis_sw] TO [ca_itrm_group_ams]
GO
