Table BDNA_PUBLISH.dbo.MATCH_HOST_SW_PROD_DET
Has Matched Host-Software detailed information

 Generated by
SchemaSpy
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 float 8 Unique Software product id
HOST_ID float 8  √  null
DISC_HOSTS.HOST_ID FK8_MATCH_HOST_SW_PROD_DET R
Host Id for this Software product
HOSTNAME varchar 255  √  null Host name for this Software product
cat_publisher_id float 8  √  null publisher Id from catalog for this Software product
cat_product_id float 8  √  null product Id from catalog for this Software product
cat_edition_id float 8  √  null edition Id from catalog for this Software product
cat_version_id float 8  √  null version Id from catalog for this Software product
cat_release_id float 8  √  null release Id from catalog for this Software product
cat_taxonomy_id float 8  √  null taxonomy Id from catalog for this Software product
SUITE_ID float 8  √  null suite Id from catalog for this Software product
IS_SUITE char 1  √  null Catalog information: if this software product part of suite? eg: N, Y
GROUP_ID float 8  √  null group Id from catalog for this Software product
DISCOVERED_NAME varchar 1024  √  null Discovered name for this Software product eg: Adobe Flash Player 9 Plugin,TextPad 4.7
DISCOVERED_VERSION varchar 1024  √  null Discovered version for this Software product eg:9.0.45.0
DISCOVERED_PUBLISHER varchar 1024  √  null Discovered publihser for this Software product eg: Adobe Systems, Inc., Ipswitch
DISCOVERED_INSTALLDATE datetime 16,3  √  null Discovered installed date Software product
ORIGINATE_FROM float 8  √  null Sofware product originate from eg: 1= Add/Remove 2= Exe 4 =OS
SOURCE_BITMAP float 8  √  null Sofware product source bit map
IS_MAPPED char 1  √  null Sofware product mapped? eg: Y, N
HIDDEN float 8  √  null Sofware product hidden? 1=yes 0= no. resons for hidden in hidden_reason column
HIDDEN_REASON varchar 1000  √  null Sofware product hidden reason eg: add/remove AND exe file resulting the same product,match result shows duplicated products on a same host etc
TASK_ID float 8  √  null
DISC_HOSTS.TASK_ID FK8_MATCH_HOST_SW_PROD_DET R
MATCH_TASK_DET.TASK_ID FK6_MATCH_HOST_SW_PROD_DET R
Task Id for this row
INVENTORY_ID float 8  √  null
DISC_HOSTS.INVENTORY_ID FK8_MATCH_HOST_SW_PROD_DET R
MATCH_INVENTORY.INVENTORY_ID FK7_MATCH_HOST_SW_PROD_DET R
Inventory Id for this row
datasrc nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
ID Primary key Asc PK_MATCH_HOST_SW_PROD_DET

Close relationships  within of separation: