Page History

PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column name Column description
PWII_ID The instance ID. Columns of XXXX_PWII_INSTANCE_ID have values from the column.
PWII_INSTANCE_NAME Name of the instance.
PWII_TECHNOLOGY Two characters defining the technology of the instance (such as OR for Oracle and JE for J2EE).
PWII_SERVER Name of the server on which the instance is installed.

PS_INGD_GROUPS_DEFS

A translation of all Insight grouped entities, excluding Locations.

Column name Column description
INGD_ID The group ID.
INGD_NAME The group name according to the joined entity (for example (Users (Grouped)).

PS_INLD_LOCATION_DEFS

A translation of all Insight client IPS groups to Locations.

Column name Column description
INLD_ID The group ID.
INLD_NAME The locations.

PS_ISPD_PROC_AVAIL_DEFS

This table contains Alerts Process Availability (PA) Definitions.

PS_ISPR_PROC_AVAIL_RULES

This table contains process names that comprise the Process Availability Definition.

Column name Column description
ISPR_ISPD_ID PA definition ID.
ISPR_USER_NAME OS user name.
ISPR_RULE Process name or text pattern.

PS_ISPC_PROC_AVAIL_CONN

This table contains the association of Process Availability Definitions to Precise instances.

Column name Column description
ISPC_ISPD_ID PA definition ID.
ISPC_INTE_CODE Technology code of the PA definition.
ISPC_TECH_DEFAULT Boolean - Does this definition apply to all instances of the technology? (yes or no)
ISPC_INCE_ID Instance ID associated with the PA definition (if this definition is not the technology default).