CREATE VIEW dbo.arg_adt_uam_ext_sys_view
AS
SELECT       es.dis_hw_uuid, es.discovery_id_1, es.external_sys_name, es.loader_processed_date, s2.subschema_id
FROM       ca_discovered_hardware_ext_sys es
LEFT JOIN ca_asset_source s1 ON s1.asset_source_uuid = es.dis_hw_uuid AND s1.subschema_id = 16 AND s1.delete_time is null
LEFT JOIN ca_asset_source s2 ON s2.logical_asset_uuid = s1.logical_asset_uuid AND s2.subschema_id = 1 AND s2.delete_time is null
GO
GRANT SELECT ON  [dbo].[arg_adt_uam_ext_sys_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_adt_uam_ext_sys_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_adt_uam_ext_sys_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_adt_uam_ext_sys_view] TO [uapmreporting_group]
GO