Page History
...
PW normalization table for transactions.
| Column Name | Column Description |
|---|---|
SPTN_ID | The ID of the transaction. |
SPTN_HASH_VALUE | The PW internal hash value. |
SPTN_STRING_VALUE | The name of the transaction. |
SPTN_TIMESTAMP | The time the transaction was created. |
PW_SPPN_PGM_N
PW normalization table for programs.
| Column Name | Column Description |
|---|---|
SPPN_ID | The ID of the program. |
SPPN_HASH_VALUE | The PW internal hash value. |
SPPN_STRING_VALUE | The name of the program. |
SPPN_TIMESTAMP | The time the program was created. |
PW_SPRN_APPSVR_N
PW normalization table for application servers.
| Column Name | Column Description |
|---|---|
SPRN_ID | The ID of the application server. |
SPRN_HASH_VALUE | The PW internal hash value. |
SPRN_STRING_VALUE | The name of the application server. |
SPRN_TIMESTAMP | The time the application server was created. |
PW_SPHN_HOST_N
PW normalization table for server hosts.
| Column Name | Column Description |
|---|---|
SPHN_ID | The ID of the host. |
SPHN_HASH_VALUE | The PW internal hash value. |
SPHN_STRING_VALUE | The name of the host. |
SPHN_TIMESTAMP | The time the host was created. |
PW_SPFN_FUNC_N
PW normalization table for functions.
| Column Name | Column Description |
|---|---|
SPFN_ID | The ID of the function. |
SPFN_HASH_VALUE | The PW internal hash value. |
SPFN_STRING_VALUE | The name of the function. |
SPFN_TIMESTAMP | The time the function was created. |
PW_SPON_ORG_N
PW normalization table for organizations.
| Column Name | Column Description |
|---|---|
SPON_ID | The ID of the organization. |
SPON_HASH_VALUE | The PW internal hash value. |
SPON_STRING_VALUE | The name of the organization. |
SPON_TIMESTAMP | The time the organization was created. |
PW_SPIN_IP_N
PW normalization table for IP addresses.
| Column Name | Column Description |
|---|---|
SPIN_ID | The ID of the IP address. |
SPIN_HASH_VALUE | The PW internal hash value. |
SPIN_STRING_VALUE | The name of the IP address. |
SPIN_TIMESTAMP | The time the IP address was created. |
PW_SPAN_APP_N
PW normalization table for applications.
| Column Name | Column Description |
|---|---|
SPAN_ID | The ID of the application. |
SPAN_HASH_VALUE | The PW internal hash value. |
SPAN_STRING_VALUE | The name of the application. |
SPAN_TIMESTAMP | The time the application was created. |
PW_SPWD_WORKTYPES_DIM
Dimension table for work types.
| Column Name | Column Description |
|---|---|
SPWD_WORKTYPE_KEY | The work type key. |
SPWD_WORKTYPE_NAME | The work type name. |
SPWD_WORKTYPE_INTERNAL | The internal SAP work type name. |
PW_SPPP_PRODUCT_PARAMS
Internal parameter table.
| Column Name | Column Description |
|---|---|
SPPP_PARAM_NAME | The name of the parameter. |
SPPP_PARAM_VALUE | The value of the parameter. |
PW_SPTN_TRAN_N_VIEW
View on PW_SPTN_TRAN_N.
| Column Name | Column Description |
|---|---|
SPTN_ID_VIEW | The ID of the transaction. |
SPTN_HASH_VALUE_VIEW | The PW internal hash value. |
SPTN_STRING_VALUE_VIEW | The name of the transaction. |
SPTN_TIMESTAMP_VIEW | The time the transaction was created. |
PW_SPCF_AI_CONFIG
Configuration table for all of the collectors.
| Column Name | Column Description |
|---|---|
SPCF_CONFIG_KEY | Configuration key. |
SPCF_LOCCFG_LAST_UPD | Local agent last update time. |
SPCF_AVAILCFG_LAST_UPD | Availability agent last update time. |
SPCF_WRKLDCFG_LAST_UPD | Workload agent last update time. |
SPCF_LOCCFG_LAST_PUSH | Locale agent last push time. |
SPCF_AVAILCFG_LAST_PUSH | Availability agent last push time. |
SPCF_WRKLDCFG_LAST_PUSH | Workload agent last push time. |
SPCF_DEF_USER_AREA | User area mapping definition. |
SPCF_DEF_USER_ORG | User organization mapping definition. |
SPCF_DEF_LOC | Locale mapping definition. |
SPCF_DEF_APP | Application mapping definition. |
PW_SPPG_AI_PINGERS
Locale pingers list.
| Column Name | Column Description |
|---|---|
SPPG_PINGER_KEY | Pinger key. |
SPPG_LOC_KEY | Locale key. |
SPPG_PINGER_NAME | Pinger name or IP address. |
AI_CONFIG_VIEW
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. |