SET QUOTED_IDENTIFIER OFF
GO
create view al_discovered_software_view as
select
    c.company_name as manufacturer,
    s8.name as product_name,
    s8.drcs_content_type_id,
    s3.name as release_name,
    dh.host_name,
    dh.serial_number,
    c.company_uuid,
    s8.sw_def_uuid as product_uuid,
    s3.sw_def_uuid as release_uuid,
    dh.dis_hw_uuid,
    ds.dis_sw_uuid,
    ds.sw_def_uuid,
    ds.asset_source_uuid,
    ds.license_id,
    ds.license_instance,
    ds.license_block_id,
    ds.covered_by_nf,
    ds.creation_date
from
    ca_discovered_software ds
    inner join ca_discovered_hardware dh on dh.dis_hw_uuid = ds.asset_source_uuid
    inner join ca_software_def s3 on s3.sw_def_uuid = ds.sw_def_uuid
    inner join ca_link_sw_def s3s8 on s3s8.secondary_sw_def_uuid = s3.sw_def_uuid and s3s8.link_type_id = 3
    inner join ca_software_def s8 on s8.sw_def_uuid = s3s8.primary_sw_def_uuid
    left outer join ca_company c on c.company_uuid = s8.manufacturer_uuid

GO