PW_PWII_INSTANCE_ID
Defines the instances in the Precise installation.
| Column Name | Column Description |
|---|---|
PWII_ID | ID of the instance. 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. |
PW_SQDG_DATABASE_GRP
The SQL Server database group table.
| Column Name | Column Description |
|---|---|
SQDG_SQDN_ID | The ID of the database. |
SQDG_INGD_ID | The ID of the database group running the SQL Server statement. |
PW_SQSG_SERVER_GRP
The SQL Server server group table.
| Column Name | Column Description |
|---|---|
SQSG_INCE_ID | The ID of the server. |
SQSG_INGD_ID | The ID of the server group running the SQL Server statement. |
PW_SQIG_INSTANCE_GRP
The SQL Server instance group table.
| Column Name | Column Description |
|---|---|
SQIG_INCE_ID | The ID of the instance. |
SQIG_INGD_ID | The ID of the instance group running the SQL Server statement. |
PW_SQLG_LOGIN_GRP
The SQL Server Login name group table.
| Column Name | Column Description |
|---|---|
SQLG_SQLN_ID | The login ID. |
SQLG_INGD_ID | The ID of the login group running the SQL Server statement. |
PW_SQPG_PROGRAM_GRP
The SQL Server program group table.
| Column Name | Column Description |
|---|---|
SQPG_SQPN_ID | The ID of the program. |
SQPG_INGD_ID | The ID of the program group running the SQL Server statement. |
PW_SQMG_MACHINE_NAME_GRP
The SQL Server client group table.
| Column Name | Column Description |
|---|---|
SQMG_SQMN_ID | The ID of the client. |
SQMG_INGD_ID | The ID of the client group running the SQL Server statement. |