SET QUOTED_IDENTIFIER OFF
GO
CREATE VIEW al_bi_disc_software_view
AS
SELECT     manufacturer, product_name, drcs_content_type_id, release_name, host_name, serial_number, company_uuid, product_uuid, release_uuid,
                      dis_hw_uuid, dis_sw_uuid, sw_def_uuid, asset_source_uuid, license_id, license_instance, license_block_id, covered_by_nf, CONVERT(varchar,
                      dbo.SECS2DATE(creation_date), 101) AS creation_date
FROM         al_discovered_software_view
GO