BDNA Data Platform 5.4 July 2017 (SQL Server) MATCH_HOST_SW_PROD_DET - Host-Software detailed information matched
|
View Definition:
CREATE VIEW MATCH_HOST_SW_PROD_DET AS SELECT DISC_SW_PROD_ID ID,HOST_ID,HOSTNAME,CAT_SW_UUID,DISCOVERED_ID,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_EDITION_ID,
CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,CAT_CPE_URI_ID,SUITE_ID,IS_SUITE,
GROUP_ID,DISCOVERED_NAME,DISCOVERED_VERSION,DISCOVERED_PUBLISHER,DISCOVERED_INSTALLDATE,ORIGINATE_FROM,SOURCE_BITMAP,
IS_MAPPED,HIDDEN,HIDDEN_REASON,IS_MAJOR_RELEASE,CAT_SW_MAJOR_RELEASE_ID,CAT_SW_MAJOR_VERSION,IS_LATEST,LATEST_CAT_SW_UUID,
DEDUP_ID,IS_MERGED,TASK_ID,MATCH_HOST_SW_PROD_RN,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_PROD_ALL_237467998 UNION ALL SELECT DISC_SW_PROD_ID ID,HOST_ID,HOSTNAME,CAT_SW_UUID,DISCOVERED_ID,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_EDITION_ID,
CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,CAT_CPE_URI_ID,SUITE_ID,IS_SUITE,
GROUP_ID,DISCOVERED_NAME,DISCOVERED_VERSION,DISCOVERED_PUBLISHER,DISCOVERED_INSTALLDATE,ORIGINATE_FROM,SOURCE_BITMAP,
IS_MAPPED,HIDDEN,HIDDEN_REASON,IS_MAJOR_RELEASE,CAT_SW_MAJOR_RELEASE_ID,CAT_SW_MAJOR_VERSION,IS_LATEST,LATEST_CAT_SW_UUID,
DEDUP_ID,IS_MERGED,TASK_ID,MATCH_HOST_SW_PROD_RN,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_PROD_ALL_237470163 UNION ALL SELECT DISC_SW_PROD_ID ID,HOST_ID,HOSTNAME,CAT_SW_UUID,DISCOVERED_ID,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_EDITION_ID,
CAT_SW_VERSION_GROUP_ID,CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,CAT_TAXONOMY2012_ID,CAT_CPE_URI_ID,SUITE_ID,IS_SUITE,
GROUP_ID,DISCOVERED_NAME,DISCOVERED_VERSION,DISCOVERED_PUBLISHER,DISCOVERED_INSTALLDATE,ORIGINATE_FROM,SOURCE_BITMAP,
IS_MAPPED,HIDDEN,HIDDEN_REASON,IS_MAJOR_RELEASE,CAT_SW_MAJOR_RELEASE_ID,CAT_SW_MAJOR_VERSION,IS_LATEST,LATEST_CAT_SW_UUID,
DEDUP_ID,IS_MERGED,TASK_ID,MATCH_HOST_SW_PROD_RN,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_PROD_ALL_9999
Possibly Referenced Tables/Views: