beautypg.com

Computersys_portcontroller table, Computersys_sap table, Computersys_scsiprotocont table – HP Systems Insight Manager User Manual

Page 615: Computersys_scsiprotoendp table, Computersys_softwareident table, Computersys_storagevol table, Db_deviceinfo table, Computersys_storagevol table db_deviceinfo table

background image

Description

Data Type

Column Name

Used for reporting purposes

BIGINT

PartComponent

ComputerSys_PortController table

Description

Data Type

Column Name

Used for reporting purposes

BIGINT

GroupComponent

Used for reporting purposes

BIGINT

PartComponent

ComputerSys_SAP table

Description

Data Type

Column Name

Used for reporting purposes

BIGINT

AvailableSAP

Used for reporting purposes

BIGINT

ManagedElement

ComputerSys_SCSIProtoCont table

Description

Data Type

Column Name

Used for reporting purposes

BIGINT

GroupComponent

Used for reporting purposes

BIGINT

PartComponent

ComputerSys_SCSIProtoEndp table

Description

Data Type

Column Name

Used for reporting purposes

BIGINT

Dependent

Used for reporting purposes

BIGINT

Antecedent

ComputerSys_SoftwareIdent table

Description

Data Type

Column Name

Used for reporting purposes

BIGINT

System

Used for reporting purposes

BIGINT

InstalledSoftware

ComputerSys_StorageVol table

Description

Data Type

Column Name

Used for reporting purposes

BIGINT

GroupComponent

Used for reporting purposes

BIGINT

PartComponent

DB_DeviceInfo table

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

Description

Data Type

Column Name

INT

*DeviceKey

Date and time the database record was last updated

DATETIME

UpdateTime

System description.

CHAR (200)

Description

Physical location (must be filled in at the system)

CHAR (200)

Location

Database tables 615