SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_adt_sms_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 = 12 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  WHERE es.external_sys_name = 'SMS'  

GO
GRANT SELECT ON  [dbo].[arg_adt_sms_ext_sys_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_adt_sms_ext_sys_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_adt_sms_ext_sys_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_adt_sms_ext_sys_view] TO [uapmreporting_group]
GO