HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
Not standard and is the percent of file system space
currently in use
INTdc_PercentSpaceUsed
Size in bytes of a block on the logical disk.BIGINTBlockSize
Number of storage block in the logical disk; size in
bytes can be calculated from BlockSize *
NumberOfBlocks.
BIGINTNumberOfBlocks
CIM_LogicalPortGroup table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTLogicalPortGroup_LUID
Partly identifies CIM_LogicalPortGroupBIGINTNodeID
Partly identifies CIM_LogicalPortGroupBIGINTSnapshot
Used for reporting purposesNVARCHAR(255)InstanceID
A label by which the object is knownNVARCHAR(256)Name
Used for reporting purposesNVARCHAR(64)NameFormat
Used for reporting purposesNVARCHAR(255)ElementName
CIM_MediaAccessDevice table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTMediaAccessDevice_LUID
Partly identifies CIM_MediaAccessDeviceBIGINTNodeID
Partly identifies CIM_MediaAccessDeviceBIGINTSnapshotID
Inherited from CIM_LogicalDevice.DeviceID and is
an address or other identifying information to
uniquely name the Logical Device
NVARCHAR(64)DeviceID
Equates to CIM_MediaAccessDeviceNVARCHAR(256)CreationClassName
Equates to CIM_ComputerSystemNVARCHAR(256)SystemCreationClassName
The value of CIM_ComputerSystem.Name for this
NodeID
NVARCHAR(256)SystemName
A label by which the object is knownNVARCHAR(256)Name
A textual description of the objectNVARCHAR(512)Description
Maximum size, in KB, of media supported by this
system. (KB is interpreted as the number of bytes X
1000 not bytes X 1024)
BIGINTMaxMediaSize
An unsigned integer indicating the currently used
units of the AccessDevice, helpful to describe when
BIGINTUnitsUsed
the system might require cleaning (The property
UnitsDescription, defines how units should be
interpreted)
Default block size, in bytesBIGINTDefaultBlockSize
Inherited from
CIM_LogicalDevice.OtherIdentifyingInfo (Captures
NVARCHAR(256)OtherIdentifyingInfo
additional data, beyond DeviceID information, that
Database tables 21