BDNA Data Platform 5.4 July 2017 (SQL Server)
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 numeric 20 Logical disck ID
INVENTORY_ID numeric 20 Inventory ID for this row
TASK_ID numeric 20 Task ID for this row
OPERATINGSYSTEM_ID numeric 20  √  null Operating System ID for the logical disk
LOGICALDISK_LABEL nvarchar 2048  √  null Logical disk label (e.g., D:, A:)
FILESYSTEM nvarchar 2048  √  null Logical disk File system (e.g., NTFS)
DESCRIPTION nvarchar 2048  √  null Logical disk description (e.g., 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? (e.g., local)
MOUNTPOINT nvarchar 200  √  null Logical disk mount point (e.g., D:, C:, etc)
VOLUMENAME nvarchar 2048  √  null Logical disk volume name (e.g., default, DIAD, etc.)
VOLUMESERIALNUMBER nvarchar 2048  √  null Logical disk serial number
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA