Jump to content English
hp.com home
HP Systems Insight Manager  |  Using Default Tools  |  Database Tables

Using Default Tools
Database Tables

» HP Systems Insight Manager

»Table of Contents
»Index
»Product Overview
»Getting Started
»Monitoring Systems, Events, and Clusters
»Using Tasks
»Using Default Tools
»Command Line Tools
»Cluster Monitor
»Custom Command Tools
»Device Ping
»Disk Thresholds
»Storage Integration
»License Manager
»Managing Tools
»Plug-in Tools
»Property Pages
»Replicate Agent Settings
»MIBs
»System Management Homepage
»System Page
»Version Control
Database Tables
»Reporting
»Administering the Software
»Troubleshooting
»Printable Version
»Glossary
»Using Help
Content starts here
» Introduction
» Pre-defined Views
» Database Tables

Introduction

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.

Only the HP Systems Insight Manager application should add or delete from these tables. Any other modifications to these tables cause cache coherency problems for the application.

The database contains:

  • Events

  • Discovered systems

  • System status

  • User preferences

  • Detailed system information

  • Language text (English only)

You should back up the database on a regular basis and monitor the size of the database to expand it as necessary.

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.

Pre-defined Views

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 database and views are not deleted when you uninstall HP Systems Insight Manager

Database Tables

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:

 Column Name  Data Type  Description
