Page History
...
View on PW_SPCF_AI_CONFIG.
| Column Name | Column Description |
|---|---|
CONFIG_KEY | Configuration key. |
LOCCFG_LAST_UPD | Local agent last update time. |
AVAILCFG_LAST_UPD | Availability agent last update time. |
WRKLDCFG_LAST_UPD | Workload agent last update time. |
LOCCFG_LAST_PUSH | Locale agent last push time. |
AVAILCFG_LAST_PUSH | Availability agent last push time. |
WRKLDCFG_LAST_PUSH | Workload agent last push time. |
DEF_USER_AREA | User area mapping definition. |
DEF_USER_ORG | User organization mapping definition. |
DEF_LOC | Locale mapping definition. |
DEF_APP | Application mapping definition. |
AI_LOCAGENTLOC_VIEW_1
View on PW_SPLC_AI_LOCALES.
| Column Name | Column Description |
|---|---|
LOC_KEY | Locale key. |
LOC_NAME | Locale name. |
USEICMP | Whether the locale is using ICMP. |
AI_LOCAGENT_PINGER_VIEW
View that joins PW_SPPG_AI_PINGERS and AI_LOCAGENTLOC_VIEW_1.
| Column Name | Column Description |
|---|---|
LOC_KEY | Locale key. |
LOC_NAME | Locale name. |
USEICMP | Whether the locale is using ICMP. |
DEVICENAME | Pinger name. |
AI_WRKLDAGENT_APPSERVER_VIEW
| Column Name | Column Description |
|---|---|
SID_KEY | SID key. |
APPSVR_KEY | Application server key. |
APPSVR_NAME | Application server name. |
APPSVR_SYSNO | Application server system number. |
APPSVR_SAPROUTER | Application server SAP router. |
INSM_ID | INSM_ID in server table. |
SID_DEFAPPSVR | Default application server key of SID. |
SID_DEFAPPSVR_NAME | Default application server name of SID. |
SID_DEFCLIENT | SID default client. |
SID_USER | SID user. |
SID_PASS | SID password encrypted. |
SID_PASSTHRU_APPSVR | Deprecated. Not in use. |
SID_STANDALONE | Whether the database is on a stand one server. |
SID_HOST | Database host name. |
RFC_DEST | RFC destination. |
CLIENT_LANG | Client language. |
SYS_SID | SID name. |
PW_SPII_INTERPOINT_INSTALLED
View to get data on SAP Interpoint installations.
| Column Name | Column Description |
|---|---|
SPII_ORACLE_INSTANCE_NAME | Instance name of the database product. |
SPII_INTERPOINT_INSTALLED | Number representing the database type. |
SPII_INAP_ID | Apptier ID. |
SPII_INCE_ID | Instance key of the database product. |
PW_SPAR_SLA_RULES
View for the SLA of Precise for SAP.
| Column Name | Column Description |
|---|---|
SPAR_ID | Rule ID. |
SPAR_INAD_ID | Rule in alert. |
SPAR_RULE_TYPE | Rule type. |
SPAR_RULE | Rule definition. |
SPAR_RFC_IND | RFC indication. |
SPAR_CREATE_TIME | Rule creation time. |
SPAR_UPDATE_TIME | Rule update time. |
SPAR_DELETED | Whether the rule is deleted. |
PW_SPOL_ORGLOCALE_STAT_D
Statistics table for locale organizations mapping. Also has M summary level.
| Column Name | Column Description |
|---|---|
SPOL_PWII_INSTANCE_ID | Instance ID. |
SPOL_TIMESTAMP | Timestamp the mapping was created. |
SPOL_PWHG_ID | PW hour group. |
SPOL_RECEIVED_TIMESTAMP | Time received. |
SPOL_MINUTES_COUNT_SUM | Minutes count. |
SPOL_LOCALE_KEY | Locale key. |
SPOL_ORG_KEY | Organization key. |