BDNA Data Platform 5.4 July 2017 (SQL Server)
MATCH_HOST_SW_PROD - Host-Software 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
DISC_SW_PROD_ID numeric 20  √  null Unique Software product sequence ID
HOST_ID numeric 20  √  null Host ID for this Software product
HOSTNAME varchar 255  √  null Hostname for this Software product
DISCOVERED_ID nvarchar 510  √  null It could be unique addremove_id/file_id or Operating sytem Id
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
CAT_MANUFACTURER varchar 255  √  null Publisher from the catalog for this Software product (e.g., Adobe Systems, Helios Software Solutions)
CAT_PRODUCT_NAME varchar 255  √  null Product name from the catalog for this Software product (e.g., Flash Player, Photoshop Camera Raw)
CAT_PRODUCT_FAMILY varchar 255  √  null Product family from the catalog for this Software product (e.g., Office, Acrobat)
CAT_PRODUCT_NFAMILY numeric 20  √  null Product Name Includes Brand/Family?
CAT_COMPONENT varchar 64  √  null Product component from the catalog for this Software product (e.g., Client, Server)
CAT_PATCHLEVEL varchar 64  √  null Patch level from the catalog for this Software product (e.g., SP2)
CAT_VERSION varchar 64  √  null Version from the catalog for this Software product (e.g., 2007, 2.0)
CAT_SW_SUBVERSION varchar 64  √  null Catalog subversion
CAT_VERSION_GROUP varchar 64  √  null Version group from the catalog for this Software product (e.g., CS3, 2007)
CAT_EDITION varchar 2000  √  null Edition from the catalog for this Software product (e.g., Design Standard, Professional)
CAT_TAXONOMY_CATEGORY1 varchar 256  √  null Taxonomy category 1 from the catalog for this Software product (e.g., Applications, Utilities)
CAT_TAXONOMY_CATEGORY2 varchar 256  √  null Taxonomy category 2 from the catalog for this Software product (e.g., Productivity, Multimedia)
IS_SUITE varchar 1  √  null Catalog information: is this software product part of a suite? (e.g., N, Y)
CAT_LICENSABLE varchar 50  √  null Catalog information: is this software product licensable? (e.g., yes, no)
CAT_LICENSABLE_DETAIL varchar 50  √  null Catalog information: is this software product licensable? (e.g., yes, no, Generally Licensable, Some Releases are Licensable)
CAT_GA_DATE datetime 16,3  √  null GA date from catalog for this Software product
CAT_SW_UUID numeric 20  √  null Unique SW identifier
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_VERSION_GROUP_ID numeric 20  √  null Catalog Software 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_SW_EDITION_ID numeric 20  √  null Edition 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
GROUP_ID numeric 20  √  null Group ID from catalog for this Software product
IS_MAJOR_RELEASE varchar 3  √  null Is this a major release?
CAT_SW_MAJOR_RELEASE_ID numeric 20  √  null Catalog Major Release Id
CAT_SW_MAJOR_VERSION varchar 64  √  null Catalog Major Version
CAT_MAJOR_VERSION_GROUP varchar 64  √  null Catalog Major Version Group
CAT_SW_MAJOR_UUID numeric 20  √  null Catalog Major SW UUID
IS_LATEST numeric 20  √  null Place holder column for future deduping logic. Defaulted to 1 as of N4.1
LATEST_CAT_SW_UUID numeric 20  √  null Place holder column for future deduping logic. Defaulted to NULL as of N4.1
DEDUP_ID numeric 20  √  null Parent Id if this software is deduped
MATCH_HOST_SW_PROD_RN numeric 21  √  null Internal Id
TASK_ID numeric 20  √  null Task ID for this row
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 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:

Confidential and Proprietary to BDNA