HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
Indicates the number of minutes the operating system
is offset from GMT; the number is +,-,or 0
SMALLINTCurrentTimeZone
Amount of physical memory in KB available to
operating system; not necessarily true amount of
BIGINTTotalVisibleMemorySize
physical memory but what is reported to the
operating system as available
Total swap space in Kb; can be null if swap space
is not distinguished from page files
BIGINTTotalSwapSpaceSize
A string describing the manufacturer and operating
system type; used when the OperatingSystem
NVARCHAR(64)OtherTypeDescription
property, OSType, is set to 1 or 59 (Other or
Dedicated) (The format of the string inserted in
OtherTypeDescription should be similar in format to
the Values strings defined for OSType.
OtherTypeDescription should be set to null when
OSType is any value other than 1 or 59.)
Inherited from CIM_ManagedElement.Caption; a
short textual description (one line string) of the object
NVARCHAR(64)Caption
Not Standard; the capability (32 and 64 bits) of this
operating system
NVARCHAR(64)dc_OperatingSystemCapability
Not standard; a string describing the operating
system type (This can involve interpretation and not
strictly reflect the value of OCType.)
NVARCHAR(256)dc_OSType
Not standard; derived from CIM_InstalledOSBoolean
indicating that the OS is the default for the Computer
System
bitdc_PrimaryOS
Not standard; CSD version/Service Pack level of OS
from Windows systems
NVARCHAR(256)Win32_CSDVersion
Not standard. Name identifying the swap space.NVARCHAR(256)dc_SwapSpaceName
Not standard; type description of swap spaceNVARCHAR(64)dc_SwapType
Not standard. Minimum size of swap spaceBIGINTdc_SwapSpaceMinimumSize
Not standard; maximum size of swap spaceBIGINTdc_SwapSpaceMaximumSize
Not standard; reserved size of swap spaceBIGINTdc_SwapSpaceReservedSize
CIM_PhysicalElement table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTPhysicalElement_LUID
Node partly identifies CIM_PhysicalElementBIGINTNodeID
Snapshot partly identifies CIM_PhysicalElementBIGINTSnapshotID
CreationClassName partly identifies
CIM_PhysicalElement; equates to
CIM_PhyscialElement
NVARCHAR(256)CreationClassName
Tag partly identifies CIM_PhysicalElement; an
arbitrary string that uniquely identifies the Physical
NVARCHAR(256)Tag
Element and serves as the Element's key and can
contain information such as asset tag or serial
number data
Database tables 27