HP Systems Insight Manager 7.
© Copyright 2010, 2013 Hewlett-Packard Development Company, L.P. Legal Notices Confidential computer software. Valid license from HP required for possession, use or copying. Consistent with FAR 12.211 and 12.212, Commercial Computer Software, Computer Software Documentation, and Technical Data for Commercial Items are licensed to the U.S. Government under vendor's standard commercial license. The information contained herein is subject to change without notice.
Contents About this document......................................................................................9 Publishing History.....................................................................................................................9 1 HP SIM database tables............................................................................10 Predefined views....................................................................................................................10 Database tables.....
CIM_RemoteServiceAccessPoint table...................................................................................40 CIM_SCSIProtocolController table........................................................................................40 CIM_SCSIProtocolEndpoint table..........................................................................................40 CIM_Rack table.................................................................................................................
deviceAttributes table.........................................................................................................60 deviceLicenseInfo table.......................................................................................................60 deviceMxObjValues table...................................................................................................61 DeviceNames table............................................................................................................
hpmxNodeAuthorization table.............................................................................................80 hpmxNodeGroup table......................................................................................................80 hpmxNodeGroupAuthorization table....................................................................................80 hpmxNodeGroupObjects table............................................................................................81 hpmxObject table.........
mibIndexes table.............................................................................................................107 mibItems table.................................................................................................................107 mibOSToVCOS table........................................................................................................107 NetPort_ProtoEndpoint table..............................................................................................
tableIndexes table............................................................................................................122 tableVersions table...........................................................................................................122 taskQueryContents table...................................................................................................122 Tasks table...................................................................................................................
About this document Publishing History Manufacturing Part Number Supported Operating Systems Supported Versions Edition Number Publication Date 701813-002 HP-UX, Windows XP, Linux Current Edition 1 March 2013 701813-001 HP-UX, Windows XP, Linux Current Edition 2 August 2012 701813-001 HP-UX, Windows XP, Linux Current Edition 1 June 2012
1 HP SIM database tables HP SIM uses a Microsoft SQL Server 2000 Service Pack 3, MSDE r Microsoft SQL Server 2005 Express Edition (Windows Install), or PostgreSQL SQL 7.4.x (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. However, configuration of HP SIM database tables cannot be performed on a remote system.
associated_device_data table Column Name Data Type deviceKey INT associatedDeviceKey INT associatedDeviceName NVARCHAR(256) associatedDeviceStatus INT associatedDeviceType INT AssociationTypeNumber CHAR(80) Description AuthenticationMethods_values table Column Name Data Type Description AuthenticationMethodsId BIGINT Uniquely defines this row AuthenticationMethodsValue SMALLINT Used for reporting purposes AuthenticationMethodsPos SMALLINT Used for reporting purposes Column Name D
CIM_ActiveConnection table Column Name Data Type Description Antecedent BIGINT A ServiceAccessPoint that is configured to communicate and/or is actively communicating with the Dependent SAP. In a unidirectional connection, this is the SAP that is transmitting. Dependent BIGINT A second ServiceAccessPoint that can communicate with the Antecedent SAP. In a unidirectional connection, this is the SAP that is receiving the communication.
Column Name Data Type Description Width real Inherited from CIM_PhysicalPackage.Width and is the width of the Physical Package in inches Height real Inherited from CIM_PhysicalPackage.Height and is the height of the Physical Package in inches Depth real Inherited from CIM_PhysicalPackage.Depth and is the depth of the Physical Package in inches SerialNumber NVARCHAR(64) Inherited from CIM_PhysicalElement.
CIM_ComputerSystem table Column Name Data Type Description ComputerSystem_LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Partly identifies CIM_ComputerSystem SnapshotID BIGINT Partly identifies CIM_ComputerSystem Name NVARCHAR(256) The inherited Name serves as key of a System instance in an enterprise environment CreationClassName NVARCHAR(256) CreationClassName indicates the name of the class or the subclass used in the creation of an instance (When used with the other key
CIM_ControlledBy table Column Name Data Type Description Dependent BIGINT The controlled Device Antecedent BIGINT The controller CIM_DeviceSAPImplementation table Column Name Data Type Description Dependent BIGINT The ServiceAccessPoint implemented using the LogicalDevice Antecedent BIGINT The LogicalDevice CIM_DeviceSoftwareIdentity table Column Name Data Type Description System BIGINT Used for reporting purposes InstalledSoftware BIGINT Used for reporting purposes Column Name D
Column Name Data Type Description ActiveCooling BIT ActiveCooling is a boolean indicating that the Cooling Device provides active (as opposed to passive) cooling FanType SMALLINT An enumeration describing the cooling device type (0 = Unknown , 1 = Other , 2 = Cabinet Blower , 3 = Compute Cabinet I/O Fans , 4 = I/O Expansion Cabinet Utility Chassis Fan , 5 = I/O Expansion Cabinet I/O Fan , 6 = Processor Fan ) Location NVCHAR(255) Physical location of a cooling device.
Column Name Data Type dc_SpaceUsed bigint dc_PercentSpaceUsed int Description CIM_HostedStoragePool table Column Name Data Type Description GroupComponent BIGINT The parent system in the Association PartComponent BIGINT The StoragePool that is a component of a system Column Name Data Type Description IPProtocolEndpoint _LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Partly identifies CIM_IPProtocolEndpoint SnapshotID BIGINT Partly identifies CIM_IPProtocolEndpoint
Column Name Data Type Description defined before NextHopRouting and are Key properties. They cannot be removed. ModelCorrespondence indicates that they should be set to equivalent values for consistency and ease of searching.) AddressType SMALLINT An enumeration that describes the format of the address property (Addresses that can be formatted in IPv4 format must be formatted that way to ensure mixed IPv4/IPv6 support.
Column Name Data Type Description InstanceID NVARCHAR(255) Used for reporting purposes ConnectionID INT Used for reporting purposes HeaderDigestMethod SMALLINT Used for reporting purposes OtherheaderDigestMethod NVARCHAR(255) Used for reporting purposes DataDigestMethod SMALLINT Used for reporting purposes OtherDataDigestMethod NVARCHAR Used for reporting purposes ActiveiSCSIVersion BIT Used for reporting purposes Column Name Data Type Description ISCSISession_LUID BIGINT LUID u
Column Name Data Type Description Description NVARCHAR(512) A textual description of the object Availability SMALLINT The primary availability and status of the system and is an enumeration.
Column Name Data Type Description dc_PercentSpaceUsed INT Not standard and is the percent of file system space currently in use BlockSize BIGINT Size in bytes of a block on the logical disk. NumberOfBlocks BIGINT Number of storage block in the logical disk; size in bytes can be calculated from BlockSize * NumberOfBlocks.
Column Name Data Type Description could be used to identify a LogicalDevice. One example would be to hold the Operating System user-friendly name for the Device in this property.) TotalPowerOnHours BIGINT Inherited from CIM_LogicalDevice.
Column Name Data Type Description SnapshotID BIGINT Partly identifies CIM_NetworkAdapter CreationClassName NVARCHAR(256) Equates to CIM_NetworkAdapter DeviceID NVARCHAR(64) Inherited from CIM_LogicalDevice.DeviceID; (an address or other identifying information to uniquely name the Logical Device) SystemCreationClassName NVARCHAR(256) Equates to CIM_ComputerSystem SystemName NVARCHAR(256) The value of CIM_ComputerSystem.
Column Name Data Type Description count of receive errors on a particular interface that are not otherwise counted.) 24 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 the LateCollisions property, the Excessive Collisions property, or the CarrierSenseErrors property.
Column Name Data Type Description EthernetPort_PortType SMALLINT Integer code for port type if Ethernet: ValueMap {"0", "1", "50", "51", "52", "53", 16000..
CIM_OperatingSystem table 26 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.
Column Name Data Type Description CurrentTimeZone SMALLINT Indicates the number of minutes the operating system is offset from GMT; the number is +,-,or 0 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 TotalSwapSpaceSize BIGINT Total swap space in Kb; can be null if swap space is not distinguished from page files OtherTypeDescription NVARCHAR(64)
Column Name Data Type Description 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.
Column Name Data Type Description dc_HWLocation NVARCHAR(256) Not standard; a text description of the hardware location, on complex multi-SBB hardware only, for the element dc_ProductID NVARCHAR(64) The product ID string of the server blade 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)
Column Name Data Type Description should be assumed that no filemarks or blank space areas are recorded on the Media.) 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.
Column Name Data Type Description 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.
CIM_PhysicalPackage table Column Name Data Type Description PhysicalPackage _LUID BIGINT LUID uniquely defining this table row NodeID BIGINT System partly identifies CIM_PhysicalPackage SnapshotID BIGINT Snapshot partly identifies CIM_PortController ElementName NVARCHAR(255) Used for reporting purposes Name NVARCHAR(1024) A label by which the object is known Tag NVARCHAR(256) Used for reporting purposes CreationClassName NVARCHAR(256) Used for reporting purposes Manufacturer NVARCHA
CIM_PowerSupply table 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.
Column Name Data Type Description device could be running Diagnostics (AdditionalAvailability value=5, \"In Test\"). See CIM_PowerSupply.Availabiltiy enumeration.
Column Name Data Type Description latitude and longitude information, for example, from a GPS. It is part of the key of the Location object.
Column Name Data Type Description 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.
CIM_Processor table 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.
Column Name Data Type Description UniqueID NVARCHAR(256) A globally unique identifier for the processor (This identifier might 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).
Column Name Data Type Description Vendor NVARCHAR(256) The name of the Product's supplier or entity selling the product Version NVARCHAR(64) Product version information; corresponds to the Version property in the Product object in the DMTF Solution Exchange Standard CIM_ProtoControlAccessesUnit table Column Name Data Type Description ProtoControlAccessUnit _LUID BIGINT Used for reporting purposes ProtoControlAccessUnit _LUID BIGINT Used for reporting purposes CIM_ProtocolControllerForPort
Column Name Data Type Description SystemCreationClassname NVARCHAR(256) Used for reporting purposes SystemName NVARCHAR(256) The value of CIM_ComputerSystem.
Column Name Data Type Description SnapshotID BIGINT Snapshot partly identifies CIM_SCSIProtocolEndpoint Name NVARCHAR(1024) A label by which the object is known SystemCreationClassName NVARCHAR(256) Used for reporting purposes SystemName NVARCHAR(256) The value of CIM_ComputerSystem.
Column Name Data Type Description SystemCreationClassName NVARCHAR(256) SystemCreationClassName partly identifies CIM_Sensor (If the sensor is owned by a chassis, then this field equates to CIM_Chassis; otherwise it is set to CIM_ComputerSystem.) SystemName NVARCHAR(256) Equates to CIM_Sensor.Name or CIM_ComputerSystem.
Column Name Data Type Description 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).
Column Name Data Type Description dc_OtherVersionInfo NVARCHAR(64) Not standard. A string that specifies the version of this item R_Type NVARCHAR(64) A field used by reporting.
Column Name Data Type Description Classification SMALLINT 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) IdentifyInfoValue NVARCHAR(256) Key file name.
Column Name Data Type Description R_Status NVARCHAR(256) A field used by reporting LatestVersion NVARCHAR(100) Stores the latest version of each software with a matching component in the repository SWFWBaselineVersion NVARCHAR(100) Stores the version of software available in the VCRM’s sw fw baseline Column Name Data Type Description StoragePool_LUID BIGINT Used to uniquely identify CIM_StorageVolume NodeID BIGINT Used to partially identify CIM_StorageVolume SnapShotID BIGINT Used to
Column Name Data Type Description PackageRedundancy SMALLINT Used for reporting purposes Name NARCHAR(1024) A label by which the object is known SystemCreationClassName NARCHAR(256) Used for reporting purposes SystemName NARCHAR(256) The value of CIM_ComputerSystem.
clusterAlgorithm table Column Name Data Type ClusterAlgorithmClassName CHAR(128) Sequence INT Description clusterDeviceCMX table Column Name Data Type DeviceKey INT CMX_TYPE INT Description clusterInfo table Column Name Data Type ClusterDeviceKey INT ClusterType INT ContactPerson NCHAR(256) ContactPhone CHAR(128) ContactPager CHAR(128) ContactEmail CHAR(128) DialOutModem CHAR(128) DialInModem CHAR(128) ClusterLocation NTEXT Applications NTEXT Comments NTEXT UpdateTime
Column Name Data Type Comments NTEXT UpdateTime BIGINT Description clusterType table Column Name Data Type ClusterType INT ClusterDvUrlType CHAR(128) ClusterProdId CHAR(128) ClusterProdName CHAR(128) ClusterVendor CHAR(128) Description CHAR(255) NodeDvUrlType CHAR(128) Description cmEventText table Column Name Data Type NoticeId INT TextIndex INT PropertyLabel VARCHAR(256) NumOfParams INT Param1 VARCHAR(256) Param2 VARCHAR(256) Param3 VARCHAR(256) Param4 VARCHAR(256)
Column Name Data Type AggregationURL CHAR(128) DeviceSupportClass CHAR(128) HasGlobalProperties INT HasNodalProperties INT Description collectionMembers table Column Name Data Type CollectionLUID BIGINT MemberObjectID VARCHAR(32) ObjectType VARCHAR(32) Position INT IsHidden SMALLINT DisplayStatusFlag SMALLINT EditFlags INT DefaultView VARCHAR(64) Description collections table Column Name Data Type Description LUID Name NVARCHAR(80) DefaultView VARCHAR(256) IsHidden SMAL
ComputerSys_LogicalPortGroup table Column Name Data Type Description Antecedent BIGINT Used for reporting purposes Dependent BIGINT Used for reporting purposes ComputerSys_MediaAccessDev table Column Name Data Type Description GroupComponent BIGINT Used for reporting purposes PartComponent BIGINT Used for reporting purposes Column Name Data Type Description GroupComponent BIGINT Used for reporting purposes PartComponent BIGINT Used for reporting purposes ComputerSys_NetworkPort ta
ComputerSys_SoftwareIdent table Column Name Data Type Description System BIGINT Used for reporting purposes InstalledSoftware BIGINT Used for reporting purposes Column Name Data Type Description GroupComponent BIGINT Used for reporting purposes PartComponent BIGINT Used for reporting purposes Column Name Data Type Description NodeID VARCHAR(32) Used for reporting purposes UserId VARCHAR(32) Used for reporting purposes Column Name Data Type Description DeviceKey INT jobID VAR
Column Name Data Type Description encrAuthPassphrase NVARCHAR(256) Authentication PassPhrase privProtocol TINYINT Privacy protocol encrPrivPassphrase NVARCHAR(256) Privacy Passphrase Column Name Data Type Description DeviceKey INT CpuIndex INT UpdateTime DATETIME CpuName CHAR(100) CpuSpeed INT DB_DeviceCpu table DB_DeviceInfo table The DB_DeviceInfo table contains general system information. Any system that supports SNMP has information in this table.
Column Name Data Type Description OSName CHAR (100) Operating system name.
DC_DMIVars table Abstract Column Name Data Type MifId INT PrefMifName CHAR(64) DefiningBody CHAR(64) GroupName CHAR(64) SameGroupName CHAR(64) Version CHAR(8) AttributeId INT AttributeStr CHAR(64) AttributeVal CHAR(64) IndexInfo INT Description DC_Enclosure table Column Name Data Type Description Enslosure_LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Node partly identifies dc_Enclosure SnapshotID BIGINT Snapshot partly identifies dc_Enclosure Tag NVARCH
Column Name Data Type MIFFids CHAR(16) IndexInfo INT HandlerClass VARCHAR(128) HandlerInfo VARCHAR(128) preferredProto VARCHAR(50) historicalFlag SMALLINT keyData SMALLINT keyDataId INT Description DC_PolledDataCategory table Abstract Column Name Data Type ClassId INT ParentClassId INT Name CHAR(80) HistoricalFlag SMALLINT hiddenFlag SMALLINT Description DC_ProliantHost table 56 Column Name Data Type Description ProliantHost_LUID BIGINT LUID uniquely defining this tabl
Column Name Data Type Description WebManagementPort INT This item indicates the port used by the HP Insight Management Agent 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.
devCustAttributeMap table Abstract Column Name Data Type internalAttributeId CHAR(16) pluginAttributeId NVARCHAR(128) Description device_associations table Abstract Column Name Data Type DeviceKey1 INT DeviceKey2 INT AssociationTypeNumber CHAR(80) AssociationState INT Description deviceAssocObjects table Abstract Column Name Data Type nodeID BIGINT assocObjectLUID BIGINT assocType BIGINT Description deviceCustomAttributes table Abstract 58 Column Name Data Type deviceKey INT
Column Name Data Type custField13 NVARCHAR(255) custField14 NVARCHAR(255) custField15 NVARCHAR(255) custField16 NVARCHAR(255) custField17 NVARCHAR(255) custField18 NVARCHAR(255) custField19 NVARCHAR(255) custField20 NVARCHAR(255) Description deviceDimensionInfo table Abstract Column Name Data Type DeviceKey INT Slot INT Height INT Width INT Depth INT MaxNumItems INT NumBladeSlotsUsed INT SwitchesPresent INT MaxNumItemsXDir INT MaxNumItemsYDir INT SlotsUsedXDir INT
Column Name Data Type warrantyText NVARCHAR(255) serviceDate NVARCHAR(255) serviceContract NVARCHAR(255) serviceContact NVARCHAR(255) purchasePrice NVARCHAR(64) purchaseDate NVARCHAR(64) comments NVARCHAR(512) hwPollFailCount INT applications NVARCHAR(255) snoozeTimeMin INT snoozeStartTimeMs BIGINT custSerialNo VARCHAR(32) sysCountryCode VARCHAR(32) entitlementType VARCHAR(16) entitlementID VARCHAR(32) obligationId VARCHAR(32) custProdId NVARCHAR(48) custDeliverId VARCHA
Column Name Data Type productVer VARCHAR(255) licType VARCHAR(80) licDate VARCHAR(80) expirationDate VARCHAR(80) collectDate DATETIME licStatus VARCHAR(255) licSRC VARCHAR(10) Description deviceMxObjValues table Abstract Column Name Data Type deviceKey INT createdBy CHAR(128) createdTime BIGINT modifiedBy CHAR(128) modifiedTime BIGINT Description DeviceNames table The DeviceNames table contains the names for devices as determined by the various protocols that this device suppor
deviceProperties table Abstract 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) PropertyName CHAR(64) propertyValue NVARCHAR(255) DeviceProtocolInfo table The Device Protocol Information fields are defined in the following table.
Column Name Data Type Description system with same device key as the WMIProxyID for making WBEM to requests through the WMI Mapper running on that other system) DeviceSnmpSettings table The DeviceSnmpSettings table contains the SNMP settings currently configured for the systems. The DeviceSnmpSettings fields are defined in the following table.
Column Name Data Type ShowStatus VARCHAR(60) Drilldown VARCHAR(100) DBVTable VARCHAR(32) DBVColumn VARCHAR(32) weight VARCHAR(32) ColPos VARCHAR(32) Description DeviceStatusValue table Column Name Data Type DeviceKey INT StatusSourceId INT StatusValue INT Description DeviceUrls table Column Name Data Type DeviceKey INT UrlName CHAR(128) Url CHAR(255) UrlDescription VARCHAR(255) Description DeviceUrlStrings table Column Name Data Type UrlName CHAR(60) UrlStringType CHA
Column Name Data Type UrlInfo CHAR(200) UrlBuilder CHAR(100) UrlStatusSource CHAR(100) Description Devices table 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 DurableName NVARCHAR(256) If the system was found by an SMI-S agent, this will be equal to the name field of the top-level CIM_ComputerSystem that represents the system.
Column Name Data Type criteria_data_object_name VARCHAR(255) criteria_type INT core_flag INT Description filterInstanceDefinition table Column Name Data Type group_id INT view_id INT criteria_id INT inclusion INT data_model NTEXT Description firstRunConfig table Column Name Data Type URLName VARCHAR(255) Title VARCHAR(255) Configured INT Variables VARCHAR(255) HelpURL VARCHAR(255) Description FolderQueryStatuspolicy table Column Name Data Type type INT className CHAR(
Column Name Data Type StatusStringId CHAR(32) Severity INT OtherText NVARCHAR(255) Description GenericCredentialMap table Column Name Data Type genericCredMapLUID BIGINT objectLUID BIGINT credentialLUID BIGINT objectName NVARCHAR(256) protocol NVARCHAR(64) partnerID NVARCHAR(256) position BIGINT classification INT portForObject INT okToTryOthers INT Description groups table 68 Column Name Data Type GroupId INT Name NCHAR(70) Static SMALLINT Description CHAR(255) C
HP_Cluster table Column Name Data Type Description HPCluster _LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Node partly identifies HP_NParCell SnapshotID BIGINT Snapshot partly identifies HP_NParCell MembershipIncarnation BIGINT An integer value used to uniquely identify the cluster membership (A change in the membership of the cluster results in an increase in the Membership Incarnation.
Column Name Data Type Description CabinetType INT Values are: Unknown(0), Other(1), 8-cell full height cabinet(2), 4-cell full height cabinet(3), 4-cell half-height cabinet(4), 2-cell cabinet(5), I/O expansion cabinet(6).
Column Name Data Type Description number. All processor slots where that value is equal are in the same processor module.) ConnectedToIOChassis BIT True if this cell is connected to an IO chassis ConnectedIOChasssId INT I/O Chassis ID of the chassis to which the cell is connected (The property is not present if ConnectedToIOChassis is false.
Column Name Data Type Description SnapshotID BIGINT Snapshot partly identifies HP_NParComplex ProfileID INT Profile ID of the NPar Complex dc_ComputeCabCount INT Number of compute cabinets in the complex dc_IOXCabCount INT Number of IOX cabinets in the complex ComplexName NVARCHAR(256) Name of the NPar Complex RevisionString NVARCHAR(256) Displayable revision string MaxPartitionsSupported SMALLINT The maximum number of nPartitions that this complex can support (For example, an rp7
Column Name Data Type Description coresWithoutUsageRights INT Cores without Usage Rights, which represents iCAP cores/entry iCAPCompliant Nvarchar(5) iCAPCompliant column value is derived from cellCompliant and cpuCompliant properties.
Column Name Data Type Description dc_CoreCellCabinet INT Core cell Index in the Cabinet of the NPar Partition dc_HasInterleaveMem INT Flag to indicate if the NPar Partition has Interleave Memory configured (1 = yes) R_dc_HasInterleaveMemory NVARCHAR(256) A field used by reporting PartitionNameLabel NVARCHAR(256) Concatenation of the nPartition name and its label, for example, "MyPartition (par2)" PartitionType SMALLINT Type of cells in this nPartition; values are Unknown(0), Other(1), PA-RI
hpmxAutomationTaskResults table Column Name Data Type jobID CHAR(128) noticeID INT subTypeID INT systemName CHAR(255) timeStamp DATETIME exitCode INT status INT resourceID VARCHAR(64) details NVARCHAR(512) Description hpmxAutomationTool table Column Name Data Type LUID BIGINT MessageID TEXT Description hpmxCategory table Column Name Data Type LUID BIGINT CategoryId INT Name NVARCHAR(255) Plugin INT DisplayFlag INT QueryType INT EditFlag INT DisplayOrder INT Disp
Column Name Data Type Privilege INT GroupLUID BIGINT Description hpmxCimomMAO table Column Name Data Type LUID BIGINT InteropNameSpace NVARCHAR(256) Description hpmxCimomMRO table Column Name Data Type LUID BIGINT NameSpace NVARCHAR(256) CimCSPath NVARCHAR(256) Description hpmxClientAttributes table Column Name Data Type ObjectLUID BIGINT Name VARCHAR(128) Value TEXT hpmxIndex INT Description hpmxCommandTool table 76 Column Name Data Type LUID BIGINT CommandLine TEXT
hpmxEnvironmentVariable table Column Name Data Type ObjectLUID BIGINT Name VARCHAR(30) Value TEXT hpmxIndex INT Description hpmxFileCopyPair table Column Name Data Type ToolLUID BIGINT Name VARCHAR(32) SourcePath VARCHAR(128) DestinationPath VARCHAR(128) hpmxIndex INT Description hpmxGroup table Column Name Data Type LUID BIGINT PersistedDescription NVARCHAR(255) SpecificationManner INT AdditionalData VARCHAR(255) Description hpmxItem table Column Name Data Type LUID BI
Column Name Data Type DisplayOrder INT Privilege INT CategoryLUID BIGINT Description hpmxJob table Column Name Data Type Description JobID VARCHAR(267) TaskID VARCHAR(32) ExecuteAsUser VARCHAR(128) TaskRunBy VARCHAR(128) ToolName VARCHAR(255 ToolType VARCHAR(32) StateValue INT RunNow SMALLINT StartTime BIGINT EndTime BIGINT ExceptionText TEXT ExceptionClass TEXT TargetCount INT CommandLine TEXT FileCopySources TEXT FileCopyDestinations TEXT OutputToDB SMALLINT C
hpmxMgmtAgent table Column Name Data Type LUID BIGINT MaoType VARCHAR(64) PortNumber INT IPAddress VARCHAR(60) Protocol VARCHAR(64) NextMAOLUID BIGINT Description hpmxMgmtPath table Column Name Data Type LUID BIGINT NodeLUID BIGINT Version VARCHAR(32) ManagingType INT Description hpmxMgmtRoute table Column Name Data Type LUID BIGINT MaoLUID BIGINT Description hpmxMpoFuncProfile table Column Name Data Type MpoLUID BIGINT FuncProfileName NVARCHAR(64) Description hpmxMpo
hpmxMSACommandTool table Column Name Data Type LUID BIGINT MsaManagerNode VARCHAR(32) Description hpmxNameValueOperator table Column Name Data Type ToolLUID BIGINT Name VARCHAR(32) OperatorValue INT FilterTypeValue INT Value NVARCHAR(80) OrIndex INT AndIndex INT Description hpmxNodeAuthorization table Column Name Data Type LUID BIGINT NodeID VARCHAR(32) Description hpmxNodeGroup table Column Name Data Type LUID BIGINT PersistedName NVARCHAR(80) AssocCollLuid BIGINT Aut
hpmxNodeGroupObjects table Column Name Data Type NodeGroupLUID BIGINT NodeID VARCHAR(32) Description hpmxObject table Column Name Data Type LUID BIGINT GUID VARCHAR(32) CreatedBy VARCHAR(128) CreatedTime BIGINT ModifiedBy VARCHAR(128) ModifiedTime BIGINT ClassType VARCHAR(128) Description hpmxPagerInfo table Column Name Data Type UserLUID BIGINT PhoneNumber VARCHAR(100) PinNumber VARCHAR(100) MsgLength VARCHAR(32) BaudRate VARCHAR(32) DataBit VARCHAR(32) ParityBit VARC
Column Name Data Type Prompt NVARCHAR(80) Required SMALLINT Private SMALLINT Description hpmxQuery table Column Name Data Type LUID BIGINT Name NVARCHAR(80) QueryTypeInt INT EditFlags INT Description hpmxReport table 82 Column Name Data Type LUID BIGINT ReportId INT Name NVARCHAR(255) Plugin INT DisplayFlag INT CreatorId INT EditFlag INT DisplayOrder INT DisplayName NVARCHAR(255) DisplayLocale NVARCHAR(50) QueryType INT QueryId INT QueryName NVARCHAR(50) Ite
hpmxSchemaVersion table Column Name Data Type schemaVersion INT SIMVersion BNVARCHAR(32) Description hpmxSSACommandTool table Column Name Data Type LUID BIGINT Description hpmxSubject table Column Name Data Type LUID BIGINT PersistedDescription NVARCHAR(255) PrivilegeCode INT Description hpmxTargetStatus table Column Name Data Type JobID VARCHAR(267) Hostname NVARCHAR(256) NodeID VARCHAR(32) FileCount INT StateValue SMALLINT ExitCode INT BlockCount INT ExceptionText TEX
hpmxTargetStatusOutput table Column Name Data Type JobID VARCHAR(267) Hostname NVARCHAR(256) Output NTEXT Description hpmxTool table Column Name Data Type LUID BIGINT Name NVARCHAR(255) OwnedByID VARCHAR(32) Description TEXT Comment_ TEXT ExecutedBy VARCHAR(32) DisplayHandler VARCHAR(128) ToolGroup VARCHAR(80) Revision VARCHAR(20) ToolBoxEnabled SMALLINT DefaultTarget VARCHAR(80) ToolType VARCHAR(32) MaxTargets INT Visible SMALLINT JobLogEnabled SMALLINT Schedulable
hpmxToolBox table Column Name Data Type LUID BIGINT PersistedName NVARCHAR(16) PersistedDescription NVARCHAR(255) IsEnabled SMALLINT Description hpmxUser table Column Name Data Type LUID BIGINT PersistedName NVARCHAR(128 FullName NVARCHAR(128) TelephoneNumber VARCHAR(80) EmailAddress NVARCHAR(80) IPLoginInclusionRanges TEXT IPLoginExclusionRanges TEXT Hidden SMALLINT GroupBased SMALLINT Description hpmxUserAssignedUserGroups table Column Name Data Type UserLUID BIGINT Use
hpmxWebLaunchTool table Column Name Data Type LUID BIGINT MainURL VARCHAR(255) SmallURL VARCHAR(255) CurrentURL VARCHAR(255) StatusURL VARCHAR(255) TargetFormat TEXT Description HPSUMResults table Column Name Data Type jobid VARCHAR(100) deviceKey INT logFile IMAGE status INT Description HPUX_BaseKernelParameter table Column Name Data Type Description BaseKernelParameter_LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Node partly identifies HPUX_BaseKernelPa
Column Name Data Type Description 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.
Column Name Data Type Description 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.
HPUX_DNSService table 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.
Column Name Data Type Description 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) 90 CreateTime BIGINT A value set by the implementation to be the time that the catalog information for this object was first written.
Column Name Data Type Description Architecture NVARCHAR(64) A vendor-defined string used to distinguish variations of a product; 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.
HPUX_HFS table 92 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.
Column Name Data Type Description SectorsPerTrack INT The number of sectors per track on the disk TracksPerCylinder INT Specifies the number of tracks per cylinder on the disk DiskCylindersPerCylinderGroup INT Specifies the number of disk cylinders per cylinder group DiskRevolutionsPerSecond INT Specifies the number of disk revolutions per second RotationalDelay INT Specifies the expected time in MS to service a transfer completion interrupt and initiate a new transfer on the same disk dc_
Column Name Data Type Description 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.
Column Name Data Type Description ServerWaitFlag SMALLINT The NIS Server Wait 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.
Column Name Data Type Description AlternatePVName NVARCHAR(256) Can 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.
Column Name Data Type Description 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.
Column Name Data Type Description 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 might mean that the default path does not exist relative to the root directory of the installed software.
Column Name Data Type Description 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 numbe
Column Name Data Type Description ProcessorEntitlement REAL The amount of physical processor resources to which each virtual processor in this guest is entitled in units defined by ProcessorEntitlementUnits ProcessorSpeed REAL The effective speed of the physical processors used by this guest in MegaHertz. The following relationship is always true: ProcessorSpeed * ProcessorEntitlement (in percent) / 100 = ProcessorEntitlement (in MegaHertz).
INIT_TRACKER table Column Name Data Type INIT_ID NUMERIC absoluteFilePath VARCHAR(255) verDir VARCHAR(255) dataType VARCHAR(255) parentDir VARCHAR(255) fileState VARCHAR(255) fileLastModified NUMERIC fileName VARCHAR(3000) statusMsg VARCHAR(3000) fileExt VARCHAR(255) Description IPAddress table The IPAddress table contains the known IP addresses for the devices. The IPAddress fields are defined in the following table.
IPXAddress table The IPXAddress table contains the known IPX addresses for the systems. The IPXAddress fields are defined in the following table.
Column Name Data Type productName NVARCHAR(255) productVersion VARCHAR(255) seatsMax VARCHAR(15) seatsUsed VARCHAR(15) daysMax VARCHAR(15) daysUsed VARCHAR(15) status NVARCHAR(256) collectdate VARCHAR(15) source INT daysLeft VARCHAR(255) pexpire VARCHAR(255) licenseSource NVARCHAR(256) pupgrade NVARCHAR(256) support NVARCHAR(256) report INT signature INT uuid VARCHAR(255) assigned INT isLicensedStatus VARCHAR(32) inEnclosure INT PLPuuid VARCHAR(75) bundleKey VARC
Column Name Data Type seatsAssigned INT daysMax INT dateAsPresentation VARCHAR(30) dateCodeinkey VARCHAR(30) dateCodeinCert VARCHAR(30) transGeography VARCHAR(30) transnumber VARCHAR(30) HIDDEN VARCHAR(30) SUBCLASS VARCHAR(30) NFR VARCHAR(30) LITE VARCHAR(30) MFR VARCHAR(30) paidClass INT daysUsed INT Description LMLicenseTypeList table Column Name Data Type lictypIndex INT licenseType CHAR(60) Description LMProductNameList table Column Name Data Type nameIndex INT
Column Name Data Type PRODUCT_VERSION INT TOOL_NAME VARCHAR(300) ALLOWSELECT INT ENCLOSURE_LICENSING INT Description lockdownStatus table Column Name Data Type deviceKey INT ldStatus INT deviceName CHAR(255) NextScanName CHAR(255) NextScanDate CHAR(255) NextVulChk CHAR(255) LastScanName CHAR(255) LastScanDate CHAR(255) LastVulChk CHAR(255) Critical CHAR(255) Major CHAR(255) Minor CHAR(255) executive CHAR(255) detailed CHAR(255) simple CHAR(255) summary CHAR(255)
menuElements table Column Name Data Type MenuId NCHAR(255) Type INT UserClass INT aclId INT viewId INT userId INT viewPollingRate INT showStatus INT Description menuTree table Column Name Data Type Location INT Parent NCHAR(255) Child NCHAR(255) Description mibEnumXrefs table Column Name Data Type mib_id INT enum_index INT enum_value INT enum_text CHAR(255) severity_map INT Description mibFiles table Column Name Data Type mib_file_id INT mib_file CHAR(64) Descr
mibIndexes table Column Name Data Type mib_id INT index_number INT index_mib_id INT Description mibItems table Column Name Data Type mib_id INT mib_name CHAR(64) syntax_id INT syntax_range_flag INT mib_oid CHAR(64) oid_group INT oid_number INT access_id INT status_id INT enum_count INT instance_count INT mib_file_id INT Description mibOSToVCOS table Column Name Data Type mibOS VARCHAR(30) cimOS VARCHAR(10) packageOS VARCHAR(50) Description NetPort_ProtoEndpoint t
NodeCommDiag_Association table Column Name Data Type associatedPrimary BIGINT secondaryErrors BIGINT Description NodeCommDiagError table Column Name Data Type nodeCommDiagErrorLUID BIGINT nodeLUID BIGINT statusSourceId INT errorKey VARCHAR(64) displayType VARCHAR(20) weigh INT associatedPrimary BIGINT lastUpdatedTime DATETIME Description NodeCommError table Column Name Data Type nodeCommErrorLUID BIGINT nodeLUID BIGINT statusSourceId INT errorKey VARCHAR(64) protocolName
Column Name Data Type sourceLUID BIGINT portForNode INT Description NodeSnapshot table Column Name Data Type Description SnapshotID BIGINT Snapshot partly identifies NodeSnapshot NodeID BIGINT Node partly identifies NodeSnapshot Tag NVARCHAR(256) Contains the user-defined tag Description NVARCHAR(512) Description of the user-defined tag CollectionDateTime BIGINT Stored as MS since the Epoch DetailedInformation NVARCHAR(512) Additional collection status information ReturnCode SMA
Column Name Data Type status INT resourceId CHAR(64) details CHAR(256) Description notices table 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.
noticeType table Column Name Data Type Description GUID VARCHAR(32) Unique system assigned identifier noticeType INT System assigned identifier typeIdStr CHAR(255) A unique String Identification for the event category CHAR(100) dispHandler CHAR(255) Internal handler for the display of the event rxHandler CHAR(255) Internal handler for event reception, usually blank defaultSeverity INT A default severity to use for the event serviceEnable INT Used when the CRSM is installed provider
operationalStatus_PCvalues table Column Name Data Type OperationalStatusId BIGINT OperationalStatusValue SMALLINT OperationalStatusPos INT Description OperationalStatus_SVvalues table Column Name Data Type Description OperationalStatusId BIGINT Used for reporting purposes OperationalStatusValue smallint Used for reporting purposes operationalStatusCD_values table Column Name Data Type OperationalStatusId BIGINT OperationalStatusValue SMALLINT OperationalStatusPos INT Description o
PlugInInfo table Column Name Data Type PlugInInfoID BIGINT Name NVARCHAR(256) PackageName NVARCHAR(1024) ClassIdentifier INT ClassIdString NVARCHAR(255) Description PortController_SoftwareIdent table Column Name Data Type System BIGINT InstalledSoftware BIGINT Description ppaStatus table Column Name Data Type deviceKey INT perfStatus INT Description rackTopology table Column Name Data Type Encl_DeviceKey INT Right_Neighbor_DeviceKey INT Left_Neighbor_DeviceKey INT Descript
Column Name Data Type DisplayOrder INT DisplayName NVARCHAR(255) DisplayLocale NVARCHAR(50) Privilege INT Description ReportItems table Column Name Data Type iId BIGINT iName VARCHAR(255) CatId INT CatName VARCHAR(255) DBViewName NVARCHAR(255) DBViewColName VARCHAR(255) Position INT DispName NVARCHAR(255) DispLocale NVARCHAR(255) Privilege INT Description Reports table Column Name Data Type rId INT rName NVARCHAR(255) ItemList TEXT QName VARCHAR(255) QId INT Vie
Column Name Data Type Collection NVARCHAR(255) ReportLevel INT ChangeCollection INT Custom INT DSUSED NVARCHAR(100) DBNAME NVARCHAR(100) configured INT ReportDescription NVARCHAR(255) ReportType NVARCHAR(100) ReportFormat NVARCHAR(80) Description rptREGISTEREDPRODUCTLIST table Column Name Data Type ProdID INT ProductName NVARCHAR(255) ResourceBundle NVARCHAR(50) Description NVARCHAR(255) ExtraField NVARCHAR(50) Description Provides a textual description of the object SCS
SCSIProtoEnd_iSCSISession table Column Name Data Type Description Antecedent BIGINT Used for reporting purposes Dependent BIGINT Used for reporting purposes Column Name Data Type Description Antecedent BIGINT Used for reporting purposes Dependent BIGINT Used for reporting purposes Column Name Data Type Description NoticeID INT ProviderID INT ServiceID CHAR(40) SequenceNumber CHAR(20) EventStatus INT EventURL CHAR(256) SCSIProtoEnd_NetworkPort table ServiceNotices table Ser
Column Name Data Type collectiontime BIGINT entitlementStatus NVARCHAR(64) startDate NVARCHAR(48) startDateEpoch BIGINT endDate NVARCHAR(48) endDateEpoch BIGINT offers NVARCHAR(1024) responseTime NVARCHAR(1024) coverageWindow NVARCHAR(255) warType NVARCHAR(64) incidentStatus NVARCHAR(64) serviceLevel NVARCHAR(1024) obligationStartDate NVARCHAR(48) obligationEndDate NVARCHAR(48) rawOOSXml NTEXT skipEntitlement INT productID NVARCHAR(20) prodDescription NVARCHAR(255) seri
Column Name Data Type contactEmail NVARCHAR(64) contactOther NVARCHAR(255) contactTimeZone NVARCHAR(24) contactLanguage NVARCHAR(32) contactRole NVARCHAR(32) contactPriority NVARCHAR(32) contactHours NVARCHAR(64) Description SIM_SysCustomer table Column Name Data Type customerLuid BIGINT companyName NVARCHAR(120) address1 NVARCHAR(120) address2 NVARCHAR(120) city NVARCHAR(64) state VARCHAR(50) postalCode NVARCHAR(12) country NVARCHAR(32) custTimeZone NVARCHAR(24) Descrip
stm_rules_dmi table Column Name Data Type priority INT override_flag CHAR(1) modified_by_user_flag CHAR(1) productModel NVARCHAR(128) productType INT productSubType INT management_url VARCHAR(128) management_url_desc NVARCHAR(128) Comp1 VARCHAR(128) Group1 VARCHAR(128) SGroup1 VARCHAR(128) Attrib1 VARCHAR(128) Index1 VARCHAR(16) Val1 VARCHAR(128) Rule1 INT Comp2 VARCHAR(128) Group2 VARCHAR(128) SGroup2 VARCHAR(128) Attrib2 VARCHAR(128) Index2 VARCHAR(16) Val2 VARCH
stm_rules_snmp table Column Name Data Type sysObjectId CHAR(150) priority INT sysOIDRule INT override_flag CHAR(1) modified_by_user_flag CHAR(1) productModel NVARCHAR(128) productType INT productSubType INT management_url VARCHAR(128) management_url_desc NVARCHAR(128) MIB_OID VARCHAR(150) OIDDataType INT OIDValue VARCHAR(150) OIDRule INT OSName VARCHAR(32) OSVendor VARCHAR(64) OSRevision VARCHAR(32) post_proc_class_name VARCHAR(255) Description stringResource table Col
SVAllocatedFromStoragePool table Column Name Data Type Description SVAllocFromStoragePool_LUID BIGINT LUID uniquely defining the SVAllocFromStoragePool NodeID BIGINT Used for reporting purposes SnapshotID BIGINT Used for reporting purposes Antecedent BIGINT Used for reporting purposes Dependent BIGINT Used for reporting purposes SpaceConsumed BIGINT Used for reporting purposes Column Name Data Type Description noticeId INT deviceKey INT statusType INT statusValue INT logUrl
tableIndexes table Column Name Data Type indexKey CHAR(120) indexValue INT Description tableVersions table Column Name Data Type TableName CHAR(255) TableVersion CHAR(50) ContentsVersion VARCHAR(50) Description taskQueryContents table Column Name Data Type NoticeId INT DeviceKey INT TaskId INT OldFlag INT Description Tasks table 122 Column Name Data Type TaskKey INT ToolKey INT Configuration NTEXT Name NCHAR(70) createdByUser NVARCHAR(128) modifiedByUser NVARCHAR(12
Column Name Data Type Description groupLUID BIGINT Critical INT Describes the criticality of the job/task. Used during HP SIM quiesce operation.
Column Name Data Type Sun INT IsDeletable SMALLINT Description trapAccessTypes table Column Name Data Type Name INT Mon CHAR(50) Description trapCategoryTypes table Column Name Data Type cat_id INT category_type CHAR(64) Description trapData table Column Name Data Type rec_id INT trap_id INT notice_id INT varbind_rec_count INT origTrapInfo TEXT Description trapItems table 124 Column Name Data Type trap_id INT trap_name CHAR(64) trap_enterprise CHAR(64) trap_generi
trapItemsEx table Column Name Data Type trap_id INT mib_file_id INT enabled_flag CHAR(1) Description trapSeverityTypes table Column Name Data Type severity_id INT severity_type CHAR(64) Description trapStatusTypes table Column Name Data Type status_id INT status_type CHAR(64) Description trapSyntaxRanges table Column Name Data Type mib_id INT hi_value INT lo_value INT Description trapSyntaxTypes table Column Name Data Type syntax_id INT syntax_type CHAR(64) Description
trapVarbindData table Column Name Data Type Description trap_rec_id INT varbind_number INT varbind_oid CHAR(256) value_in_hex INT value VACHAR(MAX) Indicates Enterprise OID Column Name Data Type Description trap_rec_id INT varbind_number INT varbind_oid INT trapVarbinds table user_rack table Column Name Data Type trap_rec_id INT varbind_number CHAR(80) varbind_oid CHAR(400) Description user_rack_association table Column Name Data Type DeviceKey1 INT DeviceKey2 INT Devi
viewCategories table Column Name Data Type Category NCHAR(255) isPublic SMALLINT creatorUserId INT Description viewCategoriesTree table Column Name Data Type Location INT ParentId NCHAR(255) ChildId NCHAR(255) IsView SMALLINT Description views table Column Name Data Type ViewId INT ViewName NCHAR(70) GroupId INT creatorUserId INT aclId INT isPublic SMALLINT Description vmmStatus table Column Name Data Type deviceKey INT vmmStatus INT Description WbemClusterAlgorithm
WbemHPVirtualMachineAlgorithms table Column Name Data Type WBEMAlgorithmClassName CHAR(128) Sequence INT Description WMIProxy table 128 Column Name Data Type LUID BIGINT Name VARCHAR(255) WmiProxyIP VARCHAR(60) Port INT Modify_ INT HP SIM database tables Description
A Support and other resources Information to collect before contacting HP Be sure to have the following information available before you contact HP: • Software product name • Hardware product model number • Operating system type and version • Applicable error message • Third-party hardware or software • Technical support registration number (if applicable) How to contact HP Use the following methods to contact HP technical support: • In the United States, see the Customer Service/Contact HP Uni
• If the question is related to HP Insight Remote Support (HP Insight RS), then HP SIM will be supported as it pertains in Insight RS with a Hardware Warranty or Hardware Contract • The customer purchases an HP SIM Care Pack (Part #: UR389E) Support includes one year of 24 x 7 HP Software Technical Support and Update Service. This service provides access to HP technical resources for assistance in resolving software implementation or operations problems.
HP SIM documentation For more information regarding HP SIM, see the HP HP SIM Information library at http:// www.hp.com/go/insightmanagement/sim/docs for access to HP SIM manuals and release notes. Typographic conventions find(1) Book Title Linked Title http:// www.hp.com Command user input computer output Enter term variable value attrib HP-UX manpage. In this example, “find” is the manpage name and “1” is the manpage section. Title of a book or other document.