Users Guide

66 Reporting and Task Management
ArrayDiskName nvarchar 256 Yes The array disk’s name as
represented in Storage
Management.
ArrayDiskVendorName nvarchar 64 Yes The array disk's reseller'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.
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.
ArrayDiskChannel int 4 Yes The bus to which this array disk
is connected.
ArrayDiskLength int 4 Yes The array disk's size in
megabytes. If the size is 0, it is
smaller than a megabyte.
ArrayDiskBusType nvarchar 64 Yes The array disk's bus type.
Possible values: SCSI, IDE,
Fibre Channel, SSA, USB,
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
Ta b l e.
ControllerNumber* int 4 No The instance number of this
controller entry.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description