CREATE VIEW dbo.al_software_discovered_view (
   sw_def_uuid,
   name,
   sw_version_label,
   language,
   sw_version_number,
   replication_flag,
   software_type_id,
   source_type_id,
   description,
   auto_rep_version,
   manufacturer_uuid,
   bit_support_id,
   chip_set_id,
   domain_uuid,
   impact,
   severity,
   is_active,
   no_longer_available,
   family_sw_def_uuid,
   lang_code,
   class_id,
   linear_sequence_number,
   filter_from_view,
   drcs_content_type_id,
   requires_review,
   creation_user,
   creation_date,
   last_update_user,
   last_update_date,
   version_number)
AS
   
   /*
   *   Generated by SQL Server Migration Assistant for Oracle.
   *   Contact ora2sql@microsoft.com or visit http://www.microsoft.com/sql/migration for more information.
   */
   SELECT DISTINCT
      casd2.SW_DEF_UUID AS sw_def_uuid,
      casd2.NAME AS NAME,
      casd2.SW_VERSION_LABEL AS sw_version_label,
      casd2.LANGUAGE AS language,
      casd2.SW_VERSION_NUMBER AS sw_version_number,
      casd2.REPLICATION_FLAG AS replication_flag,
      casd2.SOFTWARE_TYPE_ID AS software_type_id,
      casd2.SOURCE_TYPE_ID AS source_type_id,
      casd2.DESCRIPTION AS description,
      casd2.AUTO_REP_VERSION AS auto_rep_version,
      casd2.MANUFACTURER_UUID AS manufacturer_uuid,
      casd2.BIT_SUPPORT_ID AS bit_support_id,
      casd2.CHIP_SET_ID AS chip_set_id,
      casd2.DOMAIN_UUID AS domain_uuid,
      casd2.IMPACT AS impact,
      casd2.SEVERITY AS severity,
      casd2.IS_ACTIVE AS is_active,
      casd2.NO_LONGER_AVAILABLE AS no_longer_available,
      casd2.FAMILY_SW_DEF_UUID AS family_sw_def_uuid,
      casd2.LANG_CODE AS lang_code,
      casd2.CLASS_ID AS class_id,
      casd2.LINEAR_SEQUENCE_NUMBER AS linear_sequence_number,
      casd2.FILTER_FROM_VIEW AS filter_from_view,
      casd2.DRCS_CONTENT_TYPE_ID AS drcs_content_type_id,
      casd2.REQUIRES_REVIEW AS requires_review,
      casd2.CREATION_USER AS creation_user,
      casd2.CREATION_DATE AS creation_date,
      casd2.LAST_UPDATE_USER AS last_update_user,
      casd2.LAST_UPDATE_DATE AS last_update_date,
      casd2.VERSION_NUMBER AS version_number
   FROM
      dbo.CA_DISCOVERED_SOFTWARE  AS cads
         INNER JOIN dbo.CA_SOFTWARE_DEF  AS casd1
         ON casd1.SW_DEF_UUID = cads.SW_DEF_UUID
         INNER JOIN dbo.CA_LINK_SW_DEF  AS calswd
         ON calswd.SECONDARY_SW_DEF_UUID = casd1.SW_DEF_UUID
         INNER JOIN dbo.CA_SOFTWARE_DEF  AS casd2
         ON casd2.SW_DEF_UUID = calswd.PRIMARY_SW_DEF_UUID AND calswd.LINK_TYPE_ID = 3
GO
GRANT SELECT ON  [dbo].[al_software_discovered_view] TO [swcmadmin]
GRANT SELECT ON  [dbo].[al_software_discovered_view] TO [uapmadmin_group]
GRANT SELECT ON  [dbo].[al_software_discovered_view] TO [uapmbatch_group]
GRANT SELECT ON  [dbo].[al_software_discovered_view] TO [uapmreporting_group]
GO