SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW dbo.arg_web_asset_view  AS  SELECT oa.resource_tag AS alt_asset_id,   oa.resource_alias AS alias,   os.name AS operating_system,   oa.host_name,   oa.resource_name,   oa.mac_address,   oa.alternate_host_name,   oa.previous_resource_tag,   CASE WHEN LTRIM(oa.mac_address) is null OR DATALENGTH(LTRIM(oa.mac_address)) = 0 THEN oa.host_name ELSE oa.mac_address + ' ' + oa.host_name END AS mac_host  FROM ca_owned_resource oa  INNER JOIN ca_resource_family rf ON rf.id = oa.resource_family   LEFT OUTER JOIN ca_resource_operating_system os ON os.id = oa.operating_system  WHERE  rf.include_reconciliation = 1  

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