Chassis_LUIDBIGINTLUID uniquely defining this row
NodeIDBIGINTPartly identifies CIM_Chassis
SnapshotIDBIGINTPartly identifies CIM_Chassis
CreationClassNameNVARCHAR(256)Partly identifies CIM_Chassis equates to CIM_Chassis
TagNVARCHAR(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_SystemCreationClassNameNVARCHAR(256)If the chassis is part of a rack then this attribute is CIM_Rack, otherwise CIM_ComputerSystem
dc_SystemNameNVARCHAR(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
NameNVARCHAR(256)A label by which the object is known
WidthrealInherited from CIM_PhysicalPackage.Width, and is the width of the Physical Package in inches
HeightrealInherited from CIM_PhysicalPackage.Height, and is the height of the Physical Package in inches
DepthrealInherited from CIM_PhysicalPackage.Depth, and is the depth of the Physical Package in inches
SerialNumberNVARCHAR(64)Inherited from CIM_PhysicalElement.SerialNumber, and is a manufacturer-allocated number used to identify the Physical Element
PartNumberNVARCHAR(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
ModelNVARCHAR(64)Inherited from CIM_PhysicalElement.Model, and is the name by which the Physical Element is generally known
ChassisTypesSMALLINTAn 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

TypeDescriptionsNVARCHAR(512)Additional information about the CIM_Chassis.ChassisTypes
VersionNVARCHAR(64Inherited from CIM_PhysicalElement.Version, and is a string indicating the version of the PhysicalElement
OtherIdentifyingInfoNVARCHAR(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_Modelnvarchar(256)A field used by reporting

 Column Name  Data Type Description
ComputerSystem_LUIDBIGINTLUID uniquely defining this table row
NodeIDBIGINTPartly identifies CIM_ComputerSystem
SnapshotIDBIGINTPartly identifies CIM_ComputerSystem
NameNVARCHAR(256)Serves as key of a System instance in an enterprise environment
CreationClassNameNVARCHAR(256)Partly identifies CIM_ComputerSystem, and equates to CIM_ComputerSystem
DescriptionNVARCHAR(512)Inherited from CIM_ManagedElement.Description, and is a textual description of an object
CaptionNVARCHAR(64)Inherited from CIM_ManagedElement.Caption, and is a short textual description (one line string) of the object
StatusNVARCHAR(10)Inherited from CIM_ManagedSystemElement.Status, and is a string indicating the current status of the object
PrimaryOwnerContactNVARCHAR(256)A string that provides information on how the primary system owner can be reached
PrimaryOwnerNameNVARCHAR(64)The name of the primary system owner
dc_PrimaryOwnerPagerNVARCHAR(32)Not standard, based on CIM_Person.Pager, and includes pager information for the primary owner
dc_SystemLocationNVARCHAR(256)Not standard, and includes information describing the physical location of this system
dc_HardwareCapabilityNVARCHAR(64)Not standard, and is the hardware capability (32 and 64 bits) of the system
R_OverallStatusNVARCHAR(50)A field used by reporting
R_ProductTypeNVARCHAR(256)A field used by reporting

 Column Name  Data Type Description
IPRoute_LUIDBIGINT 
LUID uniquely defining this table rowBIGINTPartly identifies CIM_IPRoute
SnapshotIDBIGINTPartly identifies CIM_IPRoute
CreationClassNameNVARCHAR(256)Equates to CIM_IPRoute
ServiceCreationClassNameNVARCHAR(256) For future use
ServiceNameNVARCHAR(256)For future use
SystemCreationClassNameNVARCHAR(256)Equates to CIM_ComputerSystem
SystemNameNVARCHAR(256)The value of CIM_ComputerSystem.Name with equal NodeID
IPDestinationAddressNVARCHAR(256) 
IPDestinationMaskNVARCHAR(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.
AddressTypeSMALLINTAn 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).
IsStaticbitTrue indicates that this is a static route, and False indicates a dynamically-learned route
NextHopNVARCHAR(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_RouteArgumentNVARCHAR(1024)Not standard, and is the argument list for the /usr/sbin/route command

 Column Name  Data Type Description
LogicalDevice_LUIDBIGINTLUID uniquely defining this table row
NodeIDBIGINTPartly identifies CIM_IPRoute
SnapshotIDBIGINTPartly identifies CIM_IPRoute
DeviceIDNVARCHAR(64)An address or other identifying information to uniquely name the Logical Device
CreationClassNameNVARCHAR(256)CreationClassName partly identifies CIM_LogicalDevice and equates to CIM_LogicalDevice
ServiceCreationClassNameNVARCHAR(256)SystemCreationClassName partly identifies CIM_LogicalDevice and equates to CIM_ComputerSystem
SystemNameNVARCHAR(256)SystemName partly identifies CIM_LogicalDevice, and is the value of CIM_ComputerSystem.Name with equal NodeID
NameNVARCHAR(256)A label by which the object is known
CaptionNVARCHAR(64)Inherited from CIM_ManagedElement.Caption, and is a short textual description (one line string) of the object
DescriptionNVARCHAR(512)A textual description of the object
AvailabilitySMALLINTThe 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

LastErrorCodeINTCaptures the last error code reported by the Logical Device
dc_HardwareTypeNVARCHAR(64)Not standard, and is the hardware type for this system
OtherIdentifyingInfoNVARCHAR(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_AssociatedDriverNVARCHAR(64)Not standard, and the associated driver for this system

 Column Name  Data Type Description
LogicalDisk_LUIDBIGINTLUID uniquely defining this table row
NodeIDINTPartly identifies CIM_LogicalDisk
SnapshotINTPartly identifies CIM_LogicalDisk
DeviceIDNVARCHAR(64)Inherited from CIM_LogicalDevice.DeviceID, and is an address or other identifying information to uniquely name the Logical Device
CreationClassNameNVARCHAR(256)Equates to CIM_LogicalDisk
SystemCreationClassNameNVARCHAR(256)Equates to CIM_ComputerSystem
SystemNameNVARCHAR(256)The value of CIM_ComputerSystem.Name with equal NodeID
Win32_FreeSpaceBIGINTDerived from Win32_LogicalDisk, and is the total amount of free space in bytes
Win32_SizeBIGINTDerived from Win32_LogcialDisk, and is the total size in bytes. If unkown, enter 0. Units (bytes).
DescriptionNVARCHAR(512)A textual description of the object
R_SizeMBNVARCHAR(256)A field used by reporting
R_UsedMBNVARCHAR(256)A field used by reporting
R_UsedPercentNVARCHAR(256)A field used by reporting
dc_SpaceUsedBIGINTNot standard, and is the file system space currently in use in bytes
dc_PercentSpaceUsedINTNot standard, and is the percent of file system space currently in use

 Column Name  Data Type Description
MediaAccessDevice_LUIDBIGINTLUID uniquely defining this table row
NodeIDBIGINTPartly identifies CIM_MediaAccessDevice
SnapshotIDBIGINTPartly identifies CIM_MediaAccessDevice
DeviceIDNVARCHAR(64)Inherited from CIM_LogicalDevice.DeviceID, and is an address or other identifying information to uniquely name the Logical Device
CreationClassNameNVARCHAR(256)Equates to CIM_MediaAccessDevice
SystemCreationClassNameNVARCHAR(256)Equates to CIM_ComputerSystem
SystemNameNVARCHAR(256)The value of CIM_ComputerSystem.Name for this NodeID
NameNVARCHAR(256)A label by which the object is known
DescriptionNVARCHAR(512)A textual description of the object
MaxMediaSizeBIGINTMaximum size, in KB, of media supported by this system. KB is interpreted as the number of bytes X 1000 not bytes X 1024.
UnitsUsedBIGINTAn 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.
DefaultBlockSizeBIGINTDefault block size, in bytes. Units (bytes)
OtherIdentifyingInfoNVARCHAR(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.
TotalPowerOnHoursBIGINTInherited from CIM_LogicalDevice.TotalPowerOnHours, and is the total number of hours that this Device has been powered.Units (Hours).
UnitsDescriptionNVARCHAR(256)Defines units relative to its use in the property, MaxUnitsBeforeCleaning. Describes the criteria used to determine when the MediaAccessDevice should be cleaned.
NeedsCleaningBITIndicates the MediaAccessDevice needs cleaning.
StatusNVARCHAR(10)Inherited from CIM_ManagedSystemElement.Status. A string indicating the current status of the object.
MAStatInf_UnrecoverableWriteOpINTCorresponds to MediaAccessStatInfo_UnrecoverableWriteOperations. CIM_MediaAccessStatInfo.UnrecoverableWriteOperations. The number of unrecoverable write operations.
MAStatInf_UnrecoverableReadOpINTCorresponds to MediaAccessStatInfo_UnrecoverableReadOperations. CIM_MediaAccessStatInfo.UnrecoverableReadOperations. The number of unrecoverable read operations.
dc_TypeNVARCHAR(64)Not standard. A string describing the type of media used to access the system.
dc_TransferModeNVARCHAR(64)

Not standard. Compaq ATA Disk Transfer Mode.

  • other

  • pioMode0

  • pioMode1

  • pioMode2

  • pioMode3

  • pioMode4

  • dmaMode0

  • dmaMode1

  • dmaMode2

  • ultraDmaMode0

  • ultraDmaMode1

  • ultraDmaMode2

  • ultraDmaMode3

  • ultraDmaMode4

  • ultraDmaMode5

R_DrivePortnvarchar(256)A field used by reporting.
R_Typenvarchar(64)A field used by reporting.

 Column Name  Data Type Description
NetworkAdapter_LUIDBIGINTLUID uniquely defining this table row
NodeIDBIGINTPartly identifies CIM_NetworkAdapter.
SnapshotIDBIGINTPartly identifies CIM_NetworkAdapter.
CreationClassNameNVARCHAR(256)Equates to CIM_NetworkAdapter.
DeviceIDNVARCHAR(64)Inherited from CIM_LogicalDevice.DeviceID. An address or other identifying information to uniquely name the Logical Device.
SystemCreationClassNameNVARCHAR(256)Equates to CIM_ComputerSystem.
SystemNameNVARCHAR(256)The value of CIM_ComputerSystem.Name for this NodeID.
NameNVARCHAR(256)A label by which the object is known.
NetworkAddressNVARCHAR(64)An array of strings indicating the network addresses for an adapter. Represented by a comma separated list.
StatusInfoSMALLINTInherited 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

PermanentAddressNVARCHAR(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.
CaptionNVARCHAR(64)Inherited from CIM_ManagedElement.Caption. A short textual description (one line string) of the object.
EthernetAdp_InternalMACRcvErrINTA 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_Duplexnvarchar(25)A field used by reporting
R_MacAddressnvarchar(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_CSDVersionnvarchar(256)Not standard. CSD version/Service Pack level of OS from Windows systems.
dc_SwapSpaceNamenvarchar(256)Not standard. Name identifying the swap space.
dc_SwapTypenvarchar(64)Not standard. Type description of swap space.
dc_SwapSpaceMinimumSizeBIGINTNot standard. Minimum size of swap space.
dc_SwapSpaceMaximumSizeBIGINTNot standard. Maximum size of swap space.
dc_SwapSpaceReservedSizeBIGINTNot 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_HWLocationnvarchar(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_HWLocationnvarchar(256)Not standard. A text description of the hardware location, on complex multi-SBB hardware only, for the memory element.
R_SlotSMALLINTA 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_ModulePathNVARCHAR(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_CPUStatusnvarchar(256)A field used by reporting.
dc_HWLocationnvarchar(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_Typenvarchar(64)A field used by reporting.

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

These fields can be edited through OptionsCluster MonitorCluster Settings:

  • Contact Person

  • Contact Phone

  • Contact Email

  • Contact Pager

  • Dial Out Modem

  • Dial In Modem

  • Cluster Location

  • Applications

  • Comments

 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.

 

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

The ClusterNodeInfo fields are defined in the following table.

These fields can be edited through OptionsCluster MonitorNode Settings:

  • Contact Person

  • Contact Phone

  • Contact E-mail

  • Contact Pager

  • Dial Out Modem

  • Dial In Modem

  • Cluster Location

  • Applications

  • Comments

 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.

 

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

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).  

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

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.  
OSTypeCHAR(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.  
OSVendorCHAR(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.  
TrustStatusInt System trust state for HP Web enabled agents;.

 

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

 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.  

 

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

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.
ProductTypeINTThe product type for this item. See the nodeTypesEnum table, which is best viewed using the deviceSubTypesEnum view, for additional information.
ProductTypeStrChar(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
MxGUIDCHAR(32)The HP Systems Insight Manager uniquely assigned identifier for this system.

The Device Protocol Information fields are defined in the following table.

 Column Name  Data Type  Description
DeviceKeyINTThe DeviceKey associates this table with the system in the devices table.
IPAddressableINTFlag indicating if this device is addressable through TCP/IP.
IPXAddressableINTFlag indicating if this device is addressable through IPX.
SNMPINTFlag 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.
SNMPverStrNCHAR(32)A string indicating what version of SNMP was detected. Currently HP Systems Insight Manager only supports “1.0”
HTTPINTFlag 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.
DMIINTFlag 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.
DMIVerStrNCHAR(32)Always 2.0.
WBEMINTIf WBEM is detected on the system, then this is set to 1. Otherwise, 0.
WBEMverStrNCHAR(32)The version of WBEM that HP Systems Insight Manager found on the system.
SSHINTIf SSH was detected on the system this is set to 1. Otherwise, 0.
SSHverStrNCHAR(64)The System ID returned from the SSH request.
PrimaryAddressnchar(32)For future expansion.
WMIProxyIDINTThe 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.
networkRetriesINTThe number of retries to be used for SNMP requests
icmpTimeoutINTICMP ping timeout value in seconds
icmpRetriesINTThe 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

 

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

 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

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

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.

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

 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.

DetailedInformationnvarchar(512)Additional collection status information
ReturnCodeSMALLINTBinary status information. Zero indicates no error

Status

NVARCHAR(256)

Status of the snapshot for the node. Used by different reports.

DataAvailableINTCurrently unused, reserved
FilterIDBIGINTCurrently 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

 

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

The NoticeTypes table defines all of the event types that can be processed. The NoticeType fields are defined in the following table.

 Column Name 

 Data Type 

Description

*NoticeType

INT

System assigned identifier.

GUID

Char(32)

Unique system assigned identifier.

TypeIdStr

CHAR (255)

A unique String Identification for the event.

dispHandler

CHAR (255)

Internal handler for the display of the event.

rxHandlerChar(255)Internal handler for event reception, usually blank.
defaultSeverityIntA default severity to use for the event.
PrivilegeIntThe internal privilege level a user must have to view the event details.

ServiceEnable

INT

Used when the CRSM is installed.

ServiceEnable

INT

Used when the CRSM is installed.

ProviderID

INT

Used when the CRSM is installed.

 

An asterisk (*) indicates that the field is part of the primary key of the table. Where multiple fields in the same table show an asterisk, the primary key connects to each.

 Column Name 

 Data Type 

Description

SnapshotID

BIGINT

LUID uniquely defining the snapshot

OverallStatus

NVARCHAR(64)

OverallStatus of the Snapshot: Code indicating if the snapshot was successful.

SnapshotTag

NVARCHAR(256)

Contains the user-defined tag.

CollectionDateTime

BIGINT

Stored as MS since the Epoch.