HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
Availability status of Volume Group in the System;
can be one of the following values (Available;
Unavailable)
NVARCHAR(32)Status
The size of the fundamental physical extent size in
bytes
INTPhysicalExtentSize
Capacity of whole Volume Group in number of
Physical Extent
INTCapacity
Allocated space in the volume group in number of
Physical Extent
INTAllocated
Number of free Physical Extents in the volume groupINTFreeSpace
Max number of definable physical volume in the
volume group
INTMaxNumberOfPVs
Number of max allocatable Physical Extent from
physical volume
INTNumberOfDefinedPVs
Number of current defined physical volume in the
volume proup
INTNumberOfActivePVs
Max number of definable logical volume in the
volume group
INTMaxNumberOfLVs
Number of current defined logical volume in the
volume group
INTNumberOfDefinedLVs
Number of current activel logical volume in the
volume group
INTNumberOfActiveLVs
Total number of physical volume group in this volume
group
INTNumberOfPVGroups
HPVM_Guest table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTHPVM_Guest_LUID
Partly identifies HPVM_GuestBIGINTNodeID
Partly identifies HPVM_GuestBIGINTSnapshotID
Displays the name of the hostNVARCHAR(256)Name
Displays the Guest IDSMALLINTGuestID
The UUID of the VM HostNVARCHAR(255)HostUUID
Displays the expected OS typeSMALLINTExpectedOperatingSystemType
Displays the number of virtual processorsSMALLINTProcessorCount
Displays a user-defined name for this guestNVARCHAR(256)ElementName
The amount of memory assigned to this guest in units
defined by MemorySizeUnits. The value cannot
BIGINTMemorySize
exceed the amount of memory installed on the host
system.
The units used for the MemorySize property.SMALLINTMemorySizeUnits
Used by Reporting to display the memory sizeNVARCHAR (255)r_MemorySize
Database tables 99