HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
A textual description of the objectNVARCHAR(512)Description
The primary availability and status of the system and
is an enumeration. (1 = Other, 2 = Unknown, 3 =
SMALLINTAvailability
Running/Full Power, 4 = Warning, 5 = In Test, 6 =
Not Applicable, 7 = Power Off, 8 = Off Line, 9 =
Off Duty, 10 = Degraded, 11 = Not Installed, 12 =
Install Error, 13 = Power Save, Unknown, 14 =
Power Save, Low Power Mode, 15 = Power Save,
Standby, 16 = Power Cycle, 17 = Power Save,
Warning, 18 = Paused, 19 = Not Ready, 20 = Not
Configured, 21 = Quiesced)
Captures the last error code reported by the Logical
Device
INTLastErrorCode
Not standard and is the hardware type for this systemNVARCHAR(64)dc_HardwareType
Captures additional data, beyond DeviceID
information, that could be used to identify a
NVARCHAR(256)OtherIdentifyingInfo
LogicalDevice. One example would be to hold the
Operating System user friendly name for the Device
in this property.
Not standard and the associated driver for this systemNVARCHAR(64)dc_AssociatedDriver
A numerical string of hardware components, notated
sequentially from the bus address to the device
address. For example, 0/2/0/0.
NVARCHAR(64)HardwarePath
CIM_LogicalDisk table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTLogicalDisk_LUID
Partly identifies CIM_LogicalDiskINTNodeID
Partly identifies CIM_LogicalDiskINTSnapshot
Inherited from CIM_LogicalDevice.DeviceID and is
an address or other identifying information to
uniquely name the Logical Device
NVARCHAR(256)DeviceID
Equates to CIM_LogicalDiskNVARCHAR(256)CreationClassName
Equates to CIM_ComputerSystemNVARCHAR(256)SystemCreationClassName
The value of CIM_ComputerSystem.Name with equal
NodeID
NVARCHAR(256)SystemName
Derived from Win32_LogicalDisk and is the total
amount of free space in bytes
BIGINTWin32_FreeSpace
Derived from Win32_LogcialDisk and is the total size
in bytes; if unkown, enter 0. Units (bytes)
BIGINTWin32_Size
A textual description of the objectNVARCHAR(512)Description
A field used by reportingNVARCHAR(256)R_SizeMB
A field used by reportingNVARCHAR(256)R_UsedMB
A field used by reportingNVARCHAR(256)R_UsedPercent
Not standard and is the file system space currently
in use in bytes
BIGINTdc_SpaceUsed
20 HP SIM database tables