Cim_controlledby table, Cim_devicesapimplementation table, Cim_devicesoftwareidentity table – HP Systems Insight Manager User Manual
Page 587: Cim_elementcapabilities table, Cim_fan table
Description
Data Type
Column Name
Not standard and is the hardware capability (32 and 64
bits) of the system
NVARCHAR(64)
dc_HardwareCapability
A field used by reporting
NVARCHAR(50)
R_OverallStatus
A field used by reporting
NVARCHAR(256)
R_ProductType
Domain of this system
NVARCHAR(256)
Domain
A user friendly name for this element
NVARCHAR(256)
Elementname
Defines how the Name is generated
NVARCHAR(64)
NameFormat
For Non-Stop systems, date of system release
NVARCHAR(256)
ReleaseDate
A field used by Reporting
NVARCHAR(256)
R_OperationalStatus
A field used by Reporting
INT
R_PortCount
A field used by Reporting
INT
R_PortUtilized
CIM_ControlledBy table
Description
Data Type
Column Name
The controlled Device
BIGINT
Dependent
The controller
BIGINT
Antecedent
CIM_DeviceSAPImplementation table
Description
Data Type
Column Name
Used for reporting purposes
BIGINT
deviceSAPImplementation _LUID
Partly identifies CIM_DeviceSAPImplementation
BIGINT
NodeID
Partly identifies CIM_DeviceSAPImplementation
BIGINT
SnapshotID
The ServiceAccessPoint implemented using the LogicalDevice
BIGINT
Dependent
The LogicalDevice
BIGINT
Antecedent
Used for reporting purposes
NVARCHAR(256)
dc_PermanentAddress
CIM_DeviceSoftwareIdentity table
Description
Data Type
Column Name
Used for reporting purposes
BIGINT
System
Used for reporting purposes
BIGINT
InstalledSoftware
CIM_ElementCapabilities table
Description
Data Type
Column Name
The managed element
BIGINT
Dependent
The Capabilities object associated with the element
BIGINT
Antecedent
CIM_Fan table
Description
Data Type
Column Name
LUID uniquely defining this table row
BIGINT
Fan_LUID
Partly identifies CIM_Fan
BIGINT
NodeID
Database tables 587