HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
other identifying information to uniquely name the
Logical Device
Name partly identifies CIM_Processor; a label by
which the object is known
NVARCHAR(256)Name
Equates to CIM_ComputerSystem.NVARCHAR(256)SystemCreationClassName
The value of CIM_ComputerSystem.Name where
NodeID is equal
NVARCHAR(256)SystemName
The Processor Family Type. CIM_Processor.Family
enumeration (1 = Other, 2 = Unknown, 3 = 8086,
SMALLINTFamily
4 = 80286, 5 = 80386, 6 = 80486, 7 = 8087, 8
= 80287, 9 = 80387, 10= 80487, 11 = Intel®
Pentium® brand, 12 = Pentium® Pro, 13 =Pentium®
II, 14 = Pentium® processor with MMX™ technology,
15 = Celeron®, 16 = Pentium® II Xeon™, 17 =
Pentium® III, 18 = M1 Family, 19 = M2 Family, 24
= K5 Family, 25 = K6 Family, 26 = K6-2, 27 = K6-3,
28 = AMD Athlon Processor Family, 29 = AMD
Duron Processor, 30 = AMD29000 Family, 31 =
K6-2+, 32 = Power PC Family, 33 = Power PC 601,
34 = Power PC 603, 35 = Power PC 603+, 36 =
Power PC 604, 37 = Power PC 620, 38 = Power
PC X704, 39 = Power PC 750, 48 = Alpha Family,
49 = Alpha 21064, 50 = Alpha 21066, 51 = Alpha
21164, 52 = Alpha 21164PC, 53 = Alpha 21164a,
54 = Alpha 21264, 55 = Alpha 21364, 64 = MIPS
Family, 65 = MIPS R4000, 66 = MIPS R4200, 67
= MIPS R4400, 68 = MIPS R4600, 69 = MIPS
R10000, 80 = SPARC Family, 81 = SuperSPARC,
82 = microSPARC, 83 = microSPARC IIep, 84 =
UltraSPARC, 85 = UltraSPARC II, 86 = UltraSPARC
IIi, 87 = UltraSPARC III, 88 = UltraSPARC IIIi, 96 =
68040, 97 = 68xxx Family, 98 = 68000, 99 =
68010, 100 = 68020, 101 = 68030, 112 = Hobbit
Family, 120 = Crusoe TM5000 Family, 121 =
Crusoe TM3000 Family, 128 = Weitek, 130 = Intel®
Itanium® Processor, 144 = PA-RISC Family, 145 =
PA-RISC 8500, 146 = PA-RISC 8000, 147 = PA-RISC
7300LC, 148 = PA-RISC 7200, 149 = PA-RISC
7100LC, 150 = PA-RISC 7100, 160 = V30 Family,
176 = Pentium® III Xeon™, 177 = Pentium® III
Processor with Intel® SpeedStep Technology, 178
= Pentium® 4, 179 = Intel® Xeon™, 180 = AS400
Family, 181 = Intel Xeon processor MP, 190 = K7,
200 = Intel® Xeon™ processor MP, 201 = G4, 202
= G5, 250 = i860, 251 = i960, 260 = SH-3, 261
= SH-4, 280 = ARM, 281 = StrongARM, 300 =
6x86, 301 = MediaGX, 302 = MII, 320 = WinChip,
350 = DSP, 500 = Video Processor)
The current speed (in MHz) of this ProcessorINTCurrentClockSpeed
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
Database tables 37