Owner's Manual

178 Reporting
ArrayDiskChannel int 4 Yes The bus to which this
array disk is connected.
ArrayDiskLength int 4 Yes The array disk's size in
gigabytes. If the size is
0, it is smaller than a
gigabyte.
ArrayDiskBusType nvarchar 64 Yes The array disk's bus
type. Possible values:
SCSI, IDE, Fibre
Channel, SSA, USB,
and SATA.
ArrayDiskTargetId int 4 Yes The SCSI target ID
which this array disk is
assigned.
ArrayDiskLUNId int 4 Yes The durable unique ID
for this array disk.
Controller Table
DeviceId* int 4 No The Foreign Key to the
Device Table.
ControllerNumber* int 4 No The instance number
of this controller entry.
ControllerName nvarchar 64 Yes The name of the
controller in this
subsystem as
represented in Storage
Management. Includes
the controller type and
instance, for example:
PERC 3/QC 1.
ControllerVendor nvarchar 64 Yes The controller's
reseller's name.
ControllerType nvarchar 64 Yes The type of controller.
Table 10-3. IT Assistant Database Schema
(continued)
Column Name Data Type Data
Size
Nulls
Allowed
Description