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]
GO