beautypg.com

Cim_logicaldevice table, Cim_logicaldisk table, Cim_logicaldevice table cim_logicaldisk table – HP Systems Insight Manager User Manual

Page 591

background image

CIM_LogicalDevice table

Description

Data Type

Column Name

LUID uniquely defining this table row

BIGINT

LogicalDevice_LUID

Partly identifies CIM_LogicalDevice

BIGINT

NodeID

Partly identifies CIM_LogicalDevice

BIGINT

SnapshotID

An address or other identifying information to uniquely
name the Logical Device

NVARCHAR(64)

DeviceID

CreationClassName partly identifies CIM_LogicalDevice
and equates to CIM_LogicalDevice

NVARCHAR(256)

CreationClassName

SystemCreationClassName partly identifies
CIM_LogicalDevice and equates to CIM_ComputerSystem

NVARCHAR(256)

ServiceCreationClassName

SystemName partly identifies CIM_LogicalDevice and is
the value of CIM_ComputerSystem.Name with equal
NodeID

NVARCHAR(256)

SystemName

A label by which the object is known

NVARCHAR(256)

Name

Inherited from CIM_ManagedElement.Caption and is a
short textual description (one line string) of the object

NVARCHAR(64)

Caption

A textual description of the object

NVARCHAR(512)

Description

The primary availability and status of the system and is an
enumeration. (1 = Other, 2 = Unknown, 3 = 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)

SMALLINT

Availability

Captures the last error code reported by the Logical Device

INT

LastErrorCode

Not standard and is the hardware type for this system

NVARCHAR(64)

dc_HardwareType

Captures additional data, beyond DeviceID information,
that 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.

NVARCHAR(256)

OtherIdentifyingInfo

Not standard and the associated driver for this system

NVARCHAR(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

Description

Data Type

Column Name

LUID uniquely defining this table row

BIGINT

LogicalDisk_LUID

Partly identifies CIM_LogicalDisk

INT

NodeID

Partly identifies CIM_LogicalDisk

INT

Snapshot

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_LogicalDisk

NVARCHAR(256)

CreationClassName

Equates to CIM_ComputerSystem

NVARCHAR(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

BIGINT

Win32_FreeSpace

Database tables 591