HP Systems Insight Manager 7.
Acknowledgments The information in this document is subject to change without notice. Hewlett-Packard makes no warranty of any kind with regard to this manual, including, but not limited to, the implied warranties of merchantability and fitness for a particular purpose. Hewlett-Packard shall not be held liable for errors contained herein or direct, indirect, special, incidental, or consequential damages in connection with the furnishing, performance, or use of this material.
Contents About this document......................................................................................9 Publishing History.....................................................................................................................9 1 HP SIM database tables............................................................................10 Predefined views....................................................................................................................10 Database tables.....
CIM_RemoteServiceAccessPoint table...................................................................................39 CIM_SCSIProtocolController table........................................................................................40 CIM_SCSIProtocolEndpoint table..........................................................................................40 CIM_Rack table.................................................................................................................
deviceAttributes table.........................................................................................................60 deviceLicenseInfo table.......................................................................................................60 deviceMxObjValues table...................................................................................................60 DeviceNames table............................................................................................................
hpmxNodeAuthorization table.............................................................................................80 hpmxNodeGroup table......................................................................................................80 hpmxNodeGroupAuthorization table....................................................................................80 hpmxNodeGroupObjects table............................................................................................80 hpmxObject table.........
mibIndexes table.............................................................................................................106 mibItems table.................................................................................................................106 mibOSToVCOS table........................................................................................................107 NetPort_ProtoEndpoint table..............................................................................................
tableIndexes table............................................................................................................121 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-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.
Column Name Data Type Description Tag NVARCHAR(256) Used for reporting purposes CreationClassName NVARCHAR(256) Used for reporting purposes Manufacturer NVARCHAR(64) Used for reporting purposes Model NVARCHAR(256) Used for reporting purposes PartNumber NVARCHAR(256) Used for reporting purposes Column Name Data Type Description PortController_LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Node partly identifies CIM_PortController SnapshotID BIGINT Snapshot partly
Column Name Data Type Description 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.
Column Name Data Type Description dc_PowerSupplyPresent NVARCHAR(32) Not standard; indicates whether the power supply is present in the chassis dc_PowerSupplyStatus NVARCHAR(64) The status of the power supply (noError (1), generalFailure (2), bistFailure 32), fanFailure (4), tempFailure (5), interlockOpen (6), epromFailed (7), vrefFailed (8), dacFailed (9), ramTestFailed (10), voltageChannelFailed (11), orringdiodeFailed (12), brownOut (13), giveupOnStartup (14), nvramInvalid (15), calibrationTableI
Column Name Data Type Description • I/O Expansion Cabinet I/O Chassis Enclosure Power Supply • I/O Expansion Cabinet AC Input Line • Cooling Device Slot • Power Device Slot Note: This property may not be available when the cell is powered off.
Column Name Data Type Description UnixProcess_ModulePath NVARCHAR(512) Derived from CIM_UnixProcess.ModulePath; the file path to the executing module for the process OtherExecutionDescription NVARCHAR(512) Derived from CIM_UnixProcess.
Column Name Data Type Description 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.
Column Name Data Type Description 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.
CIM_ProtocolControllerForPort table Column Name Data Type Description Dependent BIGINT Used for reporting purposes NodeID BIGINT Node partly identifies CIM_ProtocolControllerForUnit SnapshotID BIGINT Snapshot partly identifies CIM_ProtocolControllerForUnit DeviceNumber NVARCHAR(255) Used for reporting purposes Antecedent BIGINT Used for reporting purposes Dependent BIGINT Used for reporting purposes Name NVARCHAR(255) A label by which the object is known CIM_ProtocolControllerForUnit
Column Name Data Type Description SnapshotID BIGINT Snapshot partly identifies CIM_RemoteServiceAccessPoint ElementName NVARCHAR(255) Used for reporting purposes SystemCreationClassName NVARCHAR(256) Used for reporting purposes SystemName NVARCHAR(256) The value of CIM_ComputerSystem.
CIM_Rack table 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.
Column Name Data Type Description PossibleStates NVARCHAR(512) Possible States enumerates the string outputs of the Sensor (For example, a switch sensor can output the states On or Off. Another implementation of the Switch can 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.
Column Name Data Type Description Version NVARCHAR(64) Version partly identifies CIM_SoftwareElement; Software Version should be in the form .. or . 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.
Column Name Data Type Description be constructed using the following 'preferred' algorithm: ": " Where <0rgID> and are separated by a colon ':' and where must include a copyrighted, trademarked, or otherwise unique name that is owned by the business entity creating/defining the InstanceID or is a registered ID that is assigned to the business entity by a recognized global authority. (This is similar to the _ structure of Schema class names.
Column Name Data Type Description SupportedTargetTypes parameter in SoftwareInstallationServiceCapabilities.) TargetOperatingSystem SMALLINT 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 must be specified using the class, CIM_OSVersionCheck.
Column Name Data Type Description ElementName NVARCHAR(255) Used for reporting purposes InstanceID NVARCHAR(255) Used for reporting purposes PoolID NVARCHAR(255) Used for reporting purposes Primordial BIT Used for reporting purposes TotalManagedSpace BIGINT Used for reporting purposes RemainingManagedSpace BIGINT Used for reporting purposes CIM_StorageSetting table Column Name Data Type Description storageSetting_LUID BIGINT Used to uniquely identify CIM_StorageVolume NodeID BIGI
Column Name Data Type Description IsBasedOnUnderlyingRedundanc BIT Used for reporting purposes SequentialAccess BIT Used for reporting purposes R_OperationalStatus NARCHAR(256) Used for reporting purposes R_ExtentStatus NARCHAR(256) Used for reporting purposes R_RaidLevel NARCHAR(256) Used for reporting purposes Column Name Data Type Description TCPProtocolEndpoint_LUID BIGINT Used for reporting purposes NodeID BIGINT Used for reporting purposes SnapshotID BIGINT Used for report
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 BIGINT Description clusterNodeInfo table Column Name Data Type ClusterDeviceKey INT NodeDeviceKey INT ContactPerson NCHAR(256) ContactPhone CHAR(128) ContactPager CHAR(128) ContactEmail CHA
Column Name Data Type 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) Param5 VARCHAR(256) Description cmxType table Column Name Data Type CMX_Type INT CMX_Name CHAR(128) Alias CHAR(128) Description CHAR(255) DeviceType INT ClusterType INT StatusProp INT PropertyURL C
Column Name Data Type 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 SMALLINT EditFlags INT Type INT SystemCollLuid BIGINT EventCollLuid BIGINT ComputerSys_ChangerDevice table Column Name Data Type GroupComponent BIGINT PartComponent BIGINT Description ComputerSys_HAP table Column Name Data Type Descri
ComputerSys_NetworkPort table Column Name Data Type Description GroupComponent BIGINT Used for reporting purposes PartComponent BIGINT Used for reporting purposes ComputerSys_PortController table Column Name Data Type Description GroupComponent BIGINT Used for reporting purposes PartComponent BIGINT Used for reporting purposes Column Name Data Type Description AvailableSAP BIGINT Used for reporting purposes ManagedElement BIGINT Used for reporting purposes ComputerSys_SAP table C
consolidatedNodeAuths table 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 VARCHAR(128) ComponentName VARCHAR(128) status INT stdOut IMAGE stdErr TEXT CRA_TaskResults table Credential table Column Name Data Type LUID BIGINT credType INT encrUserName NVARCHAR(256) encrPassword NVARCHAR(256) certificateName NVARCHAR(512) Description DB_Dev
Column Name Data Type Description Location CHAR (200) Physical location (must be filled in at the system) Contact CHAR (200) The contact for this system (must be filled in at the system) NOTE: 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.
DC_CategoryChildren table Abstract Column Name Data Type ClassId INT PollId INT Description DC_DeviceDCState table Abstract Column Name Data Type DeviceKey INT LastDCTimeStarted DATETIME LastDCTimeCompleted DATETIME LastHDCTimeStarted DATETIME DCFlags INT collectionState INT Description 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 AttributeSt
Column Name Data Type Description dc_Address INT The unique address of the enclosure within the rack dc_EnclosureMaxNumBladesX INT The maximum number of server blades the enclosure can contain dc_EnclosureMaxNumBladesY INT The maximum number of server blades the enclosure can contain dc_FusePresent NVARCHAR(32) Specifies if the fuse described is present in the system: Other (1), Absent (2) and Present (3) dc_FuseCondition NVARCHAR(32) The condition of the fuse ( Other (1), Fuse status detec
DC_ProliantHost table 56 Column Name Data Type Description ProliantHost_LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Identifies the system 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.
Dedicated_values table Column Name Data Type Description DedicatedId BIGINT Used to uniquely identify this row DedicatedValue SMALLINT Used for reporting purposes DedicatedPos INT Used for reporting purposes NOTE: 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 devContainerAndRole table Abstract Column Name Data Type DeviceKey INT EnclosureName CHAR(255) RackName C
deviceAssocObjects table Abstract Column Name Data Type nodeID BIGINT assocObjectLUID BIGINT assocType BIGINT Description deviceCustomAttributes table Abstract Column Name Data Type deviceKey INT custField1 NVARCHAR(255) custField2 NVARCHAR(255) custField3 NVARCHAR(255) custField4 NVARCHAR(255) custField5 NVARCHAR(255) custField6 NVARCHAR(255) custField7 NVARCHAR(255) custField8 NVARCHAR(255) custField9 NVARCHAR(255) custField10 NVARCHAR(255) custField11 NVARCHAR(255) cust
Column Name Data Type Height INT Width INT Depth INT MaxNumItems INT NumBladeSlotsUsed INT SwitchesPresent INT MaxNumItemsXDir INT MaxNumItemsYDir INT SlotsUsedXDir INT SlotsUsedYDir INT Source CHAR(80) Description deviceExtendedAttributes 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) assetType NVARCHAR(255) a
Column Name Data Type entitlementID VARCHAR(32) obligationId VARCHAR(32) custProdId NVARCHAR(48) custDeliverId VARCHAR(64) Description deviceAttributes table The Device Extended Attributes fields are defined in the following table.
Column Name Data Type 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 supports. The DeviceNames fields are defined in the following table.
Column Name Data Type Description not identified yet; a value of 0 indicates SNMP was not found on the system; a value of 1 to 5 indicates that SNMP was found on the system SNMPverStr NCHAR(32) A string indicating what version of SNMP was detected (Currently HP Systems Insight Manager only supports “1.
Column Name Data Type Description 8 = use the default SNMP retries, 16 = use the default icmp timeout, 32 = use the default ICMP retries, 64 = use the default WBEM user name, 128 = use the default WBEM password) NOTE: 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.
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 CHAR(70) UrlStringKey CHAR(255) Description DeviceUrlTypes table Column Name Data Type UrlName CHAR(128) UrlType INT UserClass INT UrlInfo CHAR(200) UrlBuilder CHAR(100) UrlStatusSource CHAR(100) Description Devices table The Devices table contains discovered system informati
Column Name Data Type Description Discovered BIGINT The date and time that the system was discovered represented as the number of milliseconds since 1970 UTC ProductType INT The product type for this item (See the nodeTypesEnum table, which is best viewed using the deviceSubTypesEnum view, for additional information.) ProductTypeStr CHAR(32) A string representation of the product type (See the nodeTypesEnum table, which is best viewed using the deviceTypesEnum view, for additional information.
DirSrvGroupCritGroup table Column Name Data Type DeviceKey INT DirectoryGroup CHAR(255) Description DirSrvGroupCritOU table Column Name Data Type DeviceKey INT OrganizationalUnit CHAR(255) Description ExtentStatus_values table Column Name Data Type Description ExtentStatusId BIGINT Used for reporting purposes ExtentStatusValue SMALLINT Used for reporting purposes ExtentStatusPos INT Used for reporting purposes Column Name Data Type Description criteria_id INT criteria_name VA
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(128) Description GC_TaskResults table Column Name Data Type DeviceKey INT JobID VARCHAR(128) HmmoId CHAR(32) TimeStamp DATETIME StatusStringId CHAR(32) Severity INT OtherText NVARCHAR(255) Description GenericCredentialMap table Column Name Data
Column Name Data Type portForObject INT okToTryOthers INT Description groups table Column Name Data Type GroupId INT Name NCHAR(70) Static SMALLINT Description CHAR(255) Created 101 LastModified 101 GroupEstablished SMALLINT aclId INT creatorUserId INT filterId INT Description HP_Cluster table 68 Column Name Data Type Description HPCluster _LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Node partly identifies HP_NParCell SnapshotID BIGINT Snapshot
HP_Node table Column Name Data Type Description HPNode _LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Node partly identifies HP_Node SnapshotID BIGINT Snapshot partly identifies HP_Node Name NVARCHAR(256) A label by which the object is known Membername NVARCHAR(256) Describes the name for this member in the generic HP cluster (The inherited Name value must be fully qualified and unique within the enterprise, while the MemberName value can be an abbreviated version unique w
Column Name Data Type Description SnapshotID BIGINT Snapshot partly identifies HP_NParCell SlotID INT The ID of the slot the NPar Cell resides in TotalMemoryInstalled BIGINT Total memory (MB) installed in the cell MaxCPUCount INT Maximum CPU count MaxCPUCount INT The maximum number of processors supported on this cell, accounting for both the number of processor module slots and the maximum number of processors per module supported by this platform (The value might not reflect the maxim
Column Name Data Type Description is Unknown if a failure occurred while getting the data for this component.) CPUCountOK SMALLINT The number of installed processors that are configured for use. Processors may be deconfigured by the OS or by system firmware. Note: This property may not be available when the cell is powered off. TotalMemoryOK BIGINT Amount of functional memory installed on the cell, in megabytes. Note: This property may not be available when the cell is powered off.
Column Name Data Type Description OEMProductName NVARCHAR(256) The name of the product as assigned by the OEM manufacturer (This property is supported only on Itanium®-based platforms but might not be present on all of those.) OriginalProductOrderNumber NVARCHAR(256) The product order number for this complex as originally delivered, for example, AxxxxxA (If the complex has been upgraded, this is the product order number before the upgrade.
HP_NParIOChassisSlot table Column Name Data Type Description NParIOChassisSlot_LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Node partly identifies HP_NParChassisIOSlot SnapshotID BIGINT Snapshot partly identifies HP_NParChassisIOSlot ID INT ID of the NPar I/O Chassis Slot CabinetID INT ID of the cabinet in which the I/O Chassis belongs IOBayNumber INT Bay number in the cabinet where the I/O Chassis resides Number INT The I/O Chassis number that is unique across the
Column Name Data Type Description which the provider is running on Itanium®-based platforms, user-settable HAAlternateBootPath NVARCHAR(256) The HA alternate boot path for this nPartition; present and settable when BootPathsAreAvailable is true, user-settable R_CoreCellCabinet NVARCHAR(256) Cabinet number associated with the core cell dc_ActiveCells INT Number of active cells in this partition R_CoreCellCabinet NVARCHAR(255) Used for reporting to display the core cell cabinet Column Name Dat
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 DisplayName NVARCHAR(255) DisplayLocale NVARCHAR(50) DbViewName NVARCHAR(50) SourceType INT Source TEXT SourceHandler CHAR(256) CreatorId INT Privilege INT GroupLUID BIGINT Description hpmxCimomMAO table Column Name Data Ty
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 Column Name Data Type LUID BIGINT CommandLine TEXT ExecutedShell VARCHAR(32) SaveOutputToLog SMALLINT CommandType VARCHAR(32) EnvVarsArray TEXT Description hpmxEnvironmentVariable table 76 Column Name Data Type Objec
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 BIGINT ItemId INT Name NVARCHAR(255) DisplayFlag INT DisplayName NVARCHAR(255) DisplayLocale NVARCHAR(50) DbViewName NVARCHAR
hpmxJob table Column Name Data Type 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 Description hpmxMDBeanTool table Column Name Data Type LUID BIGINT MDBeanName VARCHAR(1000) QueueName
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 hpmxMpoProfile table Column Name Data Type MpoLUID BIGINT ProfileName NVARCHAR(64) Description hpmxMSACommandTool table Column Name Data Type LUID BIGINT MsaManagerNode VARC
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 AutoUpdate SMALLINT Description hpmxNodeGroupAuthorization table Column Name Data Type LUID BIGINT No
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 VARCHAR(32) StopBit VARCHAR(32) Description hpmxParameter table Column Name Data Type ToolLUID BIGINT Na
hpmxQuery table Column Name Data Type LUID BIGINT Name NVARCHAR(80) QueryTypeInt INT EditFlags INT Description hpmxReport table 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) ItemList TEXT ViewOption INT ViewFormat INT Privilege INT GroupLUID BIGINT Description hpmxSche
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 TEXT ExceptionClass TEXT StatusResourceStringName VARCHAR(255) Description hpmxTargetStatusOutput table C
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 SMALLINT AcceptsTargets SMALLINT timeout INT Description hpmxToolAssignedToolBoxes table Column Name Data Type ToolLUI
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 UserGroupID VARCHAR(32) Description hpmxUserGroup table Column Name Data Type LUID BIGINT PersistedName NVARCHAR(128) FullName NVARCHAR(128) IPLogin
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_BaseKernelParameter SnapshotID BIGINT Snapshot partly identifies HPUX_BaseKernelParameter BaseKernelParameterID INT BaseKernelParameterID partly identifies HPUX_BaseKernelParameter.
Column Name Data Type Description 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.
Column Name Data Type Description 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.
HPUX_Fileset table 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.
Column Name Data Type Description 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(2
Column Name Data Type Description by POSIX.1 (2)Use t section 4.4.1 (It is used for determining compatibility.
Column Name Data Type Description FileSystemType NVARCHAR(256) Inherited from CIM_FileSystem.FileSystemType; string describing the type of FileSystem and its conventions (For example, \"NTFS\" or \"S5\" can 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.
Column Name Data Type SnapshotID BIGINT Name NVARCHAR(255) Description NVARCHAR(255) CIMdateTime NVARCHAR(255) CurrentState NVARCHAR(255) CurrentCause NVARCHAR(255) NextBootState NVARCHAR(255) NextBootCause NVARCHAR(255) Capabilities NVARCHAR(255) Dynamic NVARCHAR(255) Required NVARCHAR(255) Modifiable NVARCHAR(255) Dependencies NVARCHAR(510) Description HPUX_LogicalVolume table Column Name Data Type Description LogicalVolume_LUID BIGINT LUID uniquely defining this table ro
Column Name Data Type Description BadBlockRelocation BIT Switch of Bad Block Relocation feature; true if it is on, false otherwise AllocationPolicy NVARCHAR(64) Allocation Policy of the logical volume; might 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; valid only the logical volume is mirrored NumberReadAccess
Column Name Data Type Description 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.
HPUX_Product table 96 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(256) 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.
Column Name Data Type Description another software object has a dependency on this product. In checking a product prerequisite or corequisite, 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 prerequisites or corequisites.
Column Name Data Type Description 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; 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.
Column Name Data Type Description 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 Column Name Data Type Description HPVM_Guest_LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Partly identifies HPVM_Guest SnapshotID BIGINT Partly identifies HPVM_Guest Name NVARCHAR(256) D
HPVM_Host table Column Name Data Type Description HPVM_Host_LUID BIGINT LUID uniquely defining this table row NodeID BIGINT Partly identifies HPVM_Host SnapshotID BIGINT Partly identifies HPVM_Host Name NVARCHAR(256) Displays the name of the host HPVMVersion NVARCHAR(255) Displays the HPVM version UUID NVARCHAR(255) The UUID for this system.
IPAddress table 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 Associates a system, 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 and so on *IPAddress CHAR (16) TCP/IP address (x.x.x.
iSCSIConn_TCPProtoEnd table Column Name Data Type Antecedent BIGINT Dependent BIGINT Description LicenseReportingAlgorithms table Column Name Data Type AlgorithmName CHAR(255) Description LMCertificateList table Column Name Data Type deviceKey INT deviceType VARCHAR(255) deviceIP VARCHAR(255) deviceSN VARCHAR(255) nodeName NVARCHAR(256) licenseKey VARCHAR(36) licenseKeyVer VARCHAR(36) licenseType NVARCHAR(256) licenseTypeCode VARCHAR(30) certificateDate VARCHAR(30) certific
Column Name Data Type pupgrade NVARCHAR(256) support NVARCHAR(256) report INT signature INT uuid VARCHAR(255) assigned INT isLicensedStatus VARCHAR(32) inEnclosure INT PLPuuid VARCHAR(75) bundleKey VARCHAR(36) bundlePCode VARCHAR(30) bundleVCode VARCHAR(30) Description lmLICENSESTATUS table Column Name Data Type licenseKey VARCHAR(36) licenseKeyVer VARCHAR(36) licenseType NVARCHAR(256) licenseTypeCode VARCHAR(30) productVcode VARCHAR(30) productCode VARCHAR(30) produ
Column Name Data Type 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 productName CHAR(255) keyDispose INT transcode INT productVcode VARCHAR(5) bindName INT bindSN INT bindUUID INT bindRelationship INT Description LMTOOLLAUNCH table Column Name Data Type ID VARCHAR(10) PRODUCT_ID INT PRODUCT_VERSION INT TOOL_NAME VARCHA
Column Name Data Type 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) ports CHAR(255) LPatchDate CHAR(255) LPatchApplied CHAR(255) PatchRqd CHAR(255) PatchMiss CHAR(255) Warning CHAR(255) Description MediaAccessDev_SoftwareIdent table Column Name Data Type dependent BIGINT antecedent BIGINT 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) Description mibFilesEx table Column Name Data Type mib_file_id INT Module CHAR(60) flags BINARY(8) Description mibIndexes table Column Name Data Type mib_id INT index_numb
Column Name Data Type 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 table Column Name Data Type dependent BIGINT antecedent BIGINT Description networkAddresses_values table Column Name Data Type Description NetworkAddressesIdD BIGINT Uniquely identif
Column Name Data Type 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 VARCHAR(64) port INT lastUpdatedTime DATETIME Description NodeCredentialMap table Column Name Data Type nodeCredMapLUID BIGINT nodeLUID BIGINT credentialLUID BIGINT nodeUUID NVARCHAR(64) nodeName
Column Name Data Type Description DetailedInformation NVARCHAR(512) Additional collection status information ReturnCode SMALLINT Binary status information.
Column Name Data Type Description 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 BIGIN
Column Name Data Type Description privilege INT The internal privilege level a user must have to view the event details subCategory VARCHAR(100) correlatedEvent VARCHAR(255) noticeXMLData table Column Name Data Type noticeId INT XMLData NVARCHAR(-1) Description operationalStatus_CSvalues table Column Name Data Type OperationalStatusId BIGINT OperationalStatusValue SMALLINT OperationalStatusPos INT Description operationalStatus_NPvalues table Column Name Data Type OperationalStatu
operationalStatusCD_values table Column Name Data Type OperationalStatusId BIGINT OperationalStatusValue SMALLINT OperationalStatusPos INT Description operationalStatusMAD_values table Column Name Data Type OperationalStatusId BIGINT OperationalStatusValue SMALLINT OperationalStatusPos INT Description otherIdentifyingInfo_SVvalues table Column Name Data Type OtherIdentifyingInfoId BIGINT OtherIdentifyingInfoValue NVARCHAR(256) OtherIdentifyingInfoPos INT Description PhysicalPackag
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 Description registeredMessages table Column Name Data Type MessageName CHAR(255) MessageId INT Description reportGroup table Column Name Data Type LUID BIGINT Name NVARCHAR(255) DisplayFlag INT EditFlag INT CreatorId INT Plugin INT DisplayOrder INT DisplayName NVARCHAR(255)
Column Name Data Type 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 ViewOption INT CreatorID INT RunCount INT EditFlag INT Privilege INT Description rptPRODUCTREPORTLIST table 114 Column Name Data Type ProdID INT ReportName NVARCHAR(255) CustomReportName NVARCHAR(255) Collection NVARCHAR(255) ReportLevel INT ChangeCo
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 SCSIProtoCont_SCSIProtoEnd table Column Name Data Type Description AvailableSAP BIGINT Used for reporting purposes MangedElement BIGINT Used for reporting purposes SCSIProtocolCont_SoftwareId table Column Name Data Type Description System BIGINT Used for repo
ServiceNotices table Column Name Data Type NoticeID INT ProviderID INT ServiceID CHAR(40) SequenceNumber CHAR(20) EventStatus INT EventURL CHAR(256) Description ServiceProvider table Column Name Data Type ProviderID INT ProviderName CHAR(256) ProviderURL CHAR(256) DefaultEventURL CHAR(256) Description SIM_NodeCertificate table Column Name Data Type nodeCertificate_LUID BIGINT nodeID BIGINT portID INT certificateAlias NVARCHAR(64) Description SIM_NodeEntitlement table 11
Column Name Data Type incidentStatus NVARCHAR(64) serviceLevel NVARCHAR(1024) obligationStartDate NVARCHAR(48) obligationEndDate NVARCHAR(48) rawOOSXml NTEXT skipEntitlement INT productID NVARCHAR(20) prodDescription NVARCHAR(255) serialNumber NVARCHAR(40) obligationDetail NVARCHAR(20) entitlementSummary NVARCHAR(255) custContractRef NVARCHAR(20) svcAgreementID NVARCHAR(20) contractID NVARCHAR(20) ampID NVARCHAR(20) carePackID NVARCHAR(20) sar NVARCHAR(50) Description SI
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) Description Snapshot table 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 NVARCH
Column Name Data Type 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 VARCHAR(128) Rule2 INT Comp3 VARCHAR(128) Group3 VARCHAR(128) SGroup3 VARCHAR(128) Attrib3 VARCHAR(128) Index3 VARCHAR(16) Val3 VARCHAR(128) Rule3 I
Column Name Data Type 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 Column Name Data Type id INT subClass CHAR(255) resourceName CHAR(128) resourceClassName CHAR(64) Description stringTableLarge table Column Name Data Type id INT language CHAR(2) largeVal
swComponentEvents table Column Name Data Type noticeId INT deviceKey INT statusType INT statusValue INT logUrl VARCHAR(1024) xmlContent IMAGE updateTime DAT3ETIME jobId VARCHAR(128) Description SWFWBaselines table Column Name Data Type Name VARCHAR(255) DescName VARCHAR(255) Targets VARCHAR(255) Version VARCHAR(50) Status INT Type INT Description swVersionWeights table Column Name Data Type keyFileName NVARCHAR(256) divisionKey VARCHAR(25) osKey VARCHAR(256) version
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 Column Name Data Type TaskKey INT ToolKey INT Configuration NTEXT Name NCHAR(70) createdByUser NVARCHAR(128) modifiedByUser NVARCHAR(128) ownedByUser NVARCHAR(128) createTime BIGINT lastEditTime BIGINT queryId INT GUID VARCHA
Column Name Data Type IntervalPeriod INT ExecutionDay INT ExecutionTime BIGINT BaseExecutionTime BIGINT ScheduleType INT TimeFilterName NCHAR(255) TimeFilterEnabled SMALLINT TimeFilterChecked SMALLINT RunOnStartup SMALLINT HasRunFlag SMALLINT MaxRunCount INT RunUntilTime BIGINT DisabledFlag SMALLINT Description TCPProtoEnd_IPProtoEnd table Column Name Data Type Description Antecedent BIGINT Used for reporting purposes Dependent bIGINT Used for reporting purposes Column
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 Column Name Data Type trap_id INT trap_name CHAR(64) trap_enterprise CHAR(64) trap_generic_id INT trap_specific_id INT trap_severity_id INT trap_varbind_count INT cat_id INT sev_vb INT Description trapItemsEx table Column Name Data Type
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 trap_rec_id INT varbind_number INT varbind_oid CHAR(256) value_in_hex INT value VARCHAR(255) Description trapVarbinds table Column Name Data Type trap_rec
user_rack_association table Column Name Data Type DeviceKey1 INT DeviceKey2 INT DeviceKey2Position INT StartU INT EndU INT AssociationTypeNumber CHAR(80) Description VersionControlFeatures table Column Name Data Type NodeID BIGINT SWFWBaseline NVARCHAR(200) ConfiguredRepository NVARCHAR(200) R_BaselineName NVARCHAR(200) Description viewCategories table Column Name Data Type Category NCHAR(255) isPublic SMALLINT creatorUserId INT Description viewCategoriesTree table Column
vmmStatus table Column Name Data Type deviceKey INT vmmStatus INT Description WbemClusterAlgorithms table Column Name Data Type WBEMAlgorithmClassName CHAR(128) Sequence INT Description WbemComplexAlgorithms table Column Name Data Type WBEMAlgorithmClassName CHAR(128) Sequence INT Description WbemHPVirtualMachineAlgorithms table Column Name Data Type WBEMAlgorithmClassName CHAR(128) Sequence INT Description WMIProxy table Column Name Data Type LUID BIGINT Name VARCHAR(255)
