BDNA Data Platform 5.4 July 2017 (SQL Server) MATCH_HOST_SW_PROD - Host-Software information matched
|
View Definition:
CREATE VIEW MATCH_HOST_SW_PROD AS SELECT DISC_SW_PROD_ID,HOST_ID,HOSTNAME,DISCOVERED_ID,DISCOVERED_NAME,DISCOVERED_VERSION,DISCOVERED_PUBLISHER,
DISCOVERED_INSTALLDATE,CAT_MANUFACTURER,CAT_PRODUCT_NAME,CAT_PRODUCT_FAMILY,CAT_PRODUCT_NFAMILY,CAT_COMPONENT,CAT_PATCHLEVEL,
CAT_VERSION,CAT_SW_SUBVERSION,CAT_VERSION_GROUP,CAT_EDITION,CAT_TAXONOMY_CATEGORY1,CAT_TAXONOMY_CATEGORY2,IS_SUITE,CAT_LICENSABLE,
CAT_LICENSABLE_DETAIL,CAT_GA_DATE,CAT_SW_UUID,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,
CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,CAT_SW_EDITION_ID,CAT_TAXONOMY2012_ID,CAT_CPE_URI_ID,SUITE_ID,
GROUP_ID,IS_MAJOR_RELEASE,CAT_SW_MAJOR_RELEASE_ID,CAT_SW_MAJOR_VERSION,CAT_MAJOR_VERSION_GROUP,CAT_SW_MAJOR_UUID,
IS_LATEST,LATEST_CAT_SW_UUID,DEDUP_ID,MATCH_HOST_SW_PROD_RN,TASK_ID,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_PROD_ALL_237467998 WHERE HIDDEN=0 UNION ALL SELECT DISC_SW_PROD_ID,HOST_ID,HOSTNAME,DISCOVERED_ID,DISCOVERED_NAME,DISCOVERED_VERSION,DISCOVERED_PUBLISHER,
DISCOVERED_INSTALLDATE,CAT_MANUFACTURER,CAT_PRODUCT_NAME,CAT_PRODUCT_FAMILY,CAT_PRODUCT_NFAMILY,CAT_COMPONENT,CAT_PATCHLEVEL,
CAT_VERSION,CAT_SW_SUBVERSION,CAT_VERSION_GROUP,CAT_EDITION,CAT_TAXONOMY_CATEGORY1,CAT_TAXONOMY_CATEGORY2,IS_SUITE,CAT_LICENSABLE,
CAT_LICENSABLE_DETAIL,CAT_GA_DATE,CAT_SW_UUID,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,
CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,CAT_SW_EDITION_ID,CAT_TAXONOMY2012_ID,CAT_CPE_URI_ID,SUITE_ID,
GROUP_ID,IS_MAJOR_RELEASE,CAT_SW_MAJOR_RELEASE_ID,CAT_SW_MAJOR_VERSION,CAT_MAJOR_VERSION_GROUP,CAT_SW_MAJOR_UUID,
IS_LATEST,LATEST_CAT_SW_UUID,DEDUP_ID,MATCH_HOST_SW_PROD_RN,TASK_ID,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_PROD_ALL_237470163 WHERE HIDDEN=0 UNION ALL SELECT DISC_SW_PROD_ID,HOST_ID,HOSTNAME,DISCOVERED_ID,DISCOVERED_NAME,DISCOVERED_VERSION,DISCOVERED_PUBLISHER,
DISCOVERED_INSTALLDATE,CAT_MANUFACTURER,CAT_PRODUCT_NAME,CAT_PRODUCT_FAMILY,CAT_PRODUCT_NFAMILY,CAT_COMPONENT,CAT_PATCHLEVEL,
CAT_VERSION,CAT_SW_SUBVERSION,CAT_VERSION_GROUP,CAT_EDITION,CAT_TAXONOMY_CATEGORY1,CAT_TAXONOMY_CATEGORY2,IS_SUITE,CAT_LICENSABLE,
CAT_LICENSABLE_DETAIL,CAT_GA_DATE,CAT_SW_UUID,CAT_MANUFACTURER_ID,CAT_SW_PRODUCT_ID,CAT_SW_VERSION_GROUP_ID,
CAT_SW_VERSION_ID,CAT_SW_RELEASE_ID,CAT_SW_EDITION_ID,CAT_TAXONOMY2012_ID,CAT_CPE_URI_ID,SUITE_ID,
GROUP_ID,IS_MAJOR_RELEASE,CAT_SW_MAJOR_RELEASE_ID,CAT_SW_MAJOR_VERSION,CAT_MAJOR_VERSION_GROUP,CAT_SW_MAJOR_UUID,
IS_LATEST,LATEST_CAT_SW_UUID,DEDUP_ID,MATCH_HOST_SW_PROD_RN,TASK_ID,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_PROD_ALL_9999 WHERE HIDDEN=0
Possibly Referenced Tables/Views: