BDNA Discover Publish version 7.7.2 with 201708
BDNA_ALL_OS - All 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 BDNA_ALL_OS0_OST R
OS Type
OS_FAMILY varchar2 11  √  null OS Family
EDITION varchar2 256  √  null OS Edition
VERSION varchar2 256  √  null OS Version
OSINSTALLDATE varchar2 4000  √  null OS Install Date
PATCHLEVEL varchar2 256  √  null OS 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)
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_APACHE_INSTANCES.OPERATINGSYSTEM_ID FKM1_BDNAAPACHEINSTA R
BDNA_ATTACHED_PRINTERS.OPERATINGSYSTEM_ID FKM0_BDNAATTACHEDPRI R
BDNA_BRIDGES.OPERATINGSYSTEM_ID FKM0_BDNA_BRIDGES R
BDNA_CDROMS.OPERATINGSYSTEM_ID FKM0_BDNA_CDROMS R
BDNA_CITRIX_VIRTAPPS.OPERATINGSYSTEM_ID FKM1_BDNACITRIXVIRTA R
BDNA_CITRIXLICENSEINV.OPERATINGSYSTEM_ID FKM0_BDNACITRIXLICEN R
BDNA_CONCENTRATORS.OPERATINGSYSTEM_ID FKM0_BDNACONCENTRATO R
BDNA_CPUS.OPERATINGSYSTEM_ID FKM0_BDNA_CPUS R
BDNA_DB2_DBS.OPERATINGSYSTEM_ID FKM0_BDNA_DB2_DBS R
BDNA_DB2_FEATURES.OPERATINGSYSTEM_ID FKM0_BDNADB2FEATURES R
BDNA_DB2_INSTALLS.OPERATINGSYSTEM_ID FKM0_BDNADB2INSTALLS R
BDNA_DB2_INSTANCES.OPERATINGSYSTEM_ID FKM0_BDNADB2INSTANCE R
BDNA_DB2_SCHEMAS.OPERATINGSYSTEM_ID FKM0_BDNADB2SCHEMAS R
BDNA_DB2_TS.OPERATINGSYSTEM_ID FKM0_BDNA_DB2_TS R
BDNA_FABRIC_SWITCHES.OPERATINGSYSTEM_ID FKM0_BDNAFABRICSWITC R
BDNA_FIREWALLS.OPERATINGSYSTEM_ID FKM0_BDNA_FIREWALLS R
BDNA_FLEXLM_LICENSES.OPERATINGSYSTEM_ID FKM0_BDNAFLEXLMLICEN R
BDNA_FP_APPS.OPERATINGSYSTEM_ID FKM0_BDNA_FP_APPS R
BDNA_HDDS.OPERATINGSYSTEM_ID FKM0_BDNA_HDDS R
BDNA_HTTP_SERVERS.OPERATINGSYSTEM_ID FKM0_BDNAHTTPSERVERS R
BDNA_HUBS_SWITCHES.OPERATINGSYSTEM_ID FKM0_BDNAHUBSSWITCHE R
BDNA_IBMHTTP_INSTANCES.OPERATINGSYSTEM_ID FKM1_BDNAIBMHTTPINST R
BDNA_IFMX_INSTALLS.OPERATINGSYSTEM_ID FKM0_BDNAIFMXINSTALL R
BDNA_IFMX_INSTANCES.OPERATINGSYSTEM_ID FKM0_BDNAIFMXINSTANC R
BDNA_IMAP_SERVERS.OPERATINGSYSTEM_ID FKM0_BDNAIMAPSERVERS R
BDNA_LOADBALS.OPERATINGSYSTEM_ID FKM0_BDNA_LOADBALS R
BDNA_MASTER_OS_MAP.DISCOVERED_OS_ID FKM0_BDNAMASTEROSMAP R
BDNA_MSSQL_DBS.OPERATINGSYSTEM_ID FKM0_BDNA_MSSQL_DBS R
BDNA_MSSQL_INSTALLS.OPERATINGSYSTEM_ID FKM0_BDNAMSSQLINSTAL R
BDNA_MSSQL_INSTANCES.OPERATINGSYSTEM_ID FKM0_BDNAMSSQLINSTAN R
BDNA_NAS.OPERATINGSYSTEM_ID FKM0_BDNA_NAS R
BDNA_NET_PRINT_SERVERS.OPERATINGSYSTEM_ID FKM0_BDNANETPRINTSER R
BDNA_NET_PRINTERS.OPERATINGSYSTEM_ID FKM0_BDNANETPRINTERS R
BDNA_NET_SERVICES.OPERATINGSYSTEM_ID FKM0_BDNANETSERVICES R
BDNA_OPENPORTS.OPERATINGSYSTEM_ID FKM1_BDNA_OPENPORTS R
BDNA_ORACLE_LISTENERS.OPERATINGSYSTEM_ID FKM0_BDNAORACLELISTE R
BDNA_ORADB_INSTALLS.OPERATINGSYSTEM_ID FKM0_BDNAORADBINSTAL R
BDNA_ORADB_INSTANCES.OPERATINGSYSTEM_ID FKM0_BDNAORADBINSTAN R
BDNA_ORADB_SCHEMAS.OPERATINGSYSTEM_ID FKM0_BDNAORADBSCHEMA R
BDNA_ORADB_TS.OPERATINGSYSTEM_ID FKM0_BDNA_ORADB_TS R
BDNA_OS_GROUP_REL.OPERATINGSYSTEM_ID FKM0_BDNAOSGROUPREL R
BDNA_OS_IPNIC_REL.OPERATINGSYSTEM_ID FKM0_BDNAOSIPNICREL R
BDNA_OS_MACNIC_REL.OPERATINGSYSTEM_ID FKM0_BDNAOSMACNICREL R
BDNA_OS_NET_REL.OPERATINGSYSTEM_ID FKM1_BDNA_OS_NET_REL R
BDNA_OS_SCANNEDIP_REL.OPERATINGSYSTEM_ID FKM0_BDNAOSSCANNEDIP R
BDNA_OS_STORAGE_REL.OPERATINGSYSTEM_ID FKM0_BDNAOSSTORAGERE R
BDNA_OTHER_NETEQP.OPERATINGSYSTEM_ID FKM0_BDNAOTHERNETEQP R
BDNA_POP_SERVERS.OPERATINGSYSTEM_ID FKM0_BDNAPOPSERVERS R
BDNA_ROUTERS.OPERATINGSYSTEM_ID FKM0_BDNA_ROUTERS R
BDNA_SMTP_SERVERS.OPERATINGSYSTEM_ID FKM0_BDNASMTPSERVERS R
BDNA_UNIX_OS.OPERATINGSYSTEM_ID FKM0_BDNA_UNIX_OS R
BDNA_VIRT_OS.OPERATINGSYSTEM_ID FKM0_BDNA_VIRT_OS R
BDNA_WDMDEVICES.OPERATINGSYSTEM_ID FKM0_BDNA_WDMDEVICES R
BDNA_WEBLOGIC_APPS.OPERATINGSYSTEM_ID FKM1_BDNAWEBLOGICAPP R
BDNA_WEBLOGIC_COMPONENTS.OPERATINGSYSTEM_ID FKM1_BDNAWEBLOGICCOM R
BDNA_WEBLOGIC_INSTALLS.OPERATINGSYSTEM_ID FKM0_BDNAWEBLOGICINS R
BDNA_WEBLOGIC_INSTANCES.OPERATINGSYSTEM_ID FKM0_BDNAWEBLOGICIN1 R
BDNA_WEBLOGIC_LICENSES.OPERATINGSYSTEM_ID FKM1_BDNAWEBLOGICLIC R
BDNA_WEBSPHERE_APPMODSTATS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHEREA1 R
BDNA_WEBSPHERE_APPS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHEREAP R
BDNA_WEBSPHERE_CONN_POOLS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHERECO R
BDNA_WEBSPHERE_ENV_VARS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHEREEN R
BDNA_WEBSPHERE_INSTALLS.OPERATINGSYSTEM_ID FKM0_BDNAWEBSPHEREIN R
BDNA_WEBSPHERE_INSTANCES.OPERATINGSYSTEM_ID FKM0_BDNAWEBSPHEREI1 R
BDNA_WEBSPHERE_JVMS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHEREJV R
BDNA_WEBSPHERE_PORTS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHEREPO R
BDNA_WEBSPHERE_THRD_POOLS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHERETH R
BDNA_WEBSPHERE_TRANS.OPERATINGSYSTEM_ID FKM1_BDNAWEBSPHERETR R
BDNA_WEBSRV_INSTANCES.OPERATINGSYSTEM_ID FKM0_BDNAWEBSRVINSTA R
BDNA_WINDOWS_OS.OPERATINGSYSTEM_ID FKM0_BDNA_WINDOWS_OS R
BDNA_WIRELESS_DEVS.OPERATINGSYSTEM_ID FKM0_BDNAWIRELESSDEV R
BDNA_INV_CATALOG_MAP.INV_ASSET_ID FKM0_BDNA_ALL_OS R
Operating Systems Id
BIOSRELEASEDATE varchar2 4000  √  null BIOS Release Date
BIOSVERSION varchar2 4000  √  null BIOS Version
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_APACHE_INSTANCES.INVENTORY_ID FKM1_BDNAAPACHEINSTA R
BDNA_ATTACHED_PRINTERS.INVENTORY_ID FKM0_BDNAATTACHEDPRI R
BDNA_BRIDGES.INVENTORY_ID FKM0_BDNA_BRIDGES R
BDNA_CDROMS.INVENTORY_ID FKM0_BDNA_CDROMS R
BDNA_CITRIX_VIRTAPPS.INVENTORY_ID FKM1_BDNACITRIXVIRTA R
BDNA_CITRIXLICENSEINV.INVENTORY_ID FKM0_BDNACITRIXLICEN R
BDNA_CONCENTRATORS.INVENTORY_ID FKM0_BDNACONCENTRATO R
BDNA_CPUS.INVENTORY_ID FKM0_BDNA_CPUS R
BDNA_DB2_DBS.INVENTORY_ID FKM0_BDNA_DB2_DBS R
BDNA_DB2_FEATURES.INVENTORY_ID FKM0_BDNADB2FEATURES R
BDNA_DB2_INSTALLS.INVENTORY_ID FKM0_BDNADB2INSTALLS R
BDNA_DB2_INSTANCES.INVENTORY_ID FKM0_BDNADB2INSTANCE R
BDNA_DB2_SCHEMAS.INVENTORY_ID FKM0_BDNADB2SCHEMAS R
BDNA_DB2_TS.INVENTORY_ID FKM0_BDNA_DB2_TS R
BDNA_FABRIC_SWITCHES.INVENTORY_ID FKM0_BDNAFABRICSWITC R
BDNA_FIREWALLS.INVENTORY_ID FKM0_BDNA_FIREWALLS R
BDNA_FLEXLM_LICENSES.INVENTORY_ID FKM0_BDNAFLEXLMLICEN R
BDNA_FP_APPS.INVENTORY_ID FKM0_BDNA_FP_APPS R
BDNA_HDDS.INVENTORY_ID FKM0_BDNA_HDDS R
BDNA_HTTP_SERVERS.INVENTORY_ID FKM0_BDNAHTTPSERVERS R
BDNA_HUBS_SWITCHES.INVENTORY_ID FKM0_BDNAHUBSSWITCHE R
BDNA_IBMHTTP_INSTANCES.INVENTORY_ID FKM1_BDNAIBMHTTPINST R
BDNA_IFMX_INSTALLS.INVENTORY_ID FKM0_BDNAIFMXINSTALL R
BDNA_IFMX_INSTANCES.INVENTORY_ID FKM0_BDNAIFMXINSTANC R
BDNA_IMAP_SERVERS.INVENTORY_ID FKM0_BDNAIMAPSERVERS R
BDNA_LOADBALS.INVENTORY_ID FKM0_BDNA_LOADBALS R
BDNA_MASTER_OS_MAP.INVENTORY_ID FKM0_BDNAMASTEROSMAP R
BDNA_MSSQL_DBS.INVENTORY_ID FKM0_BDNA_MSSQL_DBS R
BDNA_MSSQL_INSTALLS.INVENTORY_ID FKM0_BDNAMSSQLINSTAL R
BDNA_MSSQL_INSTANCES.INVENTORY_ID FKM0_BDNAMSSQLINSTAN R
BDNA_NAS.INVENTORY_ID FKM0_BDNA_NAS R
BDNA_NET_PRINT_SERVERS.INVENTORY_ID FKM0_BDNANETPRINTSER R
BDNA_NET_PRINTERS.INVENTORY_ID FKM0_BDNANETPRINTERS R
BDNA_NET_SERVICES.INVENTORY_ID FKM0_BDNANETSERVICES R
BDNA_OPENPORTS.INVENTORY_ID FKM1_BDNA_OPENPORTS R
BDNA_ORACLE_LISTENERS.INVENTORY_ID FKM0_BDNAORACLELISTE R
BDNA_ORADB_INSTALLS.INVENTORY_ID FKM0_BDNAORADBINSTAL R
BDNA_ORADB_INSTANCES.INVENTORY_ID FKM0_BDNAORADBINSTAN R
BDNA_ORADB_SCHEMAS.INVENTORY_ID FKM0_BDNAORADBSCHEMA R
BDNA_ORADB_TS.INVENTORY_ID FKM0_BDNA_ORADB_TS R
BDNA_OS_GROUP_REL.INVENTORY_ID FKM0_BDNAOSGROUPREL R
BDNA_OS_IPNIC_REL.INVENTORY_ID FKM0_BDNAOSIPNICREL R
BDNA_OS_MACNIC_REL.INVENTORY_ID FKM0_BDNAOSMACNICREL R
BDNA_OS_NET_REL.INVENTORY_ID FKM1_BDNA_OS_NET_REL R
BDNA_OS_SCANNEDIP_REL.INVENTORY_ID FKM0_BDNAOSSCANNEDIP R
BDNA_OS_STORAGE_REL.INVENTORY_ID FKM0_BDNAOSSTORAGERE R
BDNA_OTHER_NETEQP.INVENTORY_ID FKM0_BDNAOTHERNETEQP R
BDNA_POP_SERVERS.INVENTORY_ID FKM0_BDNAPOPSERVERS R
BDNA_ROUTERS.INVENTORY_ID FKM0_BDNA_ROUTERS R
BDNA_SMTP_SERVERS.INVENTORY_ID FKM0_BDNASMTPSERVERS R
BDNA_UNIX_OS.INVENTORY_ID FKM0_BDNA_UNIX_OS R
BDNA_VIRT_OS.INVENTORY_ID FKM0_BDNA_VIRT_OS R
BDNA_WDMDEVICES.INVENTORY_ID FKM0_BDNA_WDMDEVICES R
BDNA_WEBLOGIC_APPS.INVENTORY_ID FKM1_BDNAWEBLOGICAPP R
BDNA_WEBLOGIC_COMPONENTS.INVENTORY_ID FKM1_BDNAWEBLOGICCOM R
BDNA_WEBLOGIC_INSTALLS.INVENTORY_ID FKM0_BDNAWEBLOGICINS R
BDNA_WEBLOGIC_INSTANCES.INVENTORY_ID FKM0_BDNAWEBLOGICIN1 R
BDNA_WEBLOGIC_LICENSES.INVENTORY_ID FKM1_BDNAWEBLOGICLIC R
BDNA_WEBSPHERE_APPMODSTATS.INVENTORY_ID FKM1_BDNAWEBSPHEREA1 R
BDNA_WEBSPHERE_APPS.INVENTORY_ID FKM1_BDNAWEBSPHEREAP R
BDNA_WEBSPHERE_CONN_POOLS.INVENTORY_ID FKM1_BDNAWEBSPHERECO R
BDNA_WEBSPHERE_ENV_VARS.INVENTORY_ID FKM1_BDNAWEBSPHEREEN R
BDNA_WEBSPHERE_INSTALLS.INVENTORY_ID FKM0_BDNAWEBSPHEREIN R
BDNA_WEBSPHERE_INSTANCES.INVENTORY_ID FKM0_BDNAWEBSPHEREI1 R
BDNA_WEBSPHERE_JVMS.INVENTORY_ID FKM1_BDNAWEBSPHEREJV R
BDNA_WEBSPHERE_PORTS.INVENTORY_ID FKM1_BDNAWEBSPHEREPO R
BDNA_WEBSPHERE_THRD_POOLS.INVENTORY_ID FKM1_BDNAWEBSPHERETH R
BDNA_WEBSPHERE_TRANS.INVENTORY_ID FKM1_BDNAWEBSPHERETR R
BDNA_WEBSRV_INSTANCES.INVENTORY_ID FKM0_BDNAWEBSRVINSTA R
BDNA_WINDOWS_OS.INVENTORY_ID FKM0_BDNA_WINDOWS_OS R
BDNA_WIRELESS_DEVS.INVENTORY_ID FKM0_BDNAWIRELESSDEV R
BDNA_INVENTORY_INFO.INVENTORY_ID BDNA_ALL_OS1_INVENTORY_ID R
BDNA_INV_CATALOG_MAP.INVENTORY_ID FKM0_BDNA_ALL_OS R
Inventory Id

Analyzed at Wed Jul 12 12:54 CST 2017

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

Close relationships  within of separation:
Confidential and Proprietary to BDNA