Users Guide

Reporting and Task Management 67
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.
ControllerState nvarchar 64 Yes The current condition of the
controller's subsystem.
ControllerStatus int 4 Yes The controller's status
ControllerFWVersion nvarchar 64 Yes The controller's current
firmware version.
ControllerCacheSize int 4 Yes The controller's current amount
of cache memory.
ControllerPhysicalDeviceCount int 4 Yes The number of physical devices
on the controller channel,
including both disks and the
controller.
ControllerLogicalDeviceCount int 4 Yes The number of virtual disks on
the controller.
ControllerPartnerStatus nvarchar 64 Yes Indicates the availability of the
redundant controller in a
redundant configuration.
ControllerMemorySize int 4 Yes The amount of memory on the
controller.
ControllerDriveChannelCount int 4 Yes The number of redundant
controller drive channels.
ControllerChargeCount int 4 Yes The number of charges that
have been applied to the battery
on this controller.
ControllerDriverVersion nvarchar 64 Yes The currently installed driver
version for this controller.
Table 5-2. IT Assistant Database Schema (continued)
Column Name Data
Typ e
Data
Size
Nulls
Allowed
Description