BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_NICS - Discovered network interface controller (NICS) Info

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 numeric 20 Windows NICS ID
NIC_LABEL nvarchar 512  √  null Windows NICS label (e.g., Broadcom NetXtreme 57xx Gigabit Controller)
NIC_NAME nvarchar 512  √  null Windows NICS name
NIC_MANUF nvarchar 512  √  null Windows NICS manufacturer
MACADDRESS nvarchar 512  √  null Windows NIC MAC address
IP_ADDRESS nvarchar 512  √  null Windows NICS IP address
DEFAULT_ROUTE nvarchar 512  √  null Windows NICS default route (e.g., 192.168.1.1, etc.)
NETWORK_MASK nvarchar 512  √  null Windows NICS netword mask (e.g., 255.255.255.0)
DHCP_ENABLED nvarchar 512  √  null Windows NICS DHCP enabled (e.g., 1=yes, 0=no)
DHCP_LEASE_EXPR nvarchar 512  √  null Windows NICS Lease exparation
DHCP_SERVER nvarchar 512  √  null Windows NICS DHCP server (e.g., 192.168.1.1, 255.255.255.255)
DNS nvarchar 512  √  null Windows NICS DNS
DNS_SEARCH nvarchar 512  √  null Windows NICS DNS search
DNS_PRIMARY nvarchar 512  √  null Windows NICS DNS primary
DNS_SECONDARY nvarchar 512  √  null Windows NICS DNS secondary
DNS_TERTIARY nvarchar 512  √  null Windows NICS DNS tertiaty
DNS_OTHER nvarchar 512  √  null Windows NICS DNS other
WINS_PRIMARY nvarchar 512  √  null Windows NICS windows primary
WINS_SECONDARY nvarchar 512  √  null Windows NICS windows secondary
PNP_DEVICEID nvarchar 512  √  null Windows NICS PNP device ID
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)
OPERATINGSYSTEM_ID numeric 20  √  null Operating System ID
TASK_ID numeric 20 Task ID for this row
INVENTORY_ID numeric 20 Inventory ID for this row

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA