HP Systems Insight Manager - Manual (Page 596)

Description Data Type Column Name
Used for reporting purposes BIGINT DeviceID
Used for reporting purposes BIGINT Speed
Used for reporting purposes BIGINT MaxSpeed
Used for reporting purposes SmallInt UsageRestriction
Used for reporting purposes SMALLINT PortType
Used for reporting purposes NVARCHAR(255) OtherPortType
Used for reporting purposes SMALLINT LinkTechnology
Used for reporting purposes NVARCHAR(255) OtherLinkTechnology
Used for reporting purposes NVARCHAR(64) PermanentAddress
Used for reporting purposes SMALLINT PortNumber
Used for reporting purposes NVARCHAR(256) R_OperationalStatus
Used for reporting purposes NVARCHAR(256) R_ParentName
Used for reporting purposes NVARCHAR(256) R_PortType
CIM_OperatingSystem table
Description Data Type Column Name
LUID uniquely defining this table row BIGINT OperatingSystem_LUID
Partly identifies CIM_OperatingSystem BIGINT NodeID
Partly identifies CIM_OperatingSystem BIGINT SnapshotID
Equates to CIM_ComputerSystem. NVARCHAR(256) CSCreationClassName
The value of CIM_ComputerSystem.Name for this NodeID NVARCHAR(256) CSName
Equates to CIM_OperatingSystem. NVARCHAR(256) CreationClassName
The inherited Name serves as key of an operating system
instance within a computer system NVARCHAR(256) Name
Time when the OperatingSystem was last booted BIGINT LastBootupTime
OperatingSystem notion of the local date and time of day BIGINT LocalDateTime
A string describing the OperatingSystem version number
(The format of the version information is as follows: <Major
Number>..<Minor Number>.<Revision> or <Major
Number>.<Minor Number>.<Revision Letter>) NVARCHAR(64) Version
Inherited from CIM_ManagedElement.Description; a textual
description of an object NVARCHAR(512) Description
596 Reference information