HP Storage Essentials SRM 6.0 User Guide for Enterprise Edition and Standard Edition SRM Software (July 2008)

Running Reports478
Table 80 MVC_STORAGEPOOLCONFIGVW
Column Name Type Description
StoragePoolID NUMBER(38) Storage Pool ID
CollectionTime TIMESTAMP (6) Configuration stats collection time
MaskedMB NUMBER Masked Storage in megabytes
ExportedMB NUMBER Storage exposed in megabytes
UnexportedMB NUMBER Volume unexposed in megabytes
AvailableMB NUMBER Available storage left on storage pool
ProvisionedMB NUMBER Provisioned storage in megabytes
TotalMB NUMBER Total storage in megabytes
StorageCapability VARCHAR2(255) Storage pool capability
MainframePool VARCHAR2(13) Indicate whether reserved for mainframe:
MAINFRAMEPOOL
Table 81 MVC_SWITCHCONFIGVW
Column Name Type Description
SwitchID NUMBER(38) Switch ID
AvailablePorts NUMBER(38) Number of available ports
ConnectedPorts NUMBER(38) Number of used ports
TotalPorts NUMBER(38) Number of total ports of this switch
Table 82 MVC_OPTIONALTABLEVW
Column Name Type Description
BaseTableName VARCHAR2(30) Name of the base table
BaseTableID NUMBER(38) ID of the base table record
OptionalName VARCHAR2(50) Name of the optional value
OptionalValue VARCHAR2(4000) Value of the optional value