BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_ADDREMOVE - Operating System data discovered

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
HOST_ID numeric 20  √  null Host ID for this Software product
ADDREMOVE_ID varchar 100  √  null Unique Addremove ID for this Software product
PRODID varchar 1024  √  null PRODID for this Addremove
INSTALLDATE nvarchar 1024  √  null INSTALLDATE for this Software product
INVENTORY_ID numeric 20  √  null Inventory ID for this row
TASK_ID numeric 20  √  null Task ID for this row

Analyzed at Thu Jul 20 12:14 PDT 2017

View Definition:
CREATE VIEW DISC_ADDREMOVE AS SELECT HOST_ID,ADDREMOVE_ID,PRODID,INSTALLDATE,INVENTORY_ID,TASK_ID FROM DISC_ADDREMOVE_237467998 UNION ALL SELECT HOST_ID,ADDREMOVE_ID,PRODID,INSTALLDATE,INVENTORY_ID,TASK_ID FROM DISC_ADDREMOVE_237470163 UNION ALL SELECT HOST_ID,ADDREMOVE_ID,PRODID,INSTALLDATE,INVENTORY_ID,TASK_ID FROM DISC_ADDREMOVE_9999
 
Possibly Referenced Tables/Views:

Confidential and Proprietary to BDNA