Owner's Manual

186 Reporting
Array Disk Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
ArrayDiskMediaType nvarchar 64 Yes The type of physical
disk present on the
system. The values are
SSD for Solid State
Drives, HDD for
magnetic disk drives
and N/A for
information not
available.
ArrayDiskNumber* int 4 No The instance number
of this array disk entry.
ArrayDiskName nvarchar 256 Yes The array disk’s name
as represented in
Storage Management.
ArrayDiskVendorName nvarchar 64 Yes The array disk's
(re)seller's name.
ArrayDiskModelNumber nvarchar 64 Yes The array disk’s model
number.
ArrayDiskSerialNumber nvarchar 64 Yes The array disk's unique
identification number
from the manufacturer.
ArrayDiskPartNumber nvarchar 64 Yes The array disk’s part
number.
ArrayDiskRevision nvarchar 64 Yes The array disk's
firmware version.
ArrayDiskEnclosureId nvarchar 64 Yes The SCSI ID of the
enclosure processor to
which this array disk
belongs.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description