SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_web_field_changes_view  AS  SELECT  rd.task_uuid AS task_id,     rd.reconcile_data_id,     rd.discovery_asset_name,     rd.discovery_operating_sys,    CAST (rd.discovery_capacity AS VARCHAR(10)) + ' ' + u1.name AS discovery_capacity,    oa.serial_number AS owned_serial_number,    oa.host_name AS alias,    CAST (oa.resource_capacity AS VARCHAR(10)) + ' ' + u2.name AS owned_capacity,           ro.name AS owned_operating_sys,           oa.resource_name AS item_name,           oa.host_name,           rd.discovery_last_run_date,           rd.discovery_processor_count,           CAST (rd.discovery_processor_speed AS VARCHAR(10)) + ' ' + u3.name AS discovery_processor_speed,           rd.discovery_processor_type,           CAST (rd.discovery_total_disk_space AS VARCHAR(10)) + ' ' + u4.name AS discovery_total_disk_space,           CAST (rd.discovery_total_memory AS VARCHAR(10)) + ' ' + u5.name AS discovery_total_memory,           oa.discovery_last_run_date AS owned_last_run_date,           oa.processor_count AS owned_processor_count,           CAST (oa.processor_speed AS VARCHAR(10)) + ' ' + u6.name AS owned_processor_speed,           oa.processor_type AS owned_processor_type,           CAST (oa.total_disk_space AS VARCHAR(10)) + ' ' + u7.name AS owned_total_disk_space,           CAST (oa.total_memory AS VARCHAR(10)) + ' ' + u8.name AS owned_total_memory    FROM     arg_reconcile_data rd    INNER JOIN ca_owned_resource oa ON rd.own_resource_uuid = oa.own_resource_uuid  LEFT OUTER JOIN ca_resource_operating_system ro ON oa.operating_system = ro.id  LEFT OUTER JOIN ca_capacity_unit u1 ON rd.discovery_capacity_unit = u1.id  LEFT OUTER JOIN ca_capacity_unit u2 ON oa.resource_capacity_unit = u2.id  LEFT OUTER JOIN ca_capacity_unit u3 ON rd.discovery_processor_speed_unit = u3.id  LEFT OUTER JOIN ca_capacity_unit u4 ON rd.discovery_total_disk_space_unt = u4.id  LEFT OUTER JOIN ca_capacity_unit u5 ON rd.discovery_total_memory_unit = u5.id  LEFT OUTER JOIN ca_capacity_unit u6 ON oa.processor_speed_unit = u6.id  LEFT OUTER JOIN ca_capacity_unit u7 ON oa.total_disk_space_unit = u7.id  LEFT OUTER JOIN ca_capacity_unit u8 ON oa.total_memory_unit = u8.id    WHERE    (rd.reconcile_data_type = 0)  

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