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.

Column Name	Data Type	Description
*ClusterDeviceKey	INT	This value is the key that associates this table with the Devices table.
ClusterType	INT	Each numeric value represents a particular cluster.
ContactPerson	NCHAR(128)	The name of the person to contact about problems with the cluster.
ContactPhone	CHAR(128)	The telephone number of the contact person.
ContactEmail	CHAR(128)	The e-mail address of the contact person.
ContactPager	CHAR(128)	The telephone number of the contact person's pager.
DialOutModem	CHAR(128)	The telephone number of the modem that the cluster dials to report problems.
DialInModem	CHAR(128)	The telephone number of a modem that provides remote access to the cluster.
ClusterLocation	NCHAR(255)	The physical location of the cluster hardware.
Applications	NTEXT	A list of applications running on the cluster.
Comments	NTEXT	Additional comments.
UpdateTime	DATETIME	Date and time the database record was last updated.

Column Name	Data Type	Description
*ClusterDeviceKey	INT	The device key that relates to the key in the Devices table for the device that represents the cluster.
*NodeDeviceKey	INT	The device key to the Devices table that represents the cluster member, node, or both.
ContactPerson	NCHAR (128)	The person who is contacted in the event of a cluster monitor event.
ContactPhone	CHAR (128)	The phone number of the contact person.
ContactEmail	CHAR (128)	The e-mail address of the contact person. HP Systems Insight Manager can be configured using event handling to automatically e-mail the contact in the event of a cluster event.
ContactPager	CHAR (128)	The pager number of the contact person. HP Systems Insight Manager can be configured using event handling to automatically page the contact in the event of a cluster event.
DialOutModem	CHAR (128)	The phone number of the modem that the node dials to report problems.
DialInModem	CHAR (128)	The phone number of the modem that provides remote access to the node.
Applications	NTEXT	A list of applications running on the cluster. This field can hold up to 1000 alphanumeric characters.
Comments	NTEXT	Additional comments about the cluster. This field can hold up to 1000 alphanumeric characters.
UpdateTime	DATETIME	Date and time the database record was last updated.

The DB_DeviceInfo table contains general system information. Any system that supports SNMP has information in this table. The DB_DeviceInfo fields are defined in the following table.

Column Name	Data Type	Description
*DeviceKey	INT
UpdateTime	DATETIME	Date and time the database record was last updated.
Description	CHAR (200)	System description.
Location	CHAR (200)	Physical location (must be filled in at the device).
Contact	CHAR (200)	The contact for this device (must be filled in at the device).

The DB_DeviceInfoEx table contains basic information for systems that are running the HP Systems Insight Manager agent or a standard DMI service layer. The DB_DeviceInfoEX fields are defined in the following table.

Column Name	Data Type	Description
*DeviceKey	INT	The DeviceKey associates a system with its collected set of data. System information is linked to the device table using the DeviceKey.
UpdateTime	DATETIME	Date and time the database record was last updated.
TotalMemory	INT	Total amount of system memory.
ROMVersion	CHAR (80)	System ROM version.
SerialNumber	CHAR (80)	System serial number.
AssetTag	CHAR (100)	System asset tag (must be filled in at the system).
OSName	CHAR (100)	Operating system name. Note: This is not the same OSName from the tool definitions files. This is the OSNameStr value from mxnode.
OSType	CHAR(100)	The OSType identifier that is used for tool definitions OSName field. This is a value like WINNT, HPUX, or LINUX.
OSVersion	CHAR (100)	Operating system version.
OSVendor	CHAR(64)	Vendor name of the operating system.
ClusterName	CHAR (100)	If present, the name of the cluster to which this node belongs.
OSDescription	CHAR(100)	The description of the host operating system.
TrustStatus	Int		System trust state for HP Web enabled agents;.

Column Name	Data Type	Description
ProliantHost_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Identifies the node ID for this row
SnapshotID	BIGINT	Identifies the snapshot ID for this row
dc_SystemCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem.
dc_SystemName	NVARCHAR(256)	The value of CIM_ComputerSystem.Name where NodeID is equal.
OverallCondition	NVARCHAR(16)	This object represents the overall status of the server host system represented by this MIB.
MIBStatusArray	NVARCHAR(512)	The MIB Status Array is an array of MIB status structures. Each structure is made up of 4 octets. The first octet is the MIB presence. The second octet is MIB condition. The third octet is MIB major revision. The fourth octet is MIB minor revision. These blocks of 4 octets each are index by the mib identifier just after the HP enterprise (for example, in 1.3.6.1.232.11 mib, the index is 11). The 4 octets in the first block (block 0) are reserved for systems management and serve as an aggregate of their MIBs.
GUID	NVARCHAR(32)	The globally unique identifier of this server. If the operating system cannot determine a unique ID, it defaults the variable to contain all 0's. The management station can then perform a SET to this variable to provide the unique ID.
WebManagementPort	INT	This item indicates the port used by the HP Insight Management Agents.
ASRStatus	NVARCHAR(16)	The Automatic Server Recovery (ASR) feature status. If this object is currently Other (1) or Not Available (2), all set operations fail. Any attempt to set this object to Other (1) or Not Available (2) by a management station fails. Setting this object to Disabled (3) or Enabled (4) disables or enables the ASR feature.
SystemID	INT	The HP System ID. This value indicates the HP system ID of the system board in this system. This ID replaces the product ID used in older machines (cpqSiProductId). A value of 7Eh for the cpqSiProductId indicates that the cpqSiSystemId should be used to identify the HP system. A value of zero (0) indicates that the system ID function is not supported on this machine. In this case, the cpqSiProductId should be used to identify the system.
ServerRole	NVARCHAR(64)	The system role. This is a settable free form text field intended to be assigned by a remote console briefly describing the system's function.
ServerRoleDetail	NVARCHAR(512)	The system detailed description. This is a settable free form text field intended to be assigned by a remote console describing the system function in detail.
ConfigChangeDate	BIGINT	The date/time when the agents were last loaded.
SystemUptime	BIGINT	The total time (in minutes) the system has been in full operation (while the server health supporting software was running).

