SET QUOTED_IDENTIFIER OFF
GO

CREATE VIEW dbo.arg_web_deleted_discovery_view
AS
SELECT        rd.task_uuid AS task_id,
        rd.reconcile_data_id,
        oa.serial_number AS owned_serial_number,
        oa.resource_alias AS alias,
        oa.resource_name AS item_name,
        oa.host_name,
            rm.discovery_asset_serial_num,
            rm.discovery_asset_name,
            rm.discovery_asset_sys_vendor,
            rm.discovery_asset_sys_model
            
FROM        arg_reconcile_data rd

INNER JOIN      arg_reconcile_modification rm ON rd.dis_hw_uuid = rm.dis_hw_uuid
INNER JOIN    ca_owned_resource oa ON rd.own_resource_uuid = oa.own_resource_uuid

WHERE          (rd.reconcile_data_type = 2)

GO
GRANT SELECT ON  [dbo].[arg_web_deleted_discovery_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[arg_web_deleted_discovery_view] TO [uapmadmin]
GRANT SELECT ON  [dbo].[arg_web_deleted_discovery_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[arg_web_deleted_discovery_view] TO [uapmbatch]
GRANT SELECT ON  [dbo].[arg_web_deleted_discovery_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[arg_web_deleted_discovery_view] TO [uapmreporting]
GRANT SELECT ON  [dbo].[arg_web_deleted_discovery_view] TO [uapmreporting_group]
GO