BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_ALL_OS - Operating Systems information discovered

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 0  √  null
DISC_CDROMS.OPERATINGSYSTEM_ID FK0_DISC_CDROMS R
DISC_COMPUTERSYSTEM.COMPUTERSYSTEM_ID FK2_DISC_COMPUTERSYSTEM R
DISC_CPUS.OPERATINGSYSTEM_ID FK0_DISC_CPUS R
DISC_DISK_PARTITIONS.OPERATINGSYSTEM_ID FK0_DISC_DISK_PARTITIONS R
DISC_HDDS.OPERATINGSYSTEM_ID FK0_DISC_HDDS R
DISC_LOGICAL_DISKS.OPERATINGSYSTEM_ID FK0_DISC_LOGICAL_DISKS R
DISC_MONITORS.OPERATINGSYSTEM_ID FK0_DISC_MONITORS R
DISC_NICS.OPERATINGSYSTEM_ID FK0_DISC_NICS R
DISC_VIDEO_CONTROLLERS.OPERATINGSYSTEM_ID FK0_DISC_VIDEO_CONTROLLERSS R
DISC_WINDOWS_SERVICES.OPERATINGSYSTEM_ID FK0_DISC_WINDOWS_SERVICES R
Unique Operating System ID
INVENTORY_ID number 18  √  null
DISC_CDROMS.INVENTORY_ID FK0_DISC_CDROMS R
DISC_COMPUTERSYSTEM.INVENTORY_ID FK2_DISC_COMPUTERSYSTEM R
DISC_CPUS.INVENTORY_ID FK0_DISC_CPUS R
DISC_DISK_PARTITIONS.INVENTORY_ID FK0_DISC_DISK_PARTITIONS R
DISC_HDDS.INVENTORY_ID FK0_DISC_HDDS R
DISC_LOGICAL_DISKS.INVENTORY_ID FK0_DISC_LOGICAL_DISKS R
DISC_MONITORS.INVENTORY_ID FK0_DISC_MONITORS R
DISC_NICS.INVENTORY_ID FK0_DISC_NICS R
DISC_VIDEO_CONTROLLERS.INVENTORY_ID FK0_DISC_VIDEO_CONTROLLERSS R
DISC_WINDOWS_SERVICES.INVENTORY_ID FK0_DISC_WINDOWS_SERVICES R
MATCH_INVENTORY.INVENTORY_ID FK1_DISC_ALL_OS R
DISC_HOSTS.INVENTORY_ID FK2_DISC_ALL_OS R
Inventory ID for this row
TASK_ID number 18  √  null
DISC_CDROMS.TASK_ID FK0_DISC_CDROMS R
DISC_COMPUTERSYSTEM.TASK_ID FK2_DISC_COMPUTERSYSTEM R
DISC_CPUS.TASK_ID FK0_DISC_CPUS R
DISC_DISK_PARTITIONS.TASK_ID FK0_DISC_DISK_PARTITIONS R
DISC_HDDS.TASK_ID FK0_DISC_HDDS R
DISC_LOGICAL_DISKS.TASK_ID FK0_DISC_LOGICAL_DISKS R
DISC_MONITORS.TASK_ID FK0_DISC_MONITORS R
DISC_NICS.TASK_ID FK0_DISC_NICS R
DISC_VIDEO_CONTROLLERS.TASK_ID FK0_DISC_VIDEO_CONTROLLERSS R
DISC_WINDOWS_SERVICES.TASK_ID FK0_DISC_WINDOWS_SERVICES R
DISC_HOSTS.TASK_ID FK2_DISC_ALL_OS R
MATCH_TASK_DET.TASK_ID FK0_DISC_ALL_OS R
Task ID for this row
HOST_ID number 0  √  null
DISC_HOSTS.HOST_ID FK2_DISC_ALL_OS R
Unique host ID
OPERATINGSYSTEM_LABEL nvarchar2 256  √  null Operating System label
HOSTNAME nvarchar2 1024  √  null Hostname
OSCOMPUTERNAME nvarchar2 256  √  null Operating System Computer name
MANUFACTURER nvarchar2 256  √  null Operating System Manufacturer name
OPERATINGSYSTEM_TYPE_LABEL nvarchar2 1024  √  null Operating System Label (e.g., Vista, XP, etc,)
OS_FAMILY nvarchar2 256  √  null Operating System Family (e.g., Windows, Linux)
EDITION nvarchar2 256  √  null Operating System Edition (e.g., Professional, Standard; 32-bit x86)
VERSION nvarchar2 256  √  null Operating System version (e.g., 5.1.2600, 5.2.3790)
PATCHLEVEL nvarchar2 256  √  null Patch Level (e.g., Service Pack 2)
OSBUILDNUMBER nvarchar2 256  √  null Operating System build number
HARDWARE nvarchar2 256  √  null Hardware information (e.g., Dell Inc. Latitude D620, Compaq ProLiant DL580 G2)
NUMCPUS float 126  √  null Number of CPUS
CPU_SPEED float 126  √  null CPU Speed
OSBITMODE nvarchar2 2  √  null Operating System bit mode (e.g,, 32-bit, 64-bit)
TOTALMEMORY float 126  √  null Total Memory
TOTMEMBUCKET nvarchar2 256  √  null Total Memory bucket
TOTALVIRTUALMEMORY float 126  √  null Total Virtual memory
TOTALVISIBLEMEMORY float 126  √  null Total Visible Virtual memory
UPTIME float 126  √  null Total uptime
LASTLOGON nvarchar2 256  √  null Last logon information (e.g., januta01, mowdam01a)
LOCALFILESYSTEMSPACETOTAL float 126  √  null Total Local file system space
LOCALFILESYSTEMSPACEUSED float 126  √  null Used Local file system space
LOCALFILESYSTEMSPACEPCT float 126  √  null Percentage Local file system space
LOCALFILESYSTEMSPACEAVAILABLE float 126  √  null Available Local file system space
SERIALNUMBER nvarchar2 256  √  null Serial number
SCANDATE date 7  √  null Last Scan Date
OSCOMPUTERDOMAIN nvarchar2 256  √  null Computer Domain
USER_DOMAIN nvarchar2 1024  √  null User Domain
LEVEL2 nvarchar2 1  √  null Level 2
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)
ACTIVE nvarchar2 1024  √  null Is this system active?
CPU_RID float 126  √  null CPU table unique identifier
OPERATINGSYSTEM_INSTALLDATE date 7  √  null Operating system install date
IS_UNIQUE number 0  √  null This record is UNIQUE and not deduped with other data source
DEDUPED_HOST_ID number 0  √  null If this record is not unique, the host_id for which it is deduped
DEDUPED_TASK_ID number 0  √  null If this record is not unique, the task_id from which it is deduped
DISC_ALL_OS_RN number 18  √  null Internal column

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + OPERATINGSYSTEM_ID Primary key Asc/Asc/Asc PK_DISC_ALL_OS These unique columns are also nullable
INVENTORY_ID + TASK_ID + HOST_ID Performance Asc/Asc/Asc DISC_ALL_OS_HOSTID  

Close relationships  within of separation:
Confidential and Proprietary to BDNA