PW_PWII_INSTANCE_ID

Defines the instances in the Precise installation.

Column NameColumn Description
PWII_ID ID of the instance. 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 JE for J2EE).
PWII_SERVERName of the server on which the instance is installed.

PW_SQDG_DATABASE_GRP

The SQL Server database group table.

Column NameColumn Description
SQDG_SQDN_IDThe ID of the database.
SQDG_INGD_IDThe ID of the database group running the SQL Server statement.

PW_SQSG_SERVER_GRP

The SQL Server server group table.

Column NameColumn Description
SQSG_INCE_IDThe ID of the server.
SQSG_INGD_IDThe ID of the server group running the SQL Server statement.

PW_SQIG_INSTANCE_GRP

The SQL Server instance group table.

Column NameColumn Description
SQIG_INCE_IDThe ID of the instance.
SQIG_INGD_IDThe ID of the instance group running the SQL Server statement.

PW_SQLG_LOGIN_GRP

The SQL Server Login name group table.

Column NameColumn Description
SQLG_SQLN_IDThe login ID.
SQLG_INGD_IDThe ID of the login group running the SQL Server statement.

PW_SQPG_PROGRAM_GRP

The SQL Server program group table.

Column NameColumn Description
SQPG_SQPN_IDThe ID of the program.
SQPG_INGD_IDThe ID of the program group running the SQL Server statement.

PW_SQMG_MACHINE_NAME_GRP

The SQL Server client group table.

Column NameColumn Description
SQMG_SQMN_IDThe ID of the client.
SQMG_INGD_IDThe ID of the client group running the SQL Server statement.
 |    |  |   |   |