HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
ActiveCooling is a boolean indicating that the
Cooling Device provides active (as opposed to
passive) cooling
BITActiveCooling
An enumeration describing the cooling device type
(0 = Unknown , 1 = Other , 2 = Cabinet Blower , 3
SMALLINTFanType
= Compute Cabinet I/O Fans , 4 = I/O Expansion
Cabinet Utility Chassis Fan , 5 = I/O Expansion
Cabinet I/O Fan , 6 = Processor Fan )
Physical location of a cooling device.NVCHAR(255)Location
Currently a placeholder. When implemented, this
will reflect the manufacturer of the fan.
NVCHAR(255)Manufacturer
Position is a free-form string indicating the placement
of a PhysicalElement. It can specify slot information
NVCHAR(255)PhysicalPosition
on a HostingBoard, mounting site in a Cabinet, or
latitude and longitude information, for example, from
a GPS. It is part of the key of the Location object.
Partly identifies CIM_FanNVCHAR(255)Tag
Currently a placeholder. When implemented will
reflect the serial number of the fan.
NVCHAR(255)SerialNumber
Currently a placeholder. When implemented will
reflect the version number of the fan.
NVCHAR(255)Version
A label by which the object is knownNVCHAR(255)Name
New column added to hold fan physical positionSmallintR_PhysicalPosition
Redundancy nameNVCHAR(255)RedundancyName
Redundancy statusNVCHAR(255)RedundancyStatus
CIM_FileSystem table
DescriptionData TypeColumn Name
bigintFileSystem_LUID
bigintNodeID
bigintSnapshotID
nvarchar(256)Name
nvarchar(256)CreationClassName
nvarchar(256)CSCreationClassName
nvarchar(256)CSName
bigintFileSystemSize
bigintAvailableSpace
nvarchar(512)Description
nvarchar(256)R_SizeMB
nvarchar(256)R_UsedMB
nvarchar(256)R_UsedPercent
16 HP SIM database tables