HP Systems Insight Manager 7.1 Database Tables

CIM_ComputerSystem table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTComputerSystem_LUID
Partly identifies CIM_ComputerSystemBIGINTNodeID
Partly identifies CIM_ComputerSystemBIGINTSnapshotID
The inherited Name serves as key of a System
instance in an enterprise environment
NVARCHAR(256)Name
CreationClassName indicates the name of the class
or the subclass used in the creation of an instance
NVARCHAR(256)CreationClassName
(When used with the other key properties of this
class, this property allows all instances of this class
and its subclasses to be uniquely identified.)
The Description property provides a textual
description of the object
NVARCHAR(512)Description
The Caption property is a short textual description
(one- line string) of the object
NVARCHAR(64)Caption
Inherited from CIM_ManagedSystemElement.Status
and is a string indicating the current status of the
object
NVARCHAR(10)Status
A string that provides information on how the primary
system owner can be reached
NVARCHAR(256)PrimaryOwnerContact
The name of the primary system ownerNVARCHAR(64)PrimaryOwnerName
Not standard, based on CIM_Person.Pager and
includes pager information for the primary owner
NVARCHAR(32)dc_PrimaryOwnerPager
Not standard and includes information describing
the physical location of this system
NVARCHAR(256)dc_SystemLocation
Not standard and is the hardware capability (32
and 64 bits) of the system
NVARCHAR(64)dc_HardwareCapability
A field used by reportingNVARCHAR(50)R_OverallStatus
A field used by reportingNVARCHAR(256)R_ProductType
Domain of this systemNVARCHAR(256)Domain
A user friendly name for this elementNVARCHAR(256)Elementname
Defines how the Name is generatedNVARCHAR(64)NameFormat
For Non-Stop systems, date of system releaseNVARCHAR(256)ReleaseDate
A field used by ReportingNVARCHAR(256)R_OperationalStatus
A field used by ReportingINTR_PortCount
A field used by ReportingINTR_PortUtilized
A field used by ReportingNVARCHAR 2-256R_PRODIDENTIFYINGNUMBER
CIM_ComputerSystemPackage table
DescriptionData TypeColumn Name
A field used by reportingBIGINTAntecedent
A field used by reportingBIGINTDependent
14 HP SIM database tables