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