HP Systems Insight Manager 7.2 Database Tables

DescriptionData TypeColumn Name
serves as the Element's key and can contain
information such as asset tag or serial number data
The type of physical memory
(CIM_PhysicalMemory.MemoryType Enumeration. 0
SMALLINTMemoryType
= Unknown, 1 = Other, 2 = DRAM, 3 = Synchronous
DRAM, 4 = Cache DRAM, 5 = EDO, 6 = EDRAM,
7 = VRAM, 8 = SRAM, 9 = RAM, 10 = ROM, 11 =
Flash, 12 = EEPROM, 13 = FEPROM, 14 = EPROM,
15 = CDRAM, 16 = 3DRAM, 17 = SDRAM, 18 =
SGRAM, 19 = RDRAM, 20 = DDR)
The total capacity of this PhysicalMemory in bytesBIGINTCapacity
A field used by reportingNVARCHAR(256)R_MemoryType
A field used by reportingNVARCHAR(256)R_MemoryTech
Derived from CIM_Chip (The implementation form
factor for the Chip. CIM_PhysicalMemory.FormFactor
SMALLINTFormFactor
enumeration. 0 = Unknown, 1 = Other, 2 = SIP, 3
= DIP, 4 = ZIP, 5 = SOJ, 6 = Proprietary, 7 = SIMM,
8 = DIMM, 9 = TSOP, 10 = PGA, 11 = RIMM, 12
= SODIMM, 13 = SRIMM, 14 = SMD, 15 = SSMP,
16 = QFP, 17 = TQFP, 18 = SOIC, 19 = LCC, 20
= PLCC, 21 = BGA, 22 = FPBGA, 23 = LGA)
The part number assigned by the organization
responsible for producing or manufacturing the
Physical Element
NVARCHAR(256)PartNumber
A manufacturer-allocated number used to identify the
Physical Element
NVARCHAR(64)SerialNumber
Not standard; the main error correction scheme
supported by this memory component
NVARCHAR(512)dc_ErrorMethodology
Not standard; a text description of the hardware
location, on complex multi-SBB hardware only, for
the memory element
NVARCHAR(256)dc_HWLocation
A field used by reportingSMALLINTR_Slot
Description of the elementNVARCHAR(64)Description
Memory bank designatornvarchar(64)BankLabel
Speed
manufacturer
TotalWidth
Location identifiers for memory on boardsnvarchar(255)MemLoc_LocationIdentifiers
Maximum frequencyNVARCHAR(256)MaxFrequency
Minimum voltage needed to operateNVARCHAR(256)MinVoltage
Indicates DIMM is updated with SmartMemroy
(DIMM with SmartMemory or DIMMS without
SmartMemory)
NVARCHAR(64)SmartMemory
Indicates rankNVARCHAR(64)Ranks
Good memory and not good memory (missing, not
present, degraded, and so on)
NVARCHAR(64)MemoryStatus
Database tables 31