HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
A globally unique identifier for the processor (This
identifier might only be unique within a processor
family.)
NVARCHAR(256)UniqueID
Loading of this processor, averaged over the last
minute in percent
SMALLINTLoadPercentage
The CPUStatus property indicates the current status
of the processor (For example, it might be disabled
SMALLINTCPUStatus
by the user through BIOS (value=2), or disabled
because of a POST error (value=3). Information in
this property can be obtained from SMBIOS, the
Type 4 structure, the Status attribute.
CIM_Processor.CPUStatus Enumeration. (0 =
Unknown, 1 = CPU, 2 = CPU disabled by user
through BIOS setup, 3 = CPU disabled by BIOS
(POST error), CPU Is Idle, Other)
Inherited from
CIM_LogicalDevice.OtherIdentifyingInfo.OtherIdentifyingInfo
NVARCHAR(64)OtherIdentifyingInfo
captures additional data, beyond DeviceID
information, that could be used to identify a
LogicalDevice (One example would be the socket
and slot information for this processor.)
A field used by reportingNVARCHAR(256)R_CPUType
A field used by reportingNVARCHAR(256)R_CPUSpeed
A field used by reportingNVARCHAR(256)R_CPUStatus
Not standard; a text description of the hardware
location, on complex multi-SBB hardware only for
the processor
NVARCHAR(256)dc_HWLocation
Architecture revision of the processorSMALLINTArchitectureRevision
Firmware revision of the processorNVARCHAR(255)FirmwareRevision
Width of the processor datapath in bitsSMALLINTDataWidth
Cell in the complex containing this processor (Cellular
systems only)
NVARCHAR(255)ProcessorLocation_CellNumber
OperationalStatus
Tag
CIM_Product table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTProduct_LUID
Node partly identifies CIM_ProductBIGINTNodeID
Snapshot partly identifies CIM_ProductBIGINTSnapshotID
Used for reporting purposesNVARCHAR(255)Elementname
A label by which the object is knownNVARCHAR(256)Name
Product identificationNVARCHAR(64)IdentifyingNumber
38 HP SIM database tables