CREATE VIEW [dbo].[View_GSE_CI_DETAILS]
AS
SELECT
    CI.own_resource_uuid AS CIid,
    CI.resource_name AS CIName,
    CIFamily.name AS CIFamilyName,
    CIClass.name AS CIClassName,
    CILocation.location_name AS CILocName,
    CIRespOrg.org_name AS CIRespOrgName,
    CITenant.name AS CITenant,
    CI.is_ci AS CIISCI,
   CI.installation_date,
   CI.creation_date,
   CI.last_update_date,
   CI.inactive
FROM dbo.ca_owned_resource AS CI
    LEFT OUTER JOIN dbo.ca_resource_family AS CIFamily ON CIFamily.id = CI.resource_family
    LEFT OUTER JOIN dbo.ca_resource_class AS CIClass ON CIClass.id = CI.resource_class
    LEFT OUTER JOIN dbo.ca_location AS CILocation ON CILocation.location_uuid = CI.location_uuid
    LEFT OUTER JOIN dbo.ca_organization AS CIRespOrg ON CIRespOrg.organization_uuid = CI.responsible_org_uuid
    LEFT OUTER JOIN dbo.ca_tenant AS CITenant ON CITenant.id = CI.tenant

GO
GRANT SELECT ON  [dbo].[View_GSE_CI_DETAILS] TO [service_desk_admin_group]
GRANT SELECT ON  [dbo].[View_GSE_CI_DETAILS] TO [service_desk_ro_group]
GO