BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_HOST_SW_PROD_DET - Host-Software detailed information matched

Legend:
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
ID numeric 20  √  null Unique Software product ID
HOST_ID numeric 20  √  null Host ID for this Software product
HOSTNAME varchar 255  √  null Host name for this Software product
CAT_SW_UUID numeric 20  √  null Unique SW identifier
DISCOVERED_ID nvarchar 510  √  null Unique ID for Addremove/Exe/OS
CAT_MANUFACTURER_ID numeric 20  √  null Publisher ID from catalog for this Software product
CAT_SW_PRODUCT_ID numeric 20  √  null Product ID from catalog for this Software product
CAT_SW_EDITION_ID numeric 20  √  null Edition ID from catalog for this Software product
CAT_SW_VERSION_GROUP_ID numeric 20  √  null Catalog SW Version Group Id
CAT_SW_VERSION_ID numeric 20  √  null Version ID from catalog for this Software product
CAT_SW_RELEASE_ID numeric 20  √  null Release ID from catalog for this Software product
CAT_TAXONOMY2012_ID numeric 20  √  null Taxonomy ID from catalog for this Software product
CAT_CPE_URI_ID numeric 20  √  null Catalog CPE URI Id
SUITE_ID numeric 20  √  null Suite ID from catalog for this Software product
IS_SUITE varchar 1  √  null Catalog information: is this software product part of a suite? (e.g., N, Y)
GROUP_ID numeric 20  √  null Group ID from catalog for this Software product
DISCOVERED_NAME nvarchar 2048  √  null Discovered name for this Software product (e.g., Adobe Flash Player 9 Plugin, TextPad 4.7)
DISCOVERED_VERSION nvarchar 2048  √  null Discovered version for this Software product (e.g., 9.0.45.0)
DISCOVERED_PUBLISHER nvarchar 2048  √  null Discovered publihser for this Software product (e.g., Adobe Systems, Inc., Ipswitch)
DISCOVERED_INSTALLDATE datetime 16,3  √  null Discovered installed date Software product
ORIGINATE_FROM numeric 20  √  null Sofware product originates from (e.g., 1= Add/Remove, 2= Exe, 4=OS)
SOURCE_BITMAP numeric 20  √  null Sofware product source bit-map
IS_MAPPED varchar 1  √  null Sofware product mapped? (e.g., Y, N)
HIDDEN numeric 20  √  null Sofware product hidden? (1=yes 0= no. reasons for hidden in hidden_reason column)
HIDDEN_REASON varchar 1000  √  null Sofware product hidden reason (e.g., add/remove AND exe file resulting the same product, match result shows duplicated products on a same host, etc.)
IS_MAJOR_RELEASE varchar 3  √  null Catalog Major Release
CAT_SW_MAJOR_RELEASE_ID numeric 20  √  null Catalog Major Release Id
CAT_SW_MAJOR_VERSION varchar 64  √  null Catalog SW major Version
IS_LATEST numeric 20  √  null Placeholder column for future deduping logic. Defaulted to 1 as of N4.1
LATEST_CAT_SW_UUID numeric 20  √  null Placeholder column for future deduping logic. Defaulted to NULL as of N4.1
DEDUP_ID numeric 20  √  null Parent Id if this software is deduped
IS_MERGED varchar 3  √  null Is this software merged from parent software (deduped_id)
TASK_ID numeric 20  √  null Task ID for this row
MATCH_HOST_SW_PROD_RN numeric 21  √  null Internal Id
INVENTORY_ID numeric 20 Inventory ID for this row
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:14 PDT 2017

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:

Confidential and Proprietary to BDNA