BDNA Discover Publish version 7.7.2 with 201708
BDNA_WDMDEVICES - Devices Discovered from Wyse Device Manager

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
OPERATINGSYSTEM_ID number 22  √  null
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNA_WDMDEVICES R
Operating Systems Id
APPLICATION_ID number 22  √  null
BDNA_FP_APPS.APPLICATION_ID FKM1_BDNA_WDMDEVICES R
Application Id
DEVICENAME varchar2 256  √  null Device Name
DEVICEIPADDRESS varchar2 256  √  null Device IP Address
DEVICEMACADDRESS varchar2 256  √  null Device MAC Address
PLATFORM varchar2 256  √  null Platform
DEVICEOS varchar2 256  √  null Device OS
IMAGE varchar2 256  √  null Image
CPU varchar2 256  √  null CPU
CPUSPEED number 22  √  null CPU Speed (MHz)
RAM number 22  √  null Total Memory
MEDIASIZE number 22  √  null Media Size
SERIALNUMBER varchar2 256  √  null Serial Number
BIOS varchar2 256  √  null BIOS
MANUFACTUREDON varchar2 256  √  null Date of Manufacture
DEVICE_ID number 22 Device Id
INVENTORY_ID number 22 -1
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_WDMDEVICES0_INVENTORY_ID R
BDNA_FP_APPS.INVENTORY_ID FKM1_BDNA_WDMDEVICES R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNA_WDMDEVICES R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

Indexes:
Column(s) Type Sort Constraint Name
DEVICE_ID + INVENTORY_ID Primary key Asc/Asc PK_BDNA_WDMDEVICES

Close relationships  within of separation:
Confidential and Proprietary to BDNA