BDNA Discover Publish version 7.7.0 with 201605 Sequence
BDNA_WINDOWS_OS - Windows Operating Systems

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_LABEL varchar2 256  √  null Hostname
HOSTNAME varchar2 256  √  null DNS Host Name
OSCOMPUTERNAME varchar2 256  √  null OS Computer Name
MANUFACTURER varchar2 256  √  null OS Manufacturer
OPERATINGSYSTEM_TYPE number 22  √  null
BDNA_TYPES.TYPE_ID BDNAWINDOWSOS0_OST R
OS Type
EDITION varchar2 256  √  null OS Edition
VERSION varchar2 256  √  null OS Version
OSINSTALLDATE varchar2 4000  √  null OS Install Date
PATCHLEVEL varchar2 256  √  null Patch Level/Service Pack
HARDWARE varchar2 256  √  null Machine (Hardware) Type
NUMCPUS number 22  √  null Number of CPUs
CPU_SPEED number 22  √  null CPU Speed (MHz)
OSBITMODE number 22  √  null OS Bit Mode(32/64 bit)
VOLUMESN varchar2 4000  √  null C Drive Volume Serial Number
TOTALMEMORY number 22  √  null Total Memory
TOTMEMBUCKET varchar2 22  √  null Total Memory Bucket
UPTIME number 22  √  null Up Time
LASTLOGON varchar2 256  √  null Last Logon User
LOCALFILESYSTEMSPACETOTAL number 22  √  null Total Local Filesystem Space
LOCALFILESYSTEMSPACEUSED number 22  √  null Total Used Local Filesystem Space
LOCALFILESYSTEMSPACEPCT number 22  √  null % of Local Filesystem Used
LOCALFILESYSTEMSPACEAVAILABLE number 22  √  null Total Available Filesystem Space
SERIALNUMBER varchar2 256  √  null Serial Number
SCANDATE date 7  √  null Scan Date/Time
MOSTRECENTSCANDATE date 7  √  null Most Recent Scan Date/Time
OSCOMPUTERDOMAIN varchar2 256  √  null OS Domain
LEVEL2 char 1  √  null Level 2?
OPERATINGSYSTEM_ID number 22
BDNA_WINDOWS_ADDREM_PGMS.OPERATINGSYSTEM_ID FKM0_BDNAWINDOWSADDR R
BDNA_WINDOWS_FS.OPERATINGSYSTEM_ID FKM0_BDNA_WINDOWS_FS R
BDNA_WINDOWS_HOTFIXES.OPERATINGSYSTEM_ID FKM0_BDNAWINDOWSHOTF R
BDNA_WINDOWS_LOCALACCTS.OPERATINGSYSTEM_ID FKM0_BDNAWINDOWSLOCA R
BDNA_WINDOWS_MONITORS.OPERATINGSYSTEM_ID FKM0_BDNAWINDOWSMONI R
BDNA_WINDOWS_NICS.OPERATINGSYSTEM_ID FKM0_BDNAWINDOWSNICS R
BDNA_WINDOWS_PROCESSES.OPERATINGSYSTEM_ID FKM0_BDNAWINDOWSPROC R
BDNA_WINDOWS_SERVICES.OPERATINGSYSTEM_ID FKM0_BDNAWINDOWSSERV R
BDNA_ALL_OS.OPERATINGSYSTEM_ID FKM0_BDNA_WINDOWS_OS R
Operating Systems Id
MOSTRECENTLEVEL2 char 1  √  null Is L2 Successful on most recent scan? (Factbase only)
NTPSERVER varchar2 4000  √  null NTP Time Server(s)
INVENTORY_ID number 22 -1
BDNA_WINDOWS_ADDREM_PGMS.INVENTORY_ID FKM0_BDNAWINDOWSADDR R
BDNA_WINDOWS_FS.INVENTORY_ID FKM0_BDNA_WINDOWS_FS R
BDNA_WINDOWS_HOTFIXES.INVENTORY_ID FKM0_BDNAWINDOWSHOTF R
BDNA_WINDOWS_LOCALACCTS.INVENTORY_ID FKM0_BDNAWINDOWSLOCA R
BDNA_WINDOWS_MONITORS.INVENTORY_ID FKM0_BDNAWINDOWSMONI R
BDNA_WINDOWS_NICS.INVENTORY_ID FKM0_BDNAWINDOWSNICS R
BDNA_WINDOWS_PROCESSES.INVENTORY_ID FKM0_BDNAWINDOWSPROC R
BDNA_WINDOWS_SERVICES.INVENTORY_ID FKM0_BDNAWINDOWSSERV R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_WINDOWS_OS1_INVENTORY_ID R
BDNA_ALL_OS.INVENTORY_ID FKM0_BDNA_WINDOWS_OS R
Inventory Id

Analyzed at Sat Mar 05 19:14 PST 2016

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA