Using Default Tools - Database Tables

HP Systems Insight Manager uses a Microsoft SQL (Windows install) or PostgreSQL (HP-UX or Linux install) database to store collected event and system data. The database can be on the same system as the management application or on a different system that has network access to the database server. HP Systems Insight Manager uses the Java Database Connector (JDBC) and the Object Database Connector (ODBC) on Microsoft Windows systems to communicate with the database.

During installation, the necessary database systems and transaction log systems are created before creating and populating the database.

Reports can be created in Access, Excel, Crystal Reports, or any standard reporting tool that can access the database. The database schema is published to make creating the reports easier.

There are several pre-defined views that are shipped with HP Systems Insight Manager. These views can be used to search the database for different information such as data collection information, event data and license data.

Notices_view. This view can be used to list events in the system along with their descriptions. It does not contain the specifics of an event, but can be useful for some simple reports. It will return the system name, event severity, cleared status, received time, cleared time, and event description.

View_deviceAssociations. This view is used in building searches, mainly used internally.

licenseCounts. This view is used to show license count data in the license report.

deviceTypesEnum. This view links the devices table productType field with an (English) string representing the system type.

deviceSubTypesEnum. This view links the nodeSubTypesEnum table enumOrd field with an (English) string representing the system sub type.

The following sections provide the contents of the database for reporting purposes. The tables describe the information collected by HP Systems Insight Manager and the database table structures that store the information. The following tables are available:

CIM_Chassis table	CIM_ComputerSystem table	CIM_IPRoute table
CIM_LogicalDevice table	CIM_LogicalDisk table	CIM_MediaAccess table
CIM_NetworkAdapter table	CIM_OperatingSystem table	CIM_PhysicalElement table
CIM_PhysicalMedia table	CIM_PhysicalMemory table	CIM_PowerSupply table
CIM_Process table	CIM_Processor table	CIM_Rack table
CIM_Sensor table	CIM_SoftwareElement table	ClusterInfo table
ClusterNodeInfo table	DB_DeviceInfo table	DB_DeviceInfoEx table
dc_ProliantHost table	DeviceNames table	Devices table
DeviceProtocolInfo table	NodeTypesEnum table	NodeTypesSubEnum table
DeviceSnmpSettings table	HPUX_BaseKernelParameter table	HPUX_Bundle table
HPUX_DNSService table	HPUX_Fileset table	HPUX_HFS table
HPUX_LogicalVolume table	HPUX_NISServerService table	HPUX_NTPService table
HPUX_PhysicalVolume table	HPUX_Product table	HPUX_VolumeGroup table
IPAddress table	IPXAddress table	NodeSnapshot table
notices table	noticeTypes table	Snapshot table

Column Name	Data Type	Description
Chassis_LUID	BIGINT	LUID uniquely defining this row
NodeID	BIGINT	Partly identifies CIM_Chassis
SnapshotID	BIGINT	Partly identifies CIM_Chassis
CreationClassName	NVARCHAR(256)	Partly identifies CIM_Chassis equates to CIM_Chassis
Tag	NVARCHAR(256)	An arbitrary string that uniquely identifies the Physical Element and serves as the Element key, and can contain information such as asset tag or serial number data
dc_SystemCreationClassName	NVARCHAR(256)	If the chassis is part of a rack then this attribute is CIM_Rack, otherwise CIM_ComputerSystem
dc_SystemName	NVARCHAR(256)	If the chassis is part of a rack then this attribute is the value of CIM_Rack.Name, otherwise the value of the owning CIM_ComputerSystem.Name
Name	NVARCHAR(256)	A label by which the object is known
Width	real	Inherited from CIM_PhysicalPackage.Width, and is the width of the Physical Package in inches
Height	real	Inherited from CIM_PhysicalPackage.Height, and is the height of the Physical Package in inches
Depth	real	Inherited from CIM_PhysicalPackage.Depth, and is the depth of the Physical Package in inches
SerialNumber	NVARCHAR(64)	Inherited from CIM_PhysicalElement.SerialNumber, and is a manufacturer-allocated number used to identify the Physical Element
PartNumber	NVARCHAR(256)	Inherited from CIM_PhysicalElement.PartNumber, and is the part number assigned by the organization responsible for producing or manufacturing the Physical Element
SKU	NVARCHAR(64)	Inherited from CIM_PhysicalElement.SKU, and is the stock keeping unit number for this Physical Element
Model	NVARCHAR(64)	Inherited from CIM_PhysicalElement.Model, and is the name by which the Physical Element is generally known
ChassisTypes	SMALLINT	An enumeration of CIM_ChassisTypes 1 = Other 2 = Unknown 3 = Desktop 4 = Low Profile Desktop 5 = Pizza Box 6 = Mini Tower 7 = Tower 8 = Portable 9 = Laptop 10 = Notebook 11 = Hand Held 12 = Docking Station 13 = All in One 14 = Sub Notebook 15 = Space Saving 16 = Lunch Box 17 = Main System Chassis 18 = Expansion Chassis 19 = SubChassis 20 = Bus Expansion Chassis 21 = Peripheral Chassis 22 = Storage Chassis 23 = Rack Mount Chassis 24 = Sealed-Case PC
TypeDescriptions	NVARCHAR(512)	Additional information about the CIM_Chassis.ChassisTypes
Version	NVARCHAR(64	Inherited from CIM_PhysicalElement.Version, and is a string indicating the version of the PhysicalElement
OtherIdentifyingInfo	NVARCHAR(512)	Inherited from CIM_PhysicalElement.OtherIdentifyingInfo. Captures additional data, beyond that of Tag information, that could be used to identify a Physical Element. One example is bar code data associated with an Element that also has an asset tag. Note that if only bar code data is available and is uniqueable to be used as an Element key, this property would be NULL and the bar code data used as the class key, in the Tag property.
R_Model	nvarchar(256)	A field used by reporting

Column Name	Data Type	Description
ComputerSystem_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Partly identifies CIM_ComputerSystem
SnapshotID	BIGINT	Partly identifies CIM_ComputerSystem
Name	NVARCHAR(256)	Serves as key of a System instance in an enterprise environment
CreationClassName	NVARCHAR(256)	Partly identifies CIM_ComputerSystem, and equates to CIM_ComputerSystem
Description	NVARCHAR(512)	Inherited from CIM_ManagedElement.Description, and is a textual description of an object
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption, and is a short textual description (one line string) of the object
Status	NVARCHAR(10)	Inherited from CIM_ManagedSystemElement.Status, and is a string indicating the current status of the object
PrimaryOwnerContact	NVARCHAR(256)	A string that provides information on how the primary system owner can be reached
PrimaryOwnerName	NVARCHAR(64)	The name of the primary system owner
dc_PrimaryOwnerPager	NVARCHAR(32)	Not standard, based on CIM_Person.Pager, and includes pager information for the primary owner
dc_SystemLocation	NVARCHAR(256)	Not standard, and includes information describing the physical location of this system
dc_HardwareCapability	NVARCHAR(64)	Not standard, and is the hardware capability (32 and 64 bits) of the system
R_OverallStatus	NVARCHAR(50)	A field used by reporting
R_ProductType	NVARCHAR(256)	A field used by reporting

Column Name	Data Type	Description
IPRoute_LUID	BIGINT
LUID uniquely defining this table row	BIGINT	Partly identifies CIM_IPRoute
SnapshotID	BIGINT	Partly identifies CIM_IPRoute
CreationClassName	NVARCHAR(256)	Equates to CIM_IPRoute
ServiceCreationClassName	NVARCHAR(256)	For future use
ServiceName	NVARCHAR(256)	For future use
SystemCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem
SystemName	NVARCHAR(256)	The value of CIM_ComputerSystem.Name with equal NodeID
IPDestinationAddress	NVARCHAR(256)
IPDestinationMask	NVARCHAR(256)	The IP address that serves as the destination of the traffic, formatted according to the appropriate convention as defined in the AddressType property of this class. This property has the same semantics as DestinationAddress inherited from the NextHopRouting superclass but uses a different property name because this property and class were defined before NextHopRouting and are Key properties. They cannot be removed. ModelCorrespondence indicates that they should be set to equivalent values for consistency and ease of searching.
AddressType	SMALLINT	An enumeration that describes the format of the address property. Addresses that can be formatted in IPv4 format must be formatted that way to ensure mixed IPv4/IPv6 support. AddressType is part of the key so that an IPv4 and an IPv6 route to IP subnets with the same network number but different versions (v4/v6) can coexist. (0, Unknown; 2, IPv4; 2 IPv6).
IsStatic	bit	True indicates that this is a static route, and False indicates a dynamically-learned route
NextHop	NVARCHAR(256)	Contains either the address of the next-hop router, or the interface used to reach the destination
	NVARCHAR(32)	Not standard, and is the gateways to the route destination. (Unknown, Local, Remote).
dc_RouteArgument	NVARCHAR(1024)	Not standard, and is the argument list for the `/usr/sbin/route` command

Column Name	Data Type	Description
LogicalDevice_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Partly identifies CIM_IPRoute
SnapshotID	BIGINT	Partly identifies CIM_IPRoute
DeviceID	NVARCHAR(64)	An address or other identifying information to uniquely name the Logical Device
CreationClassName	NVARCHAR(256)	CreationClassName partly identifies CIM_LogicalDevice and equates to CIM_LogicalDevice
ServiceCreationClassName	NVARCHAR(256)	SystemCreationClassName partly identifies CIM_LogicalDevice and equates to CIM_ComputerSystem
SystemName	NVARCHAR(256)	SystemName partly identifies CIM_LogicalDevice, and is the value of CIM_ComputerSystem.Name with equal NodeID
Name	NVARCHAR(256)	A label by which the object is known
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption, and is a short textual description (one line string) of the object
Description	NVARCHAR(512)	A textual description of the object
Availability	SMALLINT	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
LastErrorCode	INT	Captures the last error code reported by the Logical Device
dc_HardwareType	NVARCHAR(64)	Not standard, and is the hardware type for this system
OtherIdentifyingInfo	NVARCHAR(256)	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.
dc_AssociatedDriver	NVARCHAR(64)	Not standard, and the associated driver for this system

Column Name	Data Type	Description
LogicalDisk_LUID	BIGINT	LUID uniquely defining this table row
NodeID	INT	Partly identifies CIM_LogicalDisk
Snapshot	INT	Partly identifies CIM_LogicalDisk
DeviceID	NVARCHAR(64)	Inherited from CIM_LogicalDevice.DeviceID, and is an address or other identifying information to uniquely name the Logical Device
CreationClassName	NVARCHAR(256)	Equates to CIM_LogicalDisk
SystemCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem
SystemName	NVARCHAR(256)	The value of CIM_ComputerSystem.Name with equal NodeID
Win32_FreeSpace	BIGINT	Derived from Win32_LogicalDisk, and is the total amount of free space in bytes
Win32_Size	BIGINT	Derived from Win32_LogcialDisk, and is the total size in bytes. If unkown, enter 0. Units (bytes).
Description	NVARCHAR(512)	A textual description of the object
R_SizeMB	NVARCHAR(256)	A field used by reporting
R_UsedMB	NVARCHAR(256)	A field used by reporting
R_UsedPercent	NVARCHAR(256)	A field used by reporting
dc_SpaceUsed	BIGINT	Not standard, and is the file system space currently in use in bytes
dc_PercentSpaceUsed	INT	Not standard, and is the percent of file system space currently in use

Column Name	Data Type	Description
MediaAccessDevice_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Partly identifies CIM_MediaAccessDevice
SnapshotID	BIGINT	Partly identifies CIM_MediaAccessDevice
DeviceID	NVARCHAR(64)	Inherited from CIM_LogicalDevice.DeviceID, and is an address or other identifying information to uniquely name the Logical Device
CreationClassName	NVARCHAR(256)	Equates to CIM_MediaAccessDevice
SystemCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem
SystemName	NVARCHAR(256)	The value of CIM_ComputerSystem.Name for this NodeID
Name	NVARCHAR(256)	A label by which the object is known
Description	NVARCHAR(512)	A textual description of the object
MaxMediaSize	BIGINT	Maximum size, in KB, of media supported by this system. KB is interpreted as the number of bytes X 1000 not bytes X 1024.
UnitsUsed	BIGINT	An unsigned integer indicating the currently used units of the AccessDevice, helpful to describe when the system might require cleaning. The property UnitsDescription, defines how units should be interpreted.
DefaultBlockSize	BIGINT	Default block size, in bytes. Units (bytes)
OtherIdentifyingInfo	NVARCHAR(256)	Inherited from CIM_LogicalDevice.OtherIdentifyingInfo. 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.
TotalPowerOnHours	BIGINT	Inherited from CIM_LogicalDevice.TotalPowerOnHours, and is the total number of hours that this Device has been powered.Units (Hours).
UnitsDescription	NVARCHAR(256)	Defines units relative to its use in the property, MaxUnitsBeforeCleaning. Describes the criteria used to determine when the MediaAccessDevice should be cleaned.
NeedsCleaning	BIT	Indicates the MediaAccessDevice needs cleaning.
Status	NVARCHAR(10)	Inherited from CIM_ManagedSystemElement.Status. A string indicating the current status of the object.
MAStatInf_UnrecoverableWriteOp	INT	Corresponds to MediaAccessStatInfo_UnrecoverableWriteOperations. CIM_MediaAccessStatInfo.UnrecoverableWriteOperations. The number of unrecoverable write operations.
MAStatInf_UnrecoverableReadOp	INT	Corresponds to MediaAccessStatInfo_UnrecoverableReadOperations. CIM_MediaAccessStatInfo.UnrecoverableReadOperations. The number of unrecoverable read operations.
dc_Type	NVARCHAR(64)	Not standard. A string describing the type of media used to access the system.
dc_TransferMode	NVARCHAR(64)	Not standard. Compaq ATA Disk Transfer Mode. other pioMode0 pioMode1 pioMode2 pioMode3 pioMode4 dmaMode0 dmaMode1 dmaMode2 ultraDmaMode0 ultraDmaMode1 ultraDmaMode2 ultraDmaMode3 ultraDmaMode4 ultraDmaMode5
R_DrivePort	nvarchar(256)	A field used by reporting.
R_Type	nvarchar(64)	A field used by reporting.

Column Name	Data Type	Description
NetworkAdapter_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Partly identifies CIM_NetworkAdapter.
SnapshotID	BIGINT	Partly identifies CIM_NetworkAdapter.
CreationClassName	NVARCHAR(256)	Equates to CIM_NetworkAdapter.
DeviceID	NVARCHAR(64)	Inherited from CIM_LogicalDevice.DeviceID. An address or other identifying information to uniquely name the Logical Device.
SystemCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem.
SystemName	NVARCHAR(256)	The value of CIM_ComputerSystem.Name for this NodeID.
Name	NVARCHAR(256)	A label by which the object is known.
NetworkAddress	NVARCHAR(64)	An array of strings indicating the network addresses for an adapter. Represented by a comma separated list.
StatusInfo	SMALLINT	Inherited from CIM_LogicalDevice.StatusInfo. The StatusInfo property indicates whether the Logical Device is in an enabled (value = 3), disabled (value = 4), other (value = 1), or unknown (value = 2) state. If this property does not apply to the LogicalDevice, the value 5 (Not Applicable), should be used. If a Device is Enabled (value=3), it has been powered up and is configured and operational. The system might not be functionally active, depending on whether its Availability (or AdditionalAvailability) indicate that it is Running/Full Power (value=3) or Off line (value=8). In an enabled but offline mode, a system might be performing out-of-band requests, such as running Diagnostics. If (\"Disabled\") StatusInfo value=4), a device can only be \"enabled\" or powered off. In a personal computer environment, (\"Disabled\") means that the system's driver is not vailable in the stack. In other environments, a system can be disabled by removing its configuration file. A disabled device is physically present in a system and consuming resources but cannot be communicated with until a load of a driver, a load of a configuration file, or some other \"enabling\" activity has occurred. CIM_LogicalDevice.StatusInfo Enumeration. 1 = Other 2 = Unknown 3 = Enabled 4 = Disabled 5 = Not Applicable
PermanentAddress	NVARCHAR(64)	PermanentAddress defines the network address hardcoded into an adapter. This hardcoded address can be changed through firmware upgrade or software configuration. If so, this field should be updated when the change is made. PermanentAddress should be left blank if no hardcoded address exists for the NetworkAdapter.
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption. A short textual description (one line string) of the object.
EthernetAdp_InternalMACRcvErr	INT	A count of frames for which reception on a particular interface fails because of an internal MAC sublayer receive error. A frame is only counted by an instance of this object if it is not counted by the corresponding instance of either the FrameTooLongs property, the AlignmentErrors property, or the FCSErrors property. The precise meaning of the count represented by and instance of this object is implementation-specific. In particular, an instance of this object can represent a count of receive errorrs on a particular interface that are not otherwise counted.
EthernetAdp_InternalMACTranErr	INT	A count of frames for which reception on a particular interface fails because of an internal MAC sublayer receive error. A frame is only counted by an instance of this object if it is not counted by the corresponding instance of either the LateCollisions property, the Excesssive Collisions property, or the CarrierSenseErrors property. The precise meaning of the count represented by and instance of this object is implementation-specific. In particular, an instance of this object can represent a count of transmission errorrs on a particular interface that are not otherwise counted.
FullDuplex	BIT	Boolean indicating that the adapter is operating in full duplex mode.
OctetsTransmitted	BIGINT	The total number of octets transmitted, including framing characters.
OctetsReceived	BIGINT	The total number of octets received, including framing characters.
MaxSpeed	BIGINT	The maximum speed, in bits per second, for the Network Adapter.
IPProtocolEndpoint_SubnetMask	NVARCHAR(64)	Derived from CIM_IPProtocolEndpoint.SubnetMask. The mask for the IP address of this ProtocolEndpoint, formatted according to the appropriate convention as defined in the AddressType property of this class.
dc_BroadcastAddress	NVARCHAR(64)	Not standard. This attribute is the broadcast address assigned to this interface in dot notation format.
dc_DHCPEnabled	NVARCHAR(32)	Not standard. This attribute indicates whether DHCP enabled or not.
R_InputErrors	NVARCHAR(256)	A field used by reporting.
R_OutputErrors	NVARCHAR(256)	A field used by reporting
R_Duplex	nvarchar(25)	A field used by reporting
R_MacAddress	nvarchar(64)	A field used by reporting

Column Name	Data Type	Description
OperatingSystem_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Partly identifies CIM_OperatingSystem.
SnapshotID	BIGINT	Partly identifies CIM_OperatingSystem.
CSCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem.
CSName	NVARCHAR(256)	The value of CIM_ComputerSystem.Name for this NodeID.
CreationClassName	NVARCHAR(256)	Equates to CIM_OperatingSystem.
Name	NVARCHAR(256)	The inherited Name serves as key of an operating system instance within a computer system.
LastBootupTime	BIGINT	Time when the OperatingSystem was last booted.
LocalDateTime	BIGINT	OperatingSystem notion of the local date and time of day.
Version	NVARCHAR(64)	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>.
Description	NVARCHAR(512)	Inherited from CIM_ManagedElement.Description. A textual description of an object.
OSType	SMALLINT	An integer indicating the type of Operating System. CIM_OSType enumeration. 0 = Unknown 1 = Other 2 = MACOS 3 = ATTUNIX 4 = DGUX 5 = DECNT 6 = Digital Unix 7 = OpenVMS 8 = HPUX 9 = AIX 10 = MVS 11 = OS400 12 = OS/2; 13 = JavaVM 14 = MSDOS 15 = WIN3x 16 = WIN95 17 = WIN98 18 = WINNT 19 = WINCE 20 = NCR3000 21 = NetWare 22 =OSF 23 = DC/OS 24 = Reliant UNIX 25 = SCO UnixWare 26 = SCO OpenServer 27 = Sequent 28 = IRIX 29 = Solaris 30 = SunOS 31 = U6000 32 = ASERIES 33 = TandemNSK 34 = TandemNT 35 = BS2000 36 = LINUX 37 = Lynx 38 = XENIX 39 = VM/ESA 40 = Interactive UNIX 41 = BSDUNIX 42 = FreeBSD 43 = NetBSD 44 = GNU Hurd 45 = OS9 46 = MACH Kernel 47 = Inferno 48 = QNX 49 = EPOC 50 = IxWorks 51 = VxWorks 52 = MiNT 53 = BeOS 54 = HP MPE 55 = NextStep 56 = PalmPilot 57 = Rhapsody 58 = Windows 2000 59 = Dedicated 60 = OS/390 61 = VSE 62 = TPF 63 = Windows (R) Me 64 = Caldera Open UNIX 65 = OpendBSD 66 = Not Applicable
NumberOfUsers	INT	Number of user sessions for which the operating system is currently storing state information.
NumberOfProcesses	INT	Number of process contexts currently loaded or running on the operating system.
MaxNumberOfProcesses	INT	Max number of process contexts the operating system can support. If no fixed value, then 0.
CurrentTimeZone	SMALLINT	Indicates the number of minutes the operating system is offset from GMT. Either the number is +,-,or 0. Units minutes.
TotalVisibleMemorySize	BIGINT	Amount of physical memory in KB available to operating system. Not necessarily true amount of physical memory but what is reported to the operating system as available. Units KB.
TotalSwapSpaceSize	BIGINT	Total swap space in Kb. Can be null if swap space is not distinguished from page files.
OtherTypeDescription	NVARCHAR(64)	A string describing the manufacturer and operating system type. Used when the OperatingSystem property, OSType, is set to 1 or 59 (Other or Dedicated). The format of the string inserted in OtherTypeDescription should be similar in format to the Values strings defined for OSType. OtherTypeDescription should be set to null when OSType is any value other than 1 or 59.
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption. A short textual description (one line string) of the object.
dc_OperatingSystemCapability	NVARCHAR(64)	Not Standard. The capability (32 and 64 bits) of this operating system.
dc_OSType	NVARCHAR(256)	Not standard. A string describing the operating system type. This can involve interpretation and not strictly reflect the value of OCType.
dc_PrimaryOS	bit	Not standard. Derived from CIM_InstalledOSBoolean indicating that the OS is the default for the Computer System.
Win32_CSDVersion	nvarchar(256)	Not standard. CSD version/Service Pack level of OS from Windows systems.
dc_SwapSpaceName	nvarchar(256)	Not standard. Name identifying the swap space.
dc_SwapType	nvarchar(64)	Not standard. Type description of swap space.
dc_SwapSpaceMinimumSize	BIGINT	Not standard. Minimum size of swap space.
dc_SwapSpaceMaximumSize	BIGINT	Not standard. Maximum size of swap space.
dc_SwapSpaceReservedSize	BIGINT	Not standard. Reserved size of swap space.

Column Name	Data Type	Description
PhysicalElement_LUID	BIGINT	LUID uniquely defining this table row.
NodeID	BIGINT	Node partly identifies CIM_PhysicalElement.
SnapshotID	BIGINT	Snapshot partly identifies CIM_PhysicalElement
CreationClassName	NVARCHAR(256)	CreationClassName partly identifies CIM_PhysicalElement. Equates to CIM_PhyscialElement.
Tag	NVARCHAR(256)	Tag partly identifies CIM_PhysicalElement. An arbitrary string that uniquely identifies the Physical Element and serves as the Element's key and can contain information such as asset tag or serial number data.
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption. A short textual description (one line string) of the object.
Description	NVARCHAR(512)	Inherited from CIM_ManagedElement.Description. A textual description of an object.
Name	NVARCHAR(256)	The label by which this object is known.
InstallDateTime	BIGINT	Inherited from CIM_ManagedSystemElement.InstallDate. A datetime value indicating when the object was installed. A lack of a value does not indicate that the object is not installed.
Status	NVARCHAR(10)	Inherited from CIM_ManagedSystemElement.Status. A string indicating the current status of the object.
ManufactureDate	BIGINT	Date this physical element was manufactured.
Manufacturer	NVARCHAR(256)	The name of the organization responsible for producing the PhysicalElement. This can be the entity from whom the element is puchased, but this is not necessarily true. The latter information is contained in the Vendor property of CIM_Product.
Model	NVARCHAR(64)	The name by which the Physical Element is generally known.
OtherIdentifyingInfo	NVARCHAR(512)	Captures additional data, beyond that of Tag information, that could be used to identify a Physical Element. One example is bar code data associated with an Element that also has an asset tag. Note that if only bar code data is available and is unique or able to be used as an Element key, this property would be null and the bar code data used as the class key in the Tag property.
PartNumber	NVARCHAR(256)	The part number assigned by the organization responsible for producing or manufacturing the Physical Element.
PoweredOn	bit	Boolean value indicating that the PhysicalElement is powered on (true), or is currently off (false).
SerialNumber	NVARCHAR(64)	A manufacturer-allocated number used to identify the Physical Element.
SKU	NVARCHAR(64)	The stock keeping unit number for this Physical Element.
Version	NVARCHAR(64)	A string indicating the version of the PhysicalElement.
Slot_Number	SMALLINT	The Number property indicates the physical slot number, which can be used as an index into a system slot table, whether that slot is physically occupied.
dc_Location	NVARCHAR(64)	Not standard. A string describing the location of the physical element.
dc_Condition	NVARCHAR(64)	Not standard. A string describing the condition of the physical element such as OK, Degraded, or Failed.
dc_FirmwareRevision	NVARCHAR(64)	Not standard. A firmware revision associated with the physical element.
dc_HWLocation	nvarchar(256)	Not standard. A text description of the hardware location, on complex multi-SBB hardware only, for the element.

Column Name	Data Type	Description
PhysicalMedia_LUID	BIGINT	LUID uniquely defining this table row.
NodeID	BIGINT	Node partly identifies CIM_PhysicalMedia
SnapshotID	BIGINT	Snapshot partly identifies CIM_PhysicalMedia
CreationClassName	NVARCHAR(256)	CreationClassName partly identifies CIM_PhysicalMedia. Equates to CIM_PhysicalMedia.
Tag	NVARCHAR(256)	Inherited from CIM_PhysicalElement.Tag. An arbitrary string that uniquely identifies the Physical Element and serves as the Element's key, and can contain information such as asset tag or serial number data.
MediaType	SMALLINT	Specifies the type of the PhysicalMedia, as an enumerated integer. The MediaDescription property is used to provide more explicit definition of the Media type, whether it is pre-formatted, compatability features, and so on. CIM_PhysicalMedia.MediaType enumeration. 0 = Unknown 1 = Other 2 = Tape 3 = QIC Cartridge 4 = AIT Cartridge 5 = DTF Cartridge 6 = DAT Cartridge 7 = 8mm Tape Cartridge 8 = 19mm Tape Cartridge 9 = DLT Cartridge 10 = Half-Inch Magnetic Tape Cartridge 11 = Cartridge Disk 12 = JAZ Disk 13 = ZIP Disk 14 = SyQuest Disk 15 = Winchester Removable Disk 16 = CD_ROM 17 = CD_ROM/XA 18 = CD-I; 19 19 = Recordable 20 = WORM 21 = Magento-Optical 22 = DVD 23 = DVD-RW+ 24 = DVD-RAM 25 = DVD-ROM 26 = DVD-Video 27 = Divx 28 = Floppy/Diskette 29 = Hard Disk 30 = Memory Card 31 = Hard Copy 32 = Clik Disk 33 = CD-RW 34 = CD-DA 35 = CD+ 36 = DVD Recordable 37 = DVD-RW 38 = DVD-Audio 39 = DVD-5 40 = DVD-9 41 = DVD-10 42 = DVD-18 43 = Magneto-Optical Rewriteable 44 = Magneto-Optical Write Once 45 = Magneto-Optical Rewriteable (LIMDOW) 46 = Phase Change Write Once 47 = Phase Change Rewriteable 48 = Phase Change Dual Rewriteable 49 = Ablative Write Once 50 = Near Field Recording 51 = MiniQic 52 = Travan 53 = 8mm Metal Particle 54 = 8mm Advanced Metal Evaporate 55 = NCTP 56 = LTO Ultrium 57 = LTO Accelis 58 = 9 Track Tape 59 = 18 Track Tape 60 = 36 Track Tape 61 = Magstar 3590 62 = Magstar MP 63 = D2 Tape 64 = Tape, DST Small 65 = Tape, DST Medium 66 = Tape, DST Large
Capacity	BIGINT	The number of bytes that can be read from or written to a Media. This property is not applicable to \"Hard Copy\" (documentation) or cleaner Media. Data compression should not be assumed because it would increase the value in this property. For tapes, it should be assumed that no filemarks or blank space areas are recorded on the Media.Units (bytes).
Removable	bit	Inherited from CIM_PhysicalComponent.Removable. A PhysicalComponent is Removable if it is designed to be taken in and out of the physical container in which it is normally found, without impairing the function of the overall packaging. A component can still be Removable if power must be off to perform the removal. If power can be on and the component removed, then the element is both Removable and HotSwappable. For example, an upgradeable processor chip is removable.
OtherIdentifyingInfo	NVARCHAR (512)	Captures additional data, beyond that of Tag information, that could be used to identify a Physical Element. One example is bar code data associated with an Element that also has an asset tag. Note that if only bar code data is available and is unique or able to be used as an Element key, this property would be null and the bar code data used as the class key in the Tag property.
Description	NVARCHAR(512)	Inherited from CIM_ManagedElement.Description. A textual description of an object.
Name	NVARCHAR(256)	The label by which this object is known.
HotSwappable	bit	Inherited from CIM_PhysicalComponent.HotSwappable. Is HotSwappable if it is possible to replace the Element with a physically different but equivalent one while the containing package has power applied to it (for example, is on).
Manufacturer	NVARCHAR(256)	The name of the organization responsible for producing the PhysicalElement. This can be the entity from whom the element is puchased, but this is not necessarily true. The latter information is contained in the Vendor property of CIM_Product.
Model	NVARCHAR(64)	The name by which the Physical Element is generally known.
SerialNumber	NVARCHAR(64)	A manufacturer-allocated number used to identify the Physical Element.
Version	NVARCHAR(256)	A string indicating the version of the PhysicalElement.

Column Name	Data Type	Description
PhysicalMemory_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT
SnapshotID	BIGINT
CreationClassName	NVARCHAR(256)	CreationClassName identifies CIM_PhysicalMemory. Equates to CIM_PhysicalMemory.
Tag	NVARCHAR(256)	Tag partly identifies CIM_PhysicalMemory. Inherited from CIM_PhysicalElement.Tag. An arbitrary string that uniquely identifies the Physical Element and serves as the Element's key and can contain information such as asset tag or serial number data.
MemoryType	SMALLINT	The type of physical memory. CIM_PhysicalMemory.MemoryType Enumeration. 0 = Unknown 1 = Other 2 = DRAM 3 = Synchronous DRAM 4 = Cache DRAM 5 = EDO 6 = EDRAM 7 = VRAM 8 = SRAM 9 = RAM 10 = ROM 11 = Flash 12 = EEPROM 13 = FEPROM 14 = EPROM 15 = CDRAM 16 = 3DRAM 17 = SDRAM 18 = SGRAM 19 = RDRAM 20 = DDR
Capacity	BIGINT	The total capacity of this PhysicalMemory in bytes. Units bytes.
R_MemoryType	NVARCHAR(256)	A field used by reporting.
R_MemoryTech	NVARCHAR(256)	A field used by reporting.
FormFactor	SMALLINT	Derived from CIM_Chip. The implementation form factor for the Chip. CIM_PhysicalMemory.FormFactor enumeration. 0 = Unknown 1 = Other 2 = SIP 3 = DIP 4 = ZIP 5 = SOJ 6 = Proprietary 7 = SIMM 8 = DIMM 9 = TSOP 10 = PGA 11 = RIMM 12 = SODIMM 13 = SRIMM 14 = SMD 15 = SSMP 16 = QFP 17 = TQFP 18 = SOIC 19 = LCC 20 = PLCC 21 = BGA 22 = FPBGA 23 = LGA
PartNumber	NVARCHAR(256)	The part number assigned by the organization responsible for producing or manufacturing the Physical Element.
SerialNumber	NVARCHAR(64)	A manufacturer-allocated number used to identify the Physical Element.
dc_ErrorMethodology	NVARCHAR(512)	Not standard. The main error correction scheme supported by this memory component.
dc_HWLocation	nvarchar(256)	Not standard. A text description of the hardware location, on complex multi-SBB hardware only, for the memory element.
R_Slot	SMALLINT	A field used by reporting.

Column Name	Data Type	Description
PowerSupply_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies CIM_PowerSupply
SnapshotID	BIGINT	Snapshot partly identifies CIM_PowerSupply
CreationClassName	NVARCHAR(256)	CreationClassName partly identifies CIM_PowerSupply. Equates to CIM_PowerSupply.
DeviceID	NVARCHAR(64)	DeviceID partly identifies CIM_PowerSupply. Inherited from CIM_LogicalDevice.DeviceID. An address or other identifying information to uniquely name the Logical Device.
SystemCreationClassName	NVARCHAR(256)	SystemCreationClassName partly identifies CIM_PowerSupply. When related data is in CIM_PhysicalElement, this field equates to CIM_PhysicalElement. Otherwise, CIM_ComputerSystem.
SystemName	NVARCHAR(256)	The value of CIM_PhysicalElement.Name or CIM_ComputerSystem.Name where NodeID is equal.
Name	NVARCHAR(256)	A label by which the object is known.
Availability	SMALLINT	The primary availability and status of the System. (Additional status information can be specified using the AdditionalAvailability array property). For example, the Availability property indicates that the System is running and has full power (value=3) or is in a warning (value = 4), test (value = 5), degraded (value = 10), or power save state (values 13-15 and 17). Regarding the Power Save states, these are defined as follows: Value 13 (\"Power Save - Unknown\") indicates that the system is known to be in a power save mode, but its exact status in this mode is unknown; value 14 (\"Power Save - Low Power Mode\") indicates that the system is in a power save state but still functioning, and might exhibit degraded performance; value 15 (\"Power Save - Standby\") describes that the system is not functioning but could be brought to full power quickly; and value 17 (\"Power Save - Warning\") indicates that the system is in a warning state, though also in a power save mode. CIM_LogicalDevice.Availabiltiy 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
AdditionalAvailability	SMALLINT	Additional availability and status of the device, beyond that specified in the Availability property. The property denotes the primary status and availability of the device. In some cases, this is not sufficient to denote the complete status of the device. In those cases, the AdditionalAvailability property can be used to provide further information. For example, a device primary Availability might be \"Off line\" (value=8), but it might also be in a low power state (AdditonalAvailability value=14), or the device could be running Diagnostics (AdditionalAvailability value=5, \"In Test\"). See CIM_PowerSupply.Availabiltiy enumeration.
TotalOutput	INT	Represents the total output power of the PowerSupply in milliWatts. 0 denotes Unknown units (milliWatts).
R_Status	NVARCHAR(256)	A field used by reporting.
R_Condition	NVARCHAR(256)	A field used by reporting.
R_MaxCapacity	NVARCHAR(256)	A field used by reporting.
dc_PowerSupplyPresent	NVARCHAR(32)	Not standard. Indicates whether the power supply is present in the chassis.
dc_PowerSupplyStatus	NVARCHAR(64)	Not standard. The status of the power supply.
dc_RedundancyState	NVARCHAR(512)	Not standard. The redundancy state of the power supply.
dc_CurrentOutputPower	INT	Not standard. Capacity and or output power of the power supply in watts.

Column Name	Data Type	Description
Process_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies CIM_Process
SnapshotID	BIGINT	Snapshot partly identifies CIM_ProcessM/para
CSCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem.
CSName	NVARCHAR(256)	The value of CIM_ComputerSystem.Name where NodeID is equal.
OSCreationClassName	NVARCHAR(256)	OSCreationClassName partly identifies CIM_Process. Equates to CIM_OperatingSystem.
OSName	NVARCHAR(256)	OSName partly identifies CIM_Process. The value of CIM_OperatingSystem.Name where NodeID is equal.
Handle	NVARCHAR(256)	Handle partly identifies CIM_Process. A string used to identify the Process. A Process ID is a kind of Process Handle.
CreationClassName	NVARCHAR(256)	CreationClassName partly identifies CIM_Process. Equates to CIM_Process.
Name	NVARCHAR(256)	Name partly identifies CIM_Process. The name of the process.
ExecutionState	SMALLINT	Indicates the current operating condition of the Process. CIM_Process.ExecutionState enumeration. 0 = Unknown 1 = Other 2 = Ready 3 = Running 4 = Suspended Blocked 6 = Suspended Ready 7 = Terminated 8 = Stopped 9 = Growing
Priority	INT	Priority indicates the urgency or importance of execution of a Process.
UnixProcess_ParentProcessID	NVARCHAR(256)	Derived from CIM_UnixProcess.ParentProcessID. The parent process ID of this executing process.
UnixProcess_ProcessGroupID	BIGINT	Derived from CIM_UnixProcess.ProcessGroupID. The group ID of the currently executing process.
UnixProcess_RealUserID	BIGINT	Derived from CIM_UnixProcess.RealUserID. The real user id of the currely executing process.
UnixProcess_ProcessTTY	NVARCHAR(32)	Derived from CIM_UnixProcess.ProcessTTY. The TTY currently associated with this process.
UnixProcess_ModulePath	NVARCHAR(512)	Derived from CIM_UnixProcess.ModulePath. The file path to the executing module for the process.
OtherExecutionDescription	NVARCHAR(512)	Derived from CIM_UnixProcess.ModulePath. The executing process command path.
UnixProcess_Parameters	NVARCHAR(512)	A string describing the state - used when the instance's ExecutionState property is set to Other; else this field is null.
UnixProcess_ProcessNiceValue	INT	Derived from CIM_UnixProcess.Parameters. The operating system parameters provided to the executing process.
UxPrStatInf_RealStack	BIGINT	Derived from CIM_UnixProcess.ProcessNiceValue. The process nice value. Used to compute its priority.
UxPrStatInf_VirText	BIGINT	UnixProcessStatisticalInformation_RealStack. Derived from CIM_UnixProcessStatisticalInformation.RealStack. The number of KB of real stack space used by the process.
UxPrStatInf_VirData	BIGINT	UnixProcessStatisticalInformation_VirtualText. Derived from CIM_UnixProcessStatisticalInformation.VirtualText. The number of KB of virtual text space used by the process.
UxPrStatInf_VirStack	BIGINT	UnixProcessStatisticalInformation_VirtualData. Derived from CIM_UnixProcessStatisticalInformation.VirtualData. The number of KB of virtual data space used by the process.
UxPrStatInf_VirSharedMem	BIGINT	UnixProcessStatisticalInformation_VirtualStack. Derived from CIM_UnixProcessStatisticalInformation.VirtualStack. The number of KBs of virutal stack space used by the process.
UxPrStatInf_VirSharedMem	BIGINT	UnixProcessStatisticalInformation_VirtualSharedMemory. Derived from CIM_UnixProcessStatisticalInformation.VirtualSharedMemory. The number of KB of shared memory used by the process.
UxPrStatInf_VirMemMapFileSize	BIGINT	UnixProcessStatisticalInformation_VirtualMemoryMappedFileSize. Derived from CIM_UnixProcessStatisticalInformation.VirtualMemoryMappedFileSize. The number of KB of virtual space used for memory mapped files by the process.

Column Name	Data Type	Description
Processor_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies CIM_Processor
SnapshotID	BIGINT	Snapshot partly identifies CIM_Processor
CreationClassName	NVARCHAR(256)	CreationClassName partly identifies CIM_Processor. Equates to CIM_Processor.
DeviceID	NVARCHAR(64)	DeviceID partly identifies CIM_Processor. Inherited from CIM_LogicalDevice.DeviceID. An address or other identifying information to uniquely name the Logical Device.
Name	NVARCHAR(256)	Name partly identifies CIM_Processor. A label by which the object is known.
SystemCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem.
SystemName	NVARCHAR(256)	The value of CIM_ComputerSystem.Name where NodeID is equal.
Family	SMALLINT	The Processor Family Type. CIM_Processor.Family enumeration. 1 = Other 2 = Unknown 3 = 8086 4 = 80286 5 = 80386 6 = 80486 7 = 8087 8 = 80287 9 = 80387 10= 80487 11 = Intel® Pentium® brand 12 = Pentium® Pro 13 =Pentium® II 14 = Pentium® processor with MMX™ technology 15 = Celeron® 16 = Pentium® II Xeon™ 17 = Pentium® III 18 = M1 Family 19 = M2 Family 24 = K5 Family 25 = K6 Family 26 = K6-2 27 = K6-3 28 = AMD Athlon Processor Family 29 = AMD Duron Processor 30 = AMD29000 Family 31 = K6-2+ 32 = Power PC Family 33 = Power PC 601 34 = Power PC 603 35 = Power PC 603+ 36 = Power PC 604 37 = Power PC 620 38 = Power PC X704 39 = Power PC 750 48 = Alpha Family 49 = Alpha 21064 50 = Alpha 21066 51 = Alpha 21164 52 = Alpha 21164PC 53 = Alpha 21164a 54 = Alpha 21264 55 = Alpha 21364 64 = MIPS Family 65 = MIPS R4000 66 = MIPS R4200 67 = MIPS R4400 68 = MIPS R4600 69 = MIPS R10000 80 = SPARC Family 81 = SuperSPARC 82 = microSPARC 83 = microSPARC IIep 84 = UltraSPARC 85 = UltraSPARC II 86 = UltraSPARC IIi 87 = UltraSPARC III 88 = UltraSPARC IIIi 96 = 68040 97 = 68xxx Family 98 = 68000 99 = 68010 100 = 68020 101 = 68030 112 = Hobbit Family 120 = Crusoe TM5000 Family 121 = Crusoe TM3000 Family 128 = Weitek 130 = Intel® Itanium® Processor 144 = PA-RISC Family 145 = PA-RISC 8500 146 = PA-RISC 8000 147 = PA-RISC 7300LC 148 = PA-RISC 7200 149 = PA-RISC 7100LC 150 = PA-RISC 7100 160 = V30 Family 176 = Pentium® III Xeon™ 177 = Pentium® III Processor with Intel® SpeedStep™ Technology 178 = Pentium® 4 179 = Intel® Xeon™ 180 = AS400 Family 181 = Intel Xeon processor MP 190 = K7 200 = Intel Xeon processor MP 201 = G4 202 = G5 250 = i860 251 = i960 260 = SH-3 261 = SH-4 280 = ARM 281 = StrongARM 300 = 6x86 301 = MediaGX 302 = MII 320 = WinChip 350 = DSP 500 = Video Processor
CurrentClockSpeed	INT	The current speed (in MHz) of this Processor.
UniqueID	NVARCHAR(256)	A globally unique identifier for the Processor. This identifier may only be unique within a Processor Family.
LoadPercentage	SMALLINT	Loading of this Processor, averaged over the last minute in percent.
CPUStatus	SMALLINT	The CPUStatus property indicates the current status of the Processor. For example, it might be disabled by the user through BIOS (value=2), or disabled because of a POST error (value=3). Information in this property can be obtained from SMBIOS, the Type 4 structure, the Status attribute. CIM_Processor.CPUStatus Enumeration. 0 = Unknown 1 = CPU 2 = CPU disabled by user through BIOS setup 3 = CPU disabled by BIOS (POST error) CPU Is Idle Other
OtherIdentifyingInfo	NVARCHAR(64)	Inherited from CIM_LogicalDevice.OtherIdentifyingInfo.OtherIdentifyingInfo 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.
R_CPUType	NVARCHAR(256)	A field used by reporting.
R_CPUSpeed	NVARCHAR(256)	A field used by reporting.
R_CPUStatus	nvarchar(256)	A field used by reporting.
dc_HWLocation	nvarchar(256)	Not standard. A text description of the hardware location, on complex multi-SBB hardware only for the processor.

Column Name	Data Type	Description
Rack_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies CIM_Rack
SnapshotID	BIGINT	Snapshot partly identifies CIM_Rack
CreationClassName	NVARCHAR(256)	CreationClassName partly identifies CIM_Rack. Equates to CIM_Rack.
Tag	NVARCHAR(256)	Tag partly identifies CIM_Rack. Inherited from CIM_PhysicalElement.Tag. An arbitrary string that uniquely identifies the Physical Element and serves as the Element key and can contain information such as asset tag or serial number data.
SerialNumber	NVARCHAR(64	Inherited from CIM_PhysicalElement.SerialNumber. A manufacturer-allocated number used to identify the Physical Element.
Name	NVARCHAR(256)	A label by which the object is known.

Column Name	Data Type	Description
Sensor_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies CIM_Sensor
SnapshotID	BIGINT	Snapshot partly identifies CIM_Sensor
DeviceID	NVARCHAR(64)	DeviceID partly identifies CIM_Sensor. Inherited from CIM_LogicalDevice.DeviceID. An address or other identifying information to uniquely name the Logical Device.
CreationClassName	NVARCHAR(256)	CreationClassName partly identifies CIM_Sensor. Equates to CIM_Sensor.
SystemCreationClassName	NVARCHAR(256)	SystemCreationClassName partly identifies CIM_Sensor. If the sensor is owned by a chassis, then this field equates to CIM_Chassis, otherwise to CIM_ComputerSystem.
SystemName	NVARCHAR(256)	Equates to CIM_Sensor.Name or CIM_ComputerSystem.Name where NodeID is equal.
Name	NVARCHAR(256)	Name partly identifies CIM_Sensor. A label by which the object is known.
Status	NVARCHAR(10)	Inherited from CIM_ManagedSystemElement.Status. A string indicating the current status of the object.
CurrentState	NVARCHAR(128)	The current state indicated by the Sensor. This is always one of the Possible States property.
PossibleStates	NVARCHAR(512)	Possible States enumerates the string outputs of the Sensor. For example, a Switch Sensor may output the states On or Off. Another implementation of the Switch may output the states Open and Close. Another example is a NumericSensor supporting thresholds. This Sensor can report the states like Normal, Upper Fatal, Lower non-critical, and so on. A Numeric Sensor that does not publish readings and threshold but stores this data internally can still report its states.

Column Name	Data Type	Description
SoftwareElement_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies CIM_SoftwareElement
SnapshotID	BIGINT	Snapshot partly identifies CIM_SoftwareElement
SoftwareElementID	NVARCHAR(256)	SoftwareElementID partly identifies CIM_SoftwareElement. This is an identifier for theSoftware Element and is designed to be used in conjunction with other keys to create a unique representation of the element.
SoftwareElementState	SMALLINT	SoftwareElementState partly identifies CIM_SoftwareElement. The SoftwareElementState is defined in this model to identify various states of a SoftwareElement life cycle. A SoftwareElement in the deployable state describes the details necessary to successfully distribute it and the details (checks and actions) required to move it to the installable state (for example, the next state). A SoftwareElement in the installable state describes the details necessary to successfully install it and the details (checks and actions) required to create an element in the executable state (for example, the next state). A SoftwareElement in the executable state describes the details necessary to successfully start it and the details (checks and actions) required to move it to the running state for example, the next state). A SoftwareElement in the running state describes the details necessary to manage the started element. CIM_SoftwareElement.SoftwareElementState enumeration. 0 = Deployable 1 = Installable 2 = Executable 3 = Running
Version	NVARCHAR(64)	Version partly identifies CIM_SoftwareElement. Software Version should be in the form <Major>.<Minor>.<Revision> or <Major>.<Minor><letter><revison>.
Name	NVARCHAR(256)	Name partly identifies CIM_SoftwareElement. The name used to identify this software element.
TargetOperatingSystem	SMALLINT	TargetOperatingSystem partly identifies CIM_SoftwareElement. The TargetOperatingSystem property specifies the Element operating system environment. The value of this property does not ensure that it is binary executable. Two other pieces of information are needed. First, the version of the operating system needs to be specified using the class, CIM_OSVersionCheck. The second piece of information is the architecture that the operating system runs on. This information is verified using CIM_ArchitectureCheck. The combination of these constructs clearly identifies the level of operating system required for a particular SoftwareElement. See CIM_OperatingSystem.OSType Enumeration.
InstallDate	BIGINT	Inherited from CIM_ManagedSystemElement.InstallDate. The datetime value indicating when the object was installed.
R_Date	NVARCHAR(256)	A field used by reporting.
R_Status	NVARCHAR(256)	A field used by reporting.
Description	NVARCHAR(512)	Inherited from CIM_ManagedElement.Description. A textual description of an object.
DeviceSW_Purpose	SMALLINT	DeviceSoftware_Purpose. An enumerated integer to indicate the role this software plays in regards to its associated Device. CIM_DeviceSoftware.Purpose enumeration. 0 = Unknown 1 = Other 2 = Driver 3 = Configuration Software 4 = Application Software 5 = Instrumentation 6 = Firmware 7 = BIOS 8 = Boot ROM
DeviceSW_PurposeDescription	NVARCHAR(512)	DeviceSoftware_PurposeDescription. A free-form string to provide more information fro the Purpose property.
swd_VersionWeight	INT	swd_VersionWeight is of CIM_SoftwareElement. A field used by Software Version Polling.
dc_OtherVersionInfo	NVARCHAR(64)	Not standard. A string that specifies the version of this item.
R_Type	nvarchar(64)	A field used by reporting.

In the ClusterInfo table, each row represents one cluster. The ClusterInfo fields are defined in the following table.

Using Default Tools
Database Tables

» HP Systems Insight Manager

Introduction

Pre-defined Views

Database Tables

Using Default Tools Database Tables

» HP Systems Insight Manager

Introduction

Pre-defined Views

Database Tables

Using Default Tools
Database Tables