create view usm_vw_ca_owned_resource as
select
    sys.fn_varbintohexsubstring(1,own_resource_uuid,1,0) as own_resource_uuid,
    inactive,
    asset_type_id,
    resource_name,
    resource_description,
    resource_family,
    resource_class,
    resource_status,
    manufacturer_uuid,
    responsible_vendor_uuid,
    maintenance_org_uuid,
    responsible_org_uuid,
    org_bought_for_uuid,
    resource_contact_uuid,
    resource_owner_uuid,
    location_uuid,
    floor_location,
    room_location,
    cabinet_location,
    shelf_location,
    slot_location,
    model_uuid,
    host_name,
    mac_address,
    ip_address,
    resource_tag,
    operating_system,
    product_version,
    serial_number,
    acquire_date,
    installation_date,
    cost_center,
    gl_code,
    resource_quantity,
    requisition_id,
    purchase_order_id,
    ufam,
    creation_user,
    creation_date,
    last_update_user,
    last_update_date,
    version_number,
    supply_vendor_uuid,
    maintenance_vendor_uuid,
    company_bought_for_uuid,
    resource_capacity_unit,
    resource_capacity,
    resource_alias,
    asset_source_uuid,
    license_uuid,
    exclude_registration,
    delete_time,
    department,
    status_date,
    license_information,
    resource_subclass,
    audit_date,
    exclude_reconciliation,
    dns_name,
    alternate_host_name,
    discovery_last_run_date,
    previous_resource_tag,
    processor_count,
    processor_speed,
    processor_speed_unit,
    processor_type,
    reconciliation_date,
    total_disk_space,
    total_disk_space_unit,
    total_memory,
    total_memory_unit,
    billing_contact_uuid,
    support_contact1_uuid,
    support_contact2_uuid,
    support_contact3_uuid
    disaster_recovery_contact_uuid,
    backup_services_contact_uuid,
    network_contact_uuid,
    tenant,
    license_id,
    resource_deployment_status,
    is_asset,
    is_ci
from ca_owned_resource
GO
GRANT SELECT ON  [dbo].[usm_vw_ca_owned_resource] TO [usmgroup]
GO