CREATE view  View_Issue_to_Assets AS
SELECT View_Issue.*, 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_Issue
    inner join  lrel ON View_Issue.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 = 'issnr')
GO
GRANT SELECT ON  [dbo].[View_Issue_to_Assets] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_Issue_to_Assets] TO [service_desk_ro_group]
GO