The DeviceNames table contains the names for devices as determined by the various protocols that this device supports. The DeviceNames fields are defined in the following table.

Column Name	Data Type	Description
*DeviceKey	INT	The deviceKey associates a system with its collected set of data. System information is linked to a system using the DeviceKey from the devices table.
nameSNMP	CHAR (60)	The name for this system obtained through SNMP.
nameIPX	CHAR (60)	The name for this system obtained through a name service (such as WINS or DNS) or the hosts file.
nameDMI	CHAR (60)	The name for this system obtained through DMI.
NameFullDNS	CHAR (90)	This is the fully qualified DNS name (if available).
nameActiveDisc	CHAR (60)	This field is no longer an active field.

The Devices table contains discovered system information. This is the primary table used to define system related data. The Devices fields are defined in the following table.

Column Name	Data Type	Description
DeviceKey	INT	The DeviceKey associates a system with its collected set of data. System information is linked to the device table using the DeviceKey.
Name	CHAR (255)	The name of the device.
GUID	CHAR (128)	Globally Unique Identifier, a unique key used to identify this device on the network in the event that it changes its network address. This requires that a system support retrieval of this value in order for it to be stored here.
Discovered	BIGINT	The date and time that the device was discovered represented as the number of milliseconds since 1970 UTC.
ProductType	INT	The product type for this item. See the nodeTypesEnum table, which is best viewed using the deviceSubTypesEnum view, for additional information.
ProductTypeStr	Char(32)	A string representation of the product type. See the nodeTypesEnum table, which is best viewed using the deviceTypesEnum view, for additional information.
ProductSubType	CHAR(32)	The subtype if any, see the NodeSubTypesEnum table, which is best viewed using the deviceSubTypesEnum view, for additional mapping information.
ProductName	CHAR (100)	Product name (such as ProLiant 1500).
OverallStatus	INT	Indicates the overall status of the system: 0 = Unknown 1 = Normal 2 = Warning 3 = Minor 4 = Major 5 = Critical 10 = No Status (occurs for new systems or on startup before polling).
LockFlags	INT	Indicates whether product type, name, or both are locked so that discovery cannot change them. 0 = Nothing is locked.
Timestamp	BIGINT	RESERVED. The last time some system information was updated in the database, not just in this table.
FullDNSName	VARCHAR (90)	The full DNS name of the system
MxGUID	CHAR(32)	The HP Systems Insight Manager uniquely assigned identifier for this system.

Column Name	Data Type	Description
DeviceKey	INT	The DeviceKey associates this table with the system in the devices table.
IPAddressable	INT	Flag indicating if this device is addressable through TCP/IP.
IPXAddressable	INT	Flag indicating if this device is addressable through IPX.
SNMP	INT	Flag indicating if this device supports SNMP-based management; a value of -1 indicates the device was not identified yet; a value of 0 indicates SNMP was not found on the device; a value of 1 to 5 indicates that SNMP was found on the device.
SNMPverStr	NCHAR(32)	A string indicating what version of SNMP was detected. Currently HP Systems Insight Manager only supports “1.0”
HTTP	INT	Flag indicating if this device supports HTTP-based management; a value of -1 indicates the device was not yet identified; a value of 0 indicates HTTP was not found on the system a value of 1 indicates that HTTP was found on the device.
DMI	INT	Flag indicating if this device supports DMI-based management; a value of -1 indicates the device was not yet identified; a value of 0 indicates DMI was not found on the device; a value of 1 indicates DMI was found on the device.
DMIVerStr	NCHAR(32)	Always 2.0.
WBEM	INT	If WBEM is detected on the system, then this is set to 1. Otherwise, 0.
WBEMverStr	NCHAR(32)	The version of WBEM that HP Systems Insight Manager found on the system.
SSH	INT	If SSH was detected on the system this is set to 1. Otherwise, 0.
SSHverStr	NCHAR(64)	The System ID returned from the SSH request.
PrimaryAddress	nchar(32)	For future expansion.
WMIProxyID	INT	The device key of the system that is used for the WMI proxy for the system for this record. In other words. HP Systems Insight Manager uses the system with same device key as the WMIProxyID for making WBEM to requests through the WMI Mapper running on that other system.

Column Name	Data Type	Description
enumOrd	INT	The enumeration identifier for this entry. This can be used when linking in the deviceTypesEnum view. This should also match the productType value in the devices table.
enumLabel	char(64)	This is a unique (non displayable) string used for identifying a product type. This is the only value guaranteed to be unique across any installation.

Column Name	Data Type	Description
enumOrd	INT	The enumeration identifier for this entry. This can be used when linking in the deviceSubTypesEnum view.
enumLabel	char(64)	This is a unique (non displayable) string used for identifying a product subtype. This is the only value guaranteed to be unique across any installation. This can be linked to the devices tables productSubType field.

The DeviceSnmpSettings table contains the SNMP settings currently configured for the devices. The DeviceSnmpSettings fields are defined in the following table.

Column Name	Data Type	Description
*DeviceKey	INT	The DeviceKey associates a system with its collected set of data. This systems information is linked using the DeviceKey from the devices table.
networkTimeout	INT	The network timeout value in seconds.
networkRetries	INT	The number of retries to be used for SNMP requests
icmpTimeout	INT	ICMP ping timeout value in seconds
icmpRetries	INT	The number of ICMP ping retries to perform
defaultProtoMask	INT	Defines if this system uses defaults (Global protocol settings) for some or all protocols or its individual settings. This is a bitmask field where the different bits define what defaults are to be used. The values are logically ordered together. use the default SNMP read community = 1 use the default SNMP write community = 2 use the default SNMP timeout = 4 use the default SNMP retries = 8 use the default icmp timeout = 16 use the default ICMP retries = 32 use the default WBEM user name = 64 use the default WBEM password = 128

Column Name	Data Type	Description
BaseKernelParameter_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_BaseKernelParameter
SnapshotID	BIGINT	Snapshot partly identifies HPUX_BaseKernelParameter.
BaseKernelParameterID	INT	BaseKernelParameterID partly identifies HPUX_BaseKernelParameter. Index of Kernel Configure Group.
settingID	NVARCHAR(256)	Name of the kernel configure parameter.
CurrentValue	NVARCHAR(256)	Value of the kernel configure parameter.

Column Name	Data Type	Description
Bundle_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_Bundle
SnapshotID	BIGINT	Snapshot partly identifies HPUX_Bundle
IdentifyingNumber	NVARCHAR(64)	Inherited from CIM_Product.IdentifyingNumber. Product identification such as a serial number in software, a die number on a hardware chip, or a project number.
Version	NVARCHAR(64)	Inherited from CIM_Product.Version. Product version information. Corresponds to the Version property in the Product object in the DMTF Solution Exchange Standard.
Vendor	NVARCHAR(256)	Inherited from CIM_Product.Vendor. The name of the Product's supplier, or entity selling the Product (the manufacturer, reseller, OEM). Corresponds to the Vendor property in the Product object in the DMTF Solution Exchange Standard.
Name	NVARCHAR(256)	Inherited from CIM_Product.Name..Commonly used product name.
Architecture	NVARCHAR(64)	Local to HPUX_Bundle. A vendor-defined string used to distinguish variations of a product. It is used for presentation purposes and for resolving software specifications. If a product with the same value of the Revision and Vendor Tag attributes has different versions of software for different target architectures or any other variation (such as supportedlocale), then the value of the architecture attribute is different for each version. No additional semantics are assumed for its value.
Location	NVARCHAR(256)	Location is of HPUX_Bundle. Local to HPUX_Bundle. Used for resolving software specifications for installed software. A specific product location refers to all filesets of that product that are installed at that location. This is the path beneath which the relocatable files of that product are stored.
QualifierID	NVARCHAR(64)	Local to HPUX_Bundle. Specified by a user when installing software and used for identifying a product (or set of product versions) using a logical name.
CreateTime	BIGINT	Local to HPUX_Bundle. A value set by the implementation to be the time that the catalog information for this object was first written. Stored as MS since the Epoch.
Description	NVARCHAR(512)	Inherited from CIM_ManagedElement.Description. The Description property provides a textual description of the object.
ModificationTime	BIGINT	Local to HPUX_Bundle. A value set by the implementation to be the time that the catalog information for this object was last written. Stored in MS since the Epoch.
Size	NVARCHAR(32)	Local to HPUX_Bundle. The sum of the sizes in bytes of all files and control files contained within the software object. For objects other than filesets, the value is computed dynamically as required.
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption. The Caption property is a short textual description of the object.
Copyright	NVARCHAR(256)	Local to HPUX_Bundle. The copyright notice for the bundle.
Directory	NVARCHAR(256)	Local to HPUX_Bundle. The vendor-defined directory commonly associated with the product. Generally, this is the directory in or below which all (or mostly all) files within the product are installed. For a product that has filesets with the Is Locatable attribute equal to true, all files that contain this directory as the first part of their path can be relocated to the Location Directory during installation by replacing the product.directory portion with the product.location.
InstanceIdentifier	NVARCHAR(16)	Local to HPUX_Bundle. A single attribute that distinguishes versions of products (and bundles) with the same Tag. It is a simple form of the version distinguishing attributes, valid only within the context of an exported catalog.
IsLocatable	bit	Local to HPUX_Bundle. A Boolean value indicating whether any of the filesets in the product have the Is Locatable attribute set to true.
LayoutVersion	NVARCHAR(64)	Local to HPUX_Bundle. This attribute, and its value, are included for future use.
MachineType	NVARCHAR(64)	Local to HPUX_Bundle. A software pattern matching string describing valid machine members of the uname structure as defined by POSIX.1 (2) section 4.4.1. It is used for determining compatibility.
SKUNumber	NVARCHAR(64)	Inherited from CIM_Product.SKUNumber. Product SKU information.
OperatingSystemName	NVARCHAR(256)	Local to HPUX_Bundle. A software pattern matching string describing valid sysname members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
OperatingSystemRelease	NVARCHAR(256)	Local to HPUX_Bundle. A software pattern matching string describing valid release members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
OperatingSystemVersion	NVARCHAR(64)	Local to HPUX_Bundle. A software pattern matching string describing valid version members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
ISPatch	bit	Local to HPUX_Bundle. A Boolean value indicating whether this software object is a patch.
InstallSource	NVARCHAR(256)	Local to HPUX_Bundle. Location of source from where software was installed.
DataModelRevision	Nvarchar(64)	Local to HPUX_Bundle. Supplies information on version of POSIX compatibility and corresponds to the operating system release that packaged or installed the software.
InstallDate	BIGINT	Local to HPUX_Bundle. Date timestamp of day, month, year, and time when the software was installed on the system. Stored as MS since the Epoch.
Contents	NVARCHAR(256)	Local to HPUX_Bundle. The Fileset Software Specification of the bundle's content.

Column Name	Data Type	Description
DNSService_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_DNSService
SnapshotID	BIGINT	Snapshot partly identifies HPUX_DNSService
SystemCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem.
SystemName	NVARCHAR(256)	Equates to CIM_ComputerSystem.Name were NodeID is equal.
Name	NVARCHAR(256)	Inherited from CIM_ManagedSystemElement.Name. The Name property defines the label by which the object is known.
SearchList	NVARCHAR(512)	This attribute is the search list for host-name lookup. This attribute and Domain Name attribute are mutually exclusive.
Addresses	NVARCHAR(512)	This attribute specifies the IP addresses in dot notation format of the name servesr that the resolver should search. It may list up to 9 name servers. These names are space delimited.

Column Name	Data Type	Description
Fileset_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_Fileset
SnapshotID	BIGINT	Snapshot partly identifies HPUX_Fileset
SoftwareElementID	BIGINT	Inherited from CIM_SoftwareElement.SoftwareElementID. This is an identifier for the SoftwareElement and is designed to be used in conjunction with other keys to create a unique representation of the element.
Name	NVARCHAR(256)	Inherited from CIM_SoftwareElement.Name. The name used to identify this software element.
Version	NVARCHAR(64)	Inherited from CIM_SoftwareElement.Version. Software Version should be in the form <Major>.<Minor>.<Revision> or <Major>.<Minor><letter><revison>.
TargetOperatingSystemName	SMALLINT	Inherited from CIM_SoftwareElement.TargetOperatingSystemName. Uses CIM_OperatingSystem.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 Me 64 = Caldera Open UNIX 65 = OpendBSD 66 = Not Applicable
CreateTime	BIGINT	A value set by the implementation to be the time that the catalog information for this object was first written. Stored as MS since the Epoch.
Description	NVARCHAR(32)	Inherited from CIM_ManagedElement.Description. This property provides a textual descrition of the object.
ModificationTime	BIGINT	A value set by the implementation to be the time that the catalog information for this objectwas last written. Stored as MS since the Epoch.
Size	NVARCHAR(32)	The sum of the sizes in bytes of all files and control files contained within the software object. For objects other than filesets, the value is computed dynamically as required.
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption. A short textual description of the object.
ControlDirectory	NVARCHAR(256)	The name of the fileset control directory below which the control files for the fileset are stored within an exported catalog.
ISKernel	bit	A boolean value indicating the fileset requires a kernel rebuild.
ISLocatable	bit	A boolean value indicating whether the fileset can be relocated during installation.
ISReboot	bit	A boolean value indicating the host on which the fileset is configured should be re-booted.
Location	NVARCHAR(256)	Specifies the location below which relocatable files are stored. This attribute is only valid for filesets in installed software. It differs from the product.directory attribute only if relocation was specified during installation.
MediaSequenceNumber	NVARCHAR(256)	A list of values which identify the medium on which the files for this fileset is found.
SoftwareElementState	SMALLINT	An enumeration. 0 = Deployable 1 = Installable 2 = Executable 3 = Running
DataModelRevision	NVARCHAR(64)	Supplies information on version of POSIX compatibility and corresponds to the operating system release that packaged or installed the software.
InstanceIdentifier	NVARCHAR(16)	A single attribute that distinguishes versions of products (and bundles and filesets) with the same Tag. It is a simple form of the version distinguishing attributes, valid only within the context of an exported catalog.
InstallDate	BIGINT	Date timestamp of day, month, year, and time when the software was installed on the system. Stored as MS since the Epoch.
Architecture	NVARCHAR(64)	A vendor-defined string used to distinguish variations of a product. It is used for presentation purposes and for resolving software specifications. If a product with the same value of the Revision and Vendor Tag attributes has different versions of software for different target architectures or any other variation (such as supported locale), then the value of the architecture attribute shall be different for each version. No additional semantics are assumed for its value.
MachineType	NVARCHAR(64)	A software pattern matching string describing valid machine members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
OperatingSystemName	NVARCHAR(64)	A software pattern matching string describing valid sysname members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
OperatingSystemRelease	NVARCHAR(256)	A software pattern matching string describing valid release members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
OperatingSystemVersion	NVARCHAR(64)	A software pattern matching string describing valid version members of the uname structure as defined by POSIX.1 (2)Use t section 4.4.1. It is used for determining compatibility.
InstallSource	NVARCHAR(128)	Location of source from where software was installed.
ISPatch	bit	A Boolean value indicating whether this software object is a patch.
ISSparse	bit	This fileset denotes a fileset that is not complete, but one that has been qualified as an update (as opposed to a patch). One outcome of updating through a sparse fileset is that the catalog information from the old fileset is merged into the new fileset and the old fileset is then removed, leaving the system in the same state as it would be after an update of a full fileset. This option should be used in conjunction with an ancestor attribute showing exactly which version or versions of software this sparse fileset can update. Filesets that are sparse are only useful when installed along with those versions or when those versions are already installed.
PatchState	NVARCHAR(16)	Only applied to installed patches. Characterizes the current state of an installed patch.
AppliedPatches	NVARCHAR(256)	Only applicable to installed patches. Specifies the software on which this patch fileset has been applied.
SupercededBy	NVARCHAR(256)	Lists what patch superseded this patch.
SavedFileDirectory	NVARCHAR(256)	The value that was used by swinstall during the installation of this patch fileset to save the patched files if patch_save_files was set to true at that time. When rolling back or committing this patch, this attribute is used to determine the directory to access those saved files.

