HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
BIGINTSnapshotID
NVARCHAR(255)Name
NVARCHAR(255)Description
NVARCHAR(255)CIMdateTime
NVARCHAR(255)CurrentState
NVARCHAR(255)CurrentCause
NVARCHAR(255)NextBootState
NVARCHAR(255)NextBootCause
NVARCHAR(255)Capabilities
NVARCHAR(255)Dynamic
NVARCHAR(255)Required
NVARCHAR(255)Modifiable
NVARCHAR(510)Dependencies
HPUX_LogicalVolume table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTLogicalVolume_LUID
Node partly identifies HPUX_LogicalVolumeBIGINTNodeID
Snapshot partly identifies HPUX_LogicalVolumeBIGINTSnapshotID
Name of Logical Volume in the SystemNVARCHAR(256)Name
Inherited from CIM_LogicalDevice.DeviceID; an
address or other identifying information to uniquely
name the Logical Device
NVARCHAR(64)DeviceID
Inherited from CIM_StorageExtent.Access; describes
whether the media is readable, writeable, or both
SMALLINTAccess
(An enumeration: 0 = Unknown, 1 = Readable, 2 =
Writeable, 3 = Read/Write Supported, 4 = Write
Once)
Computed by multiplying
HPUX_LogicalVolume.BlockSize by
HPUX_LogicalVolume.NumberOfBlocks
BIGINTLogicalExtentSize
Capacity of logical volume in number of logical
extent
BIGINTCapacity
Number of the mirrored Copy for the logical volumeINTMirrorCopyNumber
Consistency Recovery Method for the mirrored logical
volume. No value for NOT mirrored Logical Volume
(MWC, NOMWC, NONE)
NVARCHAR(64)ConsistencyRecovery
Access Scheduling Policy of the logical volume; might
have values such as (Striped, Sequential, Parallel)
NVARCHAR(64)SchedulePolicy
Number of stripes for the logical volumeINTNumberOfStripes
Size of stripes for logical volume; value in KBINTStripeSize
Database tables 93