Table BDNA_PUBLISH.dbo.DISC_LOGICAL_DISKS
Has Discovered Logical Disks information

 Generated by
SchemaSpy
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 float 8 Logical disck Id
INVENTORY_ID float 8
DISC_ALL_OS.INVENTORY_ID FK0_DISC_LOGICAL_DISKS R
Inventory Id for this row
TASK_ID float 8
DISC_ALL_OS.TASK_ID FK0_DISC_LOGICAL_DISKS R
Task Id for this row
OPERATINGSYSTEM_ID float 8  √  null
DISC_ALL_OS.OPERATINGSYSTEM_ID FK0_DISC_LOGICAL_DISKS R
Operating System Id for the logical disk
LOGICALDISK_LABEL nvarchar 2048  √  null Logical disk label eg: D:, A:
FILESYSTEM nvarchar 2048  √  null Logical disk File system eg: NTFS
DESCRIPTION nvarchar 2048  √  null Logical disk description eg: CD-ROM Disc, Local Fixed Disk etc
CAPACITY float 8  √  null Logical disk capacity
CAPACITYBUCKET nvarchar 512  √  null Logical disk cpacity bucket
AVAILABLECAPACITY float 8  √  null Logical disk available capacity
CAPACITYUSED float 8  √  null Logical disk capacity used
PERCENTUTILIZED float 8  √  null Logical disk percentage utilized
ISLOCAL nvarchar 200  √  null Is Logical disk local? eg: local
MOUNTPOINT nvarchar 200  √  null Logical disk mount point eg: D:, C: etc
VOLUMENAME nvarchar 2048  √  null Logical disk volumne name eg: default, DIAD etc
VOLUMESERIALNUMBER nvarchar 2048  √  null Logical disk serial number
DATASRC nvarchar 50  √  null Data Source for this row eg: SCCM, ADDM

Analyzed at Thu Oct 04 14:29 PDT 2012

Indexes:
Column(s) Type Sort Constraint Name
LOGICALDISK_ID + TASK_ID + INVENTORY_ID Primary key Asc/Asc/Asc PK_DISC_LOGICAL_DISKS

Close relationships  within of separation: