Table BDNA_PUBLISH.dbo.DISC_WINDOWS_NICS
Has Discovered Network Interface Cards 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
NIC_ID float 8 Windows NICS Id
NIC_LABEL nvarchar 512  √  null Windows NICS label eg: 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 eg: 192.168.1.1 etc
NETWORK_MASK nvarchar 512  √  null Windows NICS netword mask eg: 255.255.255.0
DHCP_ENABLED nvarchar 512  √  null Windows NICS DHCP enabled eg 1= yes, 0= no
DHCP_LEASE_EXPR nvarchar 512  √  null Windows NICS Lease exparation
DHCP_SERVER nvarchar 512  √  null Windows NICS DHCP server eg: 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 eg: SCCM, ADDM
OPERATINGSYSTEM_ID float 8  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_WINDOWS_NICS R
Operating System Id
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK0_DISC_WINDOWS_NICS R
Task Id for this row
INVENTORY_ID float 8
DISC_ALL_OS.INVENTORY_ID FK0_DISC_WINDOWS_NICS R
Inventory Id for this row

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
NIC_ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_DISC_WINDOWS_NICS

Close relationships  within of separation: