CREATE view  View_Change_to_Assets AS
SELECT View_Change.*, net_res.own_resource_uuid assetID,
       net_res.serial_number asset_serial_num, gen_res.name asset_class,
       resfam.name asset_family, net_res.resource_name asset_name
FROM ((((  View_Change
   inner join  lrel ON View_Change.persid = lrel.l_persid)
   inner join  ca_owned_resource net_res ON lrel.r_persid = 'nr:'+dbo.hex(net_res.own_resource_uuid))
   left join  ca_resource_class gen_res ON net_res.resource_class = gen_res.id)
   left join  ca_resource_family resfam ON gen_res.family_id = resfam.id)
WHERE (lrel.l_attr = 'asset') AND (lrel.r_attr = 'chgnr')
GO
GRANT SELECT ON  [dbo].[View_Change_to_Assets] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Change_to_Assets] TO [service_desk_ro_group]
GO