Column Name	Data Type	Description
HFS_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT
SnapshotID	BIGINT
Name	NVARCHAR(256)	Inherited from CIM_FileSystem.Name. The inherited Name serves as key of a FileSystem instance within a ComputerSystem.
CreationClassName	NVARCHAR(256)	Equates to HPUX_HFS.
CSCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem.
CSName	NVARCHAR(256)	Equates to CIM_ComputerSystem.Name where NodeID is equal.
Root	NVARCHAR(256)	Inherited from CIM_FileSystem.Root. Path name or other information defining the root of the FileSystem.
ReadOnly	bit	Inherited from CIM_FileSystem.ReadOnly. Indicates that the FileSystem is designated as read only.
FileSystemType	NVARCHAR(256)	Inherited from CIM_FileSystem.FileSystemType. String describing the type of FileSystem and its conventions. For example, \"NTFS\" or \"S5\" may be as well as any additional information on the FileSystem implementation. Because various flavors of FileSystems (like S5) exist, this property is defined as a string.
FileSystemSize	BIGINT	Inherited from CIM_FileSystem.FileSystemSize. The total size of the File System in bytes. If unknown, enter 0. Units (bytes).
BlockSize	BIGINT	Inherited from CIM_FileSystem.BlockSize.The FileSystem's block size for data storage and retrieval. Units (Bytes).
AvailableSpace	BIGINT	Inherited from CIM_FileSystem.AvailableSpace.The total amount of free space for the FileSystem, in bytes. Units (Bytes).
RemoteFileSystem_Name	NVARCHAR(256)	Inherited from CIM_ManagedSystemElement.Name. A label by which an object is known.
FreeInodes	BIGINT	Inherited from CIM_UnixLocalFileSystem.FreeINodes. The number of free inodes present in the file system.
TotaInodes	BIGINT	Inherited from CIM_UnixLocalFileSystem.TotalINodes. The total number of inodes available in the file system. 0 indicates this file system does not have a preset limit.
FSReservedCapacity	BIGINT	Inherited from CIM_UnixLocalFileSystem.FSReservedCapacity. The reserve data capacity of the file system in bytes.
Bootable	bit	This attribute indicates whether a file system is a bootable.
LargeFileSupported	bit	Indicates that this file system supports large files.
MinimumFreespace	bit	This attribute indicates the minimum percentage of free disk spaces allowed.
FragmentSize	INT	This attribute specifies the fragment block size of this file system.
InodeSize	INT	This attribute specifies the density of Inodes in this file system.
SectorsPerTrack	INT	This attribute is the number of sectors per track on the disk.
TracksPerCylinder	INT	This attribute specifies the number of tracks per cylinder on the disk.
DiskCylindersPerCylinderGroup	INT	This attribute specifies the number of disk cylinders per cylinder group.
DiskRevolutionsPerSecond	INT	This attribute specifies the number of disk revolutions per second.
RotationalDelay	INT	This attribute specifies the expected time in MS to service a transfer completion interrupt and initiate a new transfer on the same disk.
dc_MountedFileSystems	INT	This attribute is the total number of currently mounted file systems.

Column Name	Data Type	Description
LogicalVolume_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_LogicalVolume
SnapshotID	BIGINT	Snapshot partly identifies HPUX_LogicalVolume
Name	NVARCHAR(256)	Name of Logical Volume in the System.
DeviceID	NVARCHAR(64)	Inherited from CIM_LogicalDevice.DeviceID. An address or other identifying information to uniquely name the Logical Device.
Access	SMALLINT	Inherited from CIM_StorageExtent.Access. Describes whether the media is readable, writeable, or both. An enumeration. 0 = Unknown 1 = Readable 2 = Writeable 3 = Read/Write Supported 4 = Write Once
LogicalExtentSize	BIGINT	Computed by multiplying HPUX_LogicalVolume.BlockSize by HPUX_LogicalVolume.NumberOfBlocks.
Capacity	BIGINT	Capacity of logical volume in number of logical extent.
MirrorCopyNumber	INT	Number of the mirrored Copy for the logical volume.
ConsistencyRecovery	NVARCHAR(64)	Consistency Recovery Method for the mirrored logical volume. No value for NOT mirrored Logical Volume (MWC, NOMWC, NONE)
SchedulePolicy	NVARCHAR(64)	Access Scheduling Policy of the logical volume. May have values such as (Striped, Sequential, Parallel)
NumberOfStripes	INT	Number of stripes for the logical volume.
StripeSize	INT	Size of stripes for logical volume. Value in KB.
BadBlockRelocation	BIT	Switch of Bad Block Relocation feature. True if it is on, false otherwise.
AllocationPolicy	NVARCHAR(64)	Allocation Policy of the logical volume. May contain values such as (Non-Strict, Non-Strict/Contiguous, Strict, Strict/Contiguous, PVG-Strict, PVG-Strict/Contiguous, PVG-Strict/Distributed, Unknown)
StaledLogicalExtent	INT	Counter of staled Logical Extent in the logical volume. This counter is valid only the logical volume is mirrored.
NumberReadAccesses	INT	Number of read accesses to the logical volume.
NumberWriteAccesses	INT	Number of write accesses to the logical volume.
Status	NVARCHAR(64)	Availability status of Logical Volume. May contain values such as {Available/State, Available/Syncd, Available, Unavailable}.

Column Name	Data Type	Description
NISServerService_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_NISServerService
SnapshotID	BIGINT	Snapshot partly identifies HPUX_NISServerService
Name	NVARCHAR(256)	Inherited from CIM_ManagedSystemElement.Name. The Name property defines the label by which the object is known.
SystemCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem.
SystemName	NVARCHAR(256)	Equates to CIM_ComputerSystem.Name where NodeID is equal.
CreationClassName	NVARCHAR(256)	Equates to HPUX_NISServerService.
ServerWaitFlag	SMALLINT	This attribute is the NIS Server Wait Flag. This flag makes the host wait for a response for the NIS server. An enumeration. 0 = Unknown 1 = Other 2 = Wait 3 = No Wait
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption. A short textual description of the object.
Description	NVARCHAR(512)	Inherited from CIM_ManagedElement.Description.Provides a textual description of the object.
ServerType	SMALLINT	Returns what type of NIS Server the managed system is. If the system is not a NIS server, returns None. An enumeration. 0 = Unknown 1 = Other 2 = None 3 = NIS Master 4 = NIS Slave

Column Name	Data Type	Description
NTPService_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_NTPService
SnapshotID	BIGINT	Snapshot partly identifies HPUX_NTPService
SystemCreationClassName	NVARCHAR(256)	Equates to CIM_ComputerSystem.
SystemName	NVARCHAR(256)	Equates to the value of CIM_ComputerSystem.Name where NodeID is equal.
CreationClassName	NVARCHAR(256)	Equates to HPUX_NTPService.
Name	NVARCHAR(256)	Inherited from CIM_ManagedSystemElement.Name. The Name property defines the label by which the object is known.
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption. A short textual description of the object.
ServerAddress	NVARCHAR(512)	This attribute is specified by hostname that appears in the file `/etc/hosts`, or it is an IP Address in dot notation format. Multiple servers are specified as comma delimited names.
Description	NVARCHAR(512)	Inherited from CIM_ManagedElement.Description. Provides a textual description of the object.

Column Name	Data Type	Description
PhysicalVolume_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_PhysicalVolume
SnapshotID	BIGINT	Snapshot partly identifies HPUX_PhysicalVolume
Name	NVARCHAR(256)	Name of Physical Volume in the System.
DeviceID	NVARCHAR(64)	Inherited from CIM_LogicalDevice.DeviceID. An address or other identifying information to uniquely name the LogicalDevice. May return the name of the physical volume. For example, /dev/dsk/c0t0d0.
AlternatePVName	NVARCHAR(256)	May return alternate physical volume path name. For example, `/dev/rdsk/c0t0d0`. Returns the same as DeviceID replacing "dsk" for "rdsk.
Status	NVARCHAR(32)	Availability status of Physical Volume. Returns (Available; Unavailable).
PhysicalExtentSize	BIGINT	Size in bytes. Calculated by multiplying HPUX_PhysicalVolume.BlockSize by the HPUX_PhysicalVolume.NumberOfBlocks.
Capacity	BIGINT	Capacity of the whole Physical Volume in number of Physical Extent.
Allocated	INT	Size of the allocated Physical Volume in number of Physical Extent.
Free	INT	Size of the free Physical Volume space in number of Physical Extent.
NumberStaledPEs	INT	Counter of Staled Physical Extent in the Physical Volume.

Column Name	Data Type	Description
Product_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_Product
SnapshotID	BIGINT	Snapshot partly identifies HPUX_Product
IdentifyingNumber	NVARCHAR(64)	Inherited from CIM_Product.IdentifyingNumber. Product identification such as a serial number on software, a die number on a hardware chip, or a project number.
Name	NVARCHAR(256)	Inherited from CIM_Product.Name. Commonly used Product name.
Version	NVARCHAR(64)	Inherited from CIM_Product.Version. A vendor-defined string describing the revision of the product.
Vendor	NVARCHAR(256)	Inherited from CIM_Product.Vendor. The name of the product supplier or entity selling the product (the manufacturer, reseller, or OEM).
Architecture	NVARCHAR(64)	A vendor-defined string used to distinguish variations of a product. It is used for presentation purposes and for resolving software specifications. If a product with the same value of the revision and Vendor Tag attributes has different versions of software for different target architectures or any other variation (such as supported locale), then the value of the architecture attribute is different for each version. No additional semantics are assumed for its value.
Location	NVARCHAR(256)	Used for resolving software specifications for installed software. A specific product location refers to all filesets of that product that are installed at that location. This is the path beneath which the relocatable files of that product are stored.
QualifierID	NVARCHAR(64)	Specified by a user when installing software and used for identifying a product (or set of product versions) using a logical name.
CreateTime	BIGINT	A value set by the implementation to be the time that the catalog information for this object was first written.Stored as MS since the Epoch.
Description	NVARCHAR(512)	Inherited from CIM_ManagedElement.Description.The Description property provides a textual description of the object.
ModificationTime	BIGINT	A value set by the implementation to be the time that the catalog information for this object was last written. Stored as MS since the Epoch.
Size	NVARCHAR(32)	The sum of the sizes in bytes of all files and control files contained within the software object. For objects other than filesets, the value is computed dynamically as required.
Caption	NVARCHAR(64)	Inherited from CIM_ManagedElement.Caption.The Caption property is a short textual description of the object.
AllFileSets	NVARCHAR(256)	Contains the actual filesets that make up a product. This is a list of all filesets defined for the product, as opposed to what is currently installed, described by the filesets attribute. The all_filesets attribute is used to determine completeness of this product when another software object has a dependency on this product. In checking a product pre-requisite or co-requisite, the existence of a fileset.tag in all_filesets that is not actually installed or available indicates that the dependency is not satisfied. This does not affect exrequisites because they test whether any of the contents of the dependency specification are present instead of all of the contents tested for pre-requisites or co-requisites.
ControlDirectory	NVARCHAR(256)	The name of the product control directory below which the control files for the product are stored within an exported catalog.
Copyright	NVARCHAR(256)	The copyright notice for the product.
Directory	NVARCHAR(256)	The vendor-defined directory commonly associated with the product. Generally, this will be the directory in or below which all (or mostly all) files within the product are installed. For a product which has filesets with the Is Locatable attribute equal to true, all files which contain this directory as the first part of their path can be relocated to the Location Directory during installation by replacing the product.directory portion with the product.location.
InstanceIdentifier	NVARCHAR(16)	A single attribute that distinguishes versions of products (and bundles) with the same Tag. It is a simple form of the version distinguishing attributes, valid only within the context of an exported catalog.
ISLocatable	bit	A boolean value indicating whether any of the filesets in the product have the Is Locatable attribute set to true.
PostKernelPath	NVARCHAR(256)	The path to the script that is run after the kernel filesets have been installed. Any product containing kernel filesets should include this path. If this attribute is supplied, the corresponding script is executed if it exists relative to the root directory of the installed software. If this attribute is not supplied, then the implementation defined path (the default value for the attribute) is used if it exists relative to the root directory of the installed software. Note that the use of an alternative root directory may mean that the default path does not exist relative to the root directory of the installed software.
LayoutVersion	NVARCHAR(64)	This attribute, and its value, are included for future use.
MachineType	NVARCHAR(64)	A software pattern matching string describing valid machine members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
SKUNumber	NVARCHAR(64)	The semantics associated with the values of this attribute are undefined. This attribute can be used to store such vendor-defined values as part number, order number, or serial number.
OperatingSystemName	NVARCHAR(256)	A software pattern matching string describing valid sysname members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
OperatingSystemRelease	NVARCHAR(256)	A software pattern matching string describing valid release members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
OperatingSystemVersion	NVARCHAR(64)	A software pattern matching string describing valid version members of the uname structure as defined by POSIX.1 (2), section 4.4.1. It is used for determining compatibility.
ISPatch	bit)	A Boolean value indicating whether this software object is a patch.
InstallSource	NVARCHAR(128)	Location of source from where software was installed.
DataModelRevision	NVARCHAR(8)	Supplies information on version of POSIX compatibility and corresponds to the operating system release that packaged or installed the software.
InstallDate	BIGINT	Date timestamp of day, month, year, and time when the software was installed on the system. Stored as MS since the Epoch.

Column Name	Data Type	Description
VolumeGroup_LUID	BIGINT	LUID uniquely defining this table row
NodeID	BIGINT	Node partly identifies HPUX_VolumeGroup
SnapshotID	BIGINT	Snapshot partly identifies HPUX_VolumeGroup
CollectionID	NVARCHAR(64)	Inherited from CIM_DiskGroup.CollectionID. The identification of the Collection object.
Name	NVARCHAR(256)	Name of Volume Group in the System.
AccessPermission	NVARCHAR(64)	Access Permission of Volume Group in the System. Can be one of the following (Read-Only; Read-Write).
Status	NVARCHAR(32)	Availability status of Volume Group in the System. Can be one of the following values {Available; Unavailable}
PhysicalExtentSize	INT	The size of the fundamental physical extent size in bytes.
Capacity	INT	Capacity of whole Volume Group in number of Physical Extent.
Allocated	INT	Allocated space in the volume group in number of Physical Extent.
FreeSpace	INT	Number of free Physical Extents in the volume group.
MaxNumberOfPVs	INT	Max number of definable physical volume in the volume group.
NumberOfDefinedPVs	INT	Number of max allocatable Physical Extent from physical volume.
NumberOfActivePVs	INT	Number of current defined physical volume in the volume proup.
MaxNumberOfLVs	INT	Max number of definable logical volume in the volume group.
NumberOfDefinedLVs	INT	Number of current defined logical volume in the volume group.
NumberOfActiveLVs	INT	Number of current activel logical volume in the volume group.
NumberOfPVGroups	INT	Total number of physical volume group in this volume group.

The IPAddress table contains the known IP addresses for the devices. The IPAddress fields are defined in the following table.

Column Name	Data Type	Description
*DeviceKey	INT	ssociates a device with its collected set of data. System information is linked to the device table using the DeviceKey.
*ipindex	INT	The addresses index for the system, for example, 0 is the first IP address. 1 is the second, and etc.
*IPAddress	CHAR (16)	TCP/IP address (x.x.x.x)
IPAddressNumber	bigint	A numeric representation of the IP address
MACaddr	CHAR (12)	The MAC address of the device network card (without and delimiter, such as “:” or “-“)
IPsubnetMask	CHAR (16)	The TCP/IP subnet mask (x.x.x.x)
IFType	IFType	The interface type

The IPXAddress table contains the known IPX addresses for the systems. The IPXAddress fields are defined in the following table.

Column Name	Data Type	Description
*DeviceKey	INT	Associates a device with its collected set of data. System information is linked to the devices table using the DeviceKey.
*IpxIndex	INT	A unique IPX index for the system used mainly when 2 or more IPX addresses exist for a system.
*IPXAddress	CHAR (25)	IPX address for this device.

Column Name	Data Type	Description
Snapshot_LUID	BIGINT	Snapshot partly identifies NodeSnapshot
NodeID	BIGINT	Node partly identifies NodeSnapshot
Tag	NVARCHAR(256)	Contains the user-defined tag.
Description	NVARCHAR(512)	Description of the user-defined tag.
CollectionDateTime	BIGINT	Stored as MS since the Epoch.
DetailedInformation	nvarchar(512)	Additional collection status information
ReturnCode	SMALLINT	Binary status information. Zero indicates no error
Status	NVARCHAR(256)	Status of the snapshot for the node. Used by different reports.
DataAvailable	INT	Currently unused, reserved
FilterID	BIGINT	Currently unused, reserved for collection filter ID

The Notices table contains all the events received or generated, such as Discovered Device events, SNMP traps, and so on. The Notices fields are defined in the following table.

Column Name	Data Type	Description
*NoticeId	INT	Unique identifier for this notice instance.
State	INT	1=In Progress 2=Not Cleared (active) 5=Cleared
NoticeType	INT	Index into the noticeType table.
NoticeSeverity	INT	1 = Normal 2 = Warning 3 = Minor 4 = Major 5 = Critical 100 = Informational
NoticePriority	INT	RESERVED
DeviceKey	INT	Index into the devices table.
Generated	bigint	Date/time notice was generated or received represented as the number of milliseconds since 1970 UTC.
Cleared	bigint	Date/time notice was cleared represented as the number of milliseconds since 1970 UTC
Completed	bigint	RESERVED
LastChecked	bigint	RESERVED
LastModifed	bigint	Date/time notice was cleared represented as the number of milliseconds since 1970 UTC.
JobID	char(128)	If this notice is related to some job, this will be the job ID for that job.
Timestamp	bigint	RESERVED
AssignedTo	VARCHAR (255)	Usernames to which an event is assigned
Comments	VARCHAR(1000)	User input comments for one or more events

The NoticeTypes table defines all of the event types that can be processed. The NoticeType 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