BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_PROCESS - Discovered Process data

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 number 0  √  null Unique host ID
PROCESS_ID number 0  √  null Process ID
APP_ID nvarchar2 1024  √  null UNIX Process App ID
PROCESS_PATTERN nvarchar2 1024  √  null Process Pattern
OWNER nvarchar2 512  √  null Owner of the Process
PROCESS_CMDLINE nvarchar2 1024  √  null Process Command Line
INSTALLDIR nvarchar2 1024  √  null Install Directory of the Process Command
PROCESS_HASH nvarchar2 32  √  null Hash value of the row
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
TASK_ID number 18  √  null Task ID for this row
INVENTORY_ID number 18  √  null Inventory ID for this row

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + HOST_ID + PROCESS_ID Primary key Asc/Asc/Asc/Asc PK_DISC_PROCESSES These unique columns are also nullable
Confidential and Proprietary to BDNA