BDNA Data Platform 5.4 July 2017 (Oracle)
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 number 0  √  null Unique Software product ID
HOST_ID number 0  √  null Host ID for this Software product
HOSTNAME varchar2 255  √  null Host name for this Software product
CAT_SW_UUID number 18  √  null Unique SW identifier
DISCOVERED_ID nvarchar2 100  √  null Unique ID for Addremove/Exe/OS
CAT_MANUFACTURER_ID number 18  √  null Publisher ID from catalog for this Software product
CAT_SW_PRODUCT_ID number 18  √  null Product ID from catalog for this Software product
CAT_SW_EDITION_ID number 18  √  null Edition ID from catalog for this Software product
CAT_SW_VERSION_GROUP_ID number 18  √  null Catalog SW Version Group Id
CAT_SW_VERSION_ID number 18  √  null Version ID from catalog for this Software product
CAT_SW_RELEASE_ID number 18  √  null Release ID from catalog for this Software product
CAT_TAXONOMY2012_ID number 18  √  null Taxonomy ID from catalog for this Software product
CAT_CPE_URI_ID number 18  √  null Catalog CPE URI Id
SUITE_ID number 0  √  null Suite ID from catalog for this Software product
IS_SUITE varchar2 1  √  null Catalog information: is this software product part of a suite? (e.g., N, Y)
GROUP_ID number 0  √  null Group ID from catalog for this Software product
DISCOVERED_NAME nvarchar2 1024  √  null Discovered name for this Software product (e.g., Adobe Flash Player 9 Plugin, TextPad 4.7)
DISCOVERED_VERSION nvarchar2 1024  √  null Discovered version for this Software product (e.g., 9.0.45.0)
DISCOVERED_PUBLISHER nvarchar2 1024  √  null Discovered publihser for this Software product (e.g., Adobe Systems, Inc., Ipswitch)
DISCOVERED_INSTALLDATE date 7  √  null Discovered installed date Software product
ORIGINATE_FROM number 0  √  null Sofware product originates from (e.g., 1= Add/Remove, 2= Exe, 4=OS)
SOURCE_BITMAP number 0  √  null Sofware product source bit-map
IS_MAPPED varchar2 1  √  null Sofware product mapped? (e.g., Y, N)
HIDDEN number 0  √  null Sofware product hidden? (1=yes 0= no. reasons for hidden in hidden_reason column)
HIDDEN_REASON varchar2 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 varchar2 3  √  null Catalog Major Release
CAT_SW_MAJOR_RELEASE_ID number 18  √  null Catalog Major Release Id
CAT_SW_MAJOR_VERSION varchar2 64  √  null Catalog SW major Version
IS_LATEST number 0  √  null Placeholder column for future deduping logic. Defaulted to 1 as of N4.1
LATEST_CAT_SW_UUID number 18  √  null Placeholder column for future deduping logic. Defaulted to NULL as of N4.1
DEDUP_ID number 18  √  null Parent Id if this software is deduped
IS_MERGED varchar2 3  √  null Is this software merged from parent software (deduped_id)
MATCH_HOST_SW_PROD_RN number 18  √  null Internal Id
TASK_ID number 18  √  null Task ID for this row
INVENTORY_ID number 18  √  null Inventory ID for this row
DATASRC varchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:13 PDT 2017

View Definition:
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,MATCH_HOST_SW_PROD_RN,TASK_ID,INVENTORY_ID,DATASRC FROM MATCH_HOST_SW_PROD_ALL
 
Confidential and Proprietary to BDNA