BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_NICS - Network Interface Cards information 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
NIC_ID number 0  √  null Windows NICS ID
NIC_LABEL nvarchar2 256  √  null Windows NICS label (e.g., Broadcom NetXtreme 57xx Gigabit Controller)
NIC_NAME nvarchar2 256  √  null Windows NICS name
NIC_MANUF nvarchar2 256  √  null Windows NICS manufacturer
MACADDRESS nvarchar2 256  √  null Windows NIC MAC address
IP_ADDRESS nvarchar2 256  √  null Windows NICS IP address
DEFAULT_ROUTE nvarchar2 256  √  null Windows NICS default route (e.g., 192.168.1.1, etc.)
NETWORK_MASK nvarchar2 256  √  null Windows NICS netword mask (e.g., 255.255.255.0)
DHCP_ENABLED nvarchar2 256  √  null Windows NICS DHCP enabled (e.g., 1=yes, 0=no)
DHCP_LEASE_EXPR nvarchar2 256  √  null Windows NICS Lease exparation
DHCP_SERVER nvarchar2 256  √  null Windows NICS DHCP server (e.g., 192.168.1.1, 255.255.255.255)
DNS nvarchar2 256  √  null Windows NICS DNS
DNS_SEARCH nvarchar2 256  √  null Windows NICS DNS search
DNS_PRIMARY nvarchar2 256  √  null Windows NICS DNS primary
DNS_SECONDARY nvarchar2 256  √  null Windows NICS DNS secondary
DNS_TERTIARY nvarchar2 256  √  null Windows NICS DNS tertiaty
DNS_OTHER nvarchar2 256  √  null Windows NICS DNS other
WINS_PRIMARY nvarchar2 256  √  null Windows NICS windows primary
WINS_SECONDARY nvarchar2 256  √  null Windows NICS windows secondary
PNP_DEVICEID nvarchar2 256  √  null Windows NICS PNP device ID
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
OPERATINGSYSTEM_ID number 0  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_NICS R
Operating System ID
TASK_ID number 18  √  null
DISC_ALL_OS.TASK_ID FK0_DISC_NICS R
Task ID for this row
INVENTORY_ID number 18  √  null
DISC_ALL_OS.INVENTORY_ID FK0_DISC_NICS R
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 + NIC_ID Primary key Asc/Asc/Asc PK_DISC_NICS These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA