Insight SAP group tables

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.

The SAP server group table.

Column Name	Column Description
`SPSG_INSM_ID`	The ID of the server.
`SPSG_INGD_ID`	The ID of the server group running the SAP transaction.

The SAP application server group table.

Column Name	Column Description
`SPPG_SPSD_ID`	The ID of the application server.
`SPPG_INGD_ID`	The ID of the application server group running the SAP transactions.

The SAP transaction group table.

Column Name	Column Description
`SPAG_SPTD_ID`	The ID of the transaction.
`SPAG_INGD_ID`	The ID of the SAP transaction group.