PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column NameColumn Description
PWII_IDThe instance ID. Columns of XXXX_PWII_INSTANCE_ID have values from the column.
PWII_INSTANCE_NAMEName of the instance.
PWII_TECHNOLOGYTwo characters defining the technology of the instance (such as OR for Oracle and JEJE for J2EE).
PWII_SERVERName of the server on which the instance is installed.

PS_INGD_GROUPS_DEFS

A translation of all Insight grouped entities, excluding locations.

Column NameColumn Description
INGD_IDThe group ID.
INGD_NAMEThe group name according to the joined entity, such as (Users (Grouped)).

PS_INLD_LOCATION_DEFS

A translation of all Insight client IPS groups to Locations.

Column NameColumn Description
INLD_IDThe group ID.
INLD_NAMEThe locations.

PS_ISPD_PROC_AVAIL_DEFS

This table contains Alerts Process Availability (PA) Definitions.

Column NameColumn Description
ISPD_IDPA definition ID.
ISPD_NAMEPA definition name.
ISPD_INTE_CODETechnology code of the PA definition.

PS_ISPR_PROC_AVAIL_RULES

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

Column NameColumn Description
ISPR_ISPD_IDPA definition ID.
ISPR_USER_NAMEOS user name.
ISPR_RULEProcess name or text pattern.

PS_ISPC_PROC_AVAIL_CONN

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

Column NameColumn Description
ISPC_ISPD_IDPA definition ID.
ISPC_INTE_CODETechnology code of the PA definition.
ISPC_TECH_DEFAULTBoolean. Does this definition apply to all instances of the technology? (YES or NO)
ISPC_INCE_IDInstance ID associated with the PA definition, if this definition is not the technology default.
IDERA |  Products | Purchase | Support |  Community |  Resources |  About Us  | Legal