[dbo].[View_Contact_to_Environment]
CREATE view View_Contact_to_Environment AS
SELECT ca_contact.*, net_res.own_resource_uuid asset_uuid,
net_res.resource_name asset_name
FROM (( ca_contact
inner join lrel ON 'cnt:'+dbo.hex(ca_contact.contact_uuid) = lrel.l_persid)
inner join ca_owned_resource net_res ON lrel.r_persid = 'nr:'+dbo.hex(net_res.own_resource_uuid))
WHERE (lrel.l_attr = 'cenv') AND (lrel.r_attr = 'cntref')
GO
GRANT SELECT ON [dbo].[View_Contact_to_Environment] TO [service_desk_admin_group]
GRANT SELECT ON [dbo].[View_Contact_to_Environment] TO [service_desk_ro_group]
GO
