SET QUOTED_IDENTIFIER OFF
GO

CREATE VIEW dbo.arg_web_owned_asset_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_tag AS alt_asset_id,
        oa.resource_name AS item_name,
        oa.host_name
FROM             arg_reconcile_data rd
INNER JOIN    ca_owned_resource oa ON rd.own_resource_uuid = oa.own_resource_uuid
                
WHERE         (rd.reconcile_data_type = 3)

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