BDNA Data Platform 5.4 July 2017 (Oracle)
DISC_LOGICAL_DISKS - Logical Disks 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
LOGICALDISK_ID number 0  √  null Logical disck ID
INVENTORY_ID number 18  √  null
DISC_ALL_OS.INVENTORY_ID FK0_DISC_LOGICAL_DISKS R
Inventory ID for this row
TASK_ID number 18  √  null
DISC_ALL_OS.TASK_ID FK0_DISC_LOGICAL_DISKS R
Task ID for this row
OPERATINGSYSTEM_ID number 0  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_LOGICAL_DISKS R
Operating System ID for the logical disk
LOGICALDISK_LABEL nvarchar2 1024  √  null Logical disk label (e.g., D:, A:)
FILESYSTEM nvarchar2 1024  √  null Logical disk File system (e.g., NTFS)
DESCRIPTION nvarchar2 1024  √  null Logical disk description (e.g., CD-ROM Disc, Local Fixed Disk, etc.)
CAPACITY float 126  √  null Logical disk capacity
CAPACITYBUCKET nvarchar2 256  √  null Logical disk cpacity bucket
AVAILABLECAPACITY float 126  √  null Logical disk available capacity
CAPACITYUSED float 126  √  null Logical disk capacity used
PERCENTUTILIZED float 126  √  null Logical disk percentage utilized
ISLOCAL nvarchar2 100  √  null Is Logical disk local? (e.g., local)
MOUNTPOINT nvarchar2 100  √  null Logical disk mount point (e.g., D:, C:, etc)
VOLUMENAME nvarchar2 1024  √  null Logical disk volume name (e.g., default, DIAD, etc.)
VOLUMESERIALNUMBER nvarchar2 1024  √  null Logical disk serial number
DATASRC nvarchar2 25  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:13 PDT 2017

Indexes:
Column(s) Type Sort Constraint Name Anomalies
INVENTORY_ID + TASK_ID + LOGICALDISK_ID Primary key Asc/Asc/Asc PK_DISC_LOGICAL_DISKS These unique columns are also nullable

Close relationships  within of separation:
Confidential and Proprietary to BDNA