HP Systems Insight Manager 7.1 Database Tables

DescriptionData TypeColumn Name
could be used to identify a LogicalDevice. One
example would be to hold the Operating System
user-friendly name for the Device in this property.)
Inherited from
CIM_LogicalDevice.TotalPowerOnHours and is the
BIGINTTotalPowerOnHours
total number of hours that this Device has been
powered
Defines units relative to its use in the property,
MaxUnitsBeforeCleaning; describes the criteria used
NVARCHAR(256)UnitsDescription
to determine when the MediaAccessDevice should
be cleaned
Indicates the MediaAccessDevice needs cleaningBITNeedsCleaning
Inherited from CIM_ManagedSystemElement.Status;
a string indicating the current status of the object
NVARCHAR(10)Status
Corresponds to
MediaAccessStatInfo_UnrecoverableWriteOperations.
INTMAStatInf_UnrecoverableWriteOp
CIM_MediaAccessStatInfo.UnrecoverableWriteOperations;
the number of unrecoverable write operations
Corresponds to
MediaAccessStatInfo_UnrecoverableReadOperations.
INTMAStatInf_UnrecoverableReadOp
CIM_MediaAccessStatInfo.UnrecoverableReadOperations;
the number of unrecoverable read operations
Holds the fault-tolerant RAID seting for a logical drive
on a RAID controller (Possible statues include Not
NVARCHAR(64)dc_RaidLevel
enabled, RAID Level 0, RAID Level 1, RAID Level 0
+ 1, Mirroring, Data Guard, Distributed Data Guard
(RAID 5), Advanced Data Guarding, RAID Level 4,
RAID Level 5)
Not standard; a string describing the type of media
used to access the system
NVARCHAR(64)dc_Type
Not standard. Compaq ATA Disk Transfer Mode
(othe, pioMode0, pioMode1, pioMode2, pioMode3,
NVARCHAR(64)dc_TransferMode
pioMode4, dmaMode0, dmaMode1, dmaMode2,
ultraDmaMode0, ultraDmaMode1, ultraDmaMode2,
ultraDmaMode3, ultraDmaMode4, ultraDmaMode5)
A field used by reportingNVARCHAR(256)R_DrivePort
A field used by reportingNVARCHAR(64)R_Type
CIM_MemberOfCollection table
DescriptionData TypeColumn Name
Used for reporting purposesBIGINTCollection
Used for reporting purposesBIGINTMember
CIM_NetworkAdapter table
DescriptionData TypeColumn Name
LUID uniquely defining this table rowBIGINTNetworkAdapter_LUID
Partly identifies CIM_NetworkAdapterBIGINTNodeID
22 HP SIM database tables