BDNA Data Platform 5.4 July 2017 (SQL Server)
DISC_HDDS - Discovered Hard Disk Info

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
HDD_ID numeric 20 Hard disk ID
DEVICENAME nvarchar 512  √  null Device Name (e.g., Disk drive \\. \PHYSICALDRIVE8)
CONNECTIONTYPE nvarchar 512  √  null Connection type (e.g., SCSI, IDE)
MODEL nvarchar 2048  √  null Model (e.g., SCSI\DISK VEN_EMC PROD_POWER \EMCP 0001 0002 000019010173171F, SCSI\DISK VEN_EMC PROD_POWER \EMCP 0001 0001 2_0_0_0)
MANUFACTURER nvarchar 512  √  null Disk Manufcaturer
CAPACITY nvarchar 512  √  null Disk capacity
NUMPARTITIONS float 8  √  null Number of partitions on the disk
PNPDEVICEID nvarchar 2048  √  null PNP device ID
VOLUME_GROUP nvarchar 512  √  null Disk volume group
PHYSICALVOLUME_STATE nvarchar 512  √  null Disk physical volume
SERIALNUMBER nvarchar 512  √  null Disk serial number
CONNECTIONLOCATION nvarchar 512  √  null Disk connection location
DATASRC nvarchar 50  √  null Data Source for this row (e.g., SCCM, ADDM)
OPERATINGSYSTEM_ID numeric 20  √  null Operating System ID for this disk
TASK_ID numeric 20 Task ID for this row
INVENTORY_ID numeric 20 Inventory ID for this row

Analyzed at Thu Jul 20 12:14 PDT 2017

Confidential and Proprietary to BDNA