Page History
...
PW_SPLD_LOCALE_DIM
Locale dimension.
Column Name | Column Description |
---|---|
SPLD_LOCALE_KEY | The locale key. |
SPLD_LOCALE_NAME | The locale name. |
SPLD_SAPROUTER | SAP router string. |
SPLD_DESCRIPTION | The locale description. |
SPLD_USEICMP | Whether you use ICMP to connect to the locale. |
SPLD_CHANGED_DT | The date when this record was last changed. |
SPLD_START_DT | The start date of the record. |
SPLD_END_DT | The end date of the record. |
SPLD_IS_DELETED | Whether this record is deleted. |
PW_SPID_INSTANCE_DIM
Instance dimension view.
Column Name | Column Description |
---|---|
SPID_ENVIRONMENT_KEY | The instance environment key. |
SPID_APPTIER_KEY | The instance AppTier key. |
SPID_PWII_INSTANCE_ID | The instance ID. |
SPID_INSTANCE_NAME | The instance name. |
SPID_CREATE_TIME | The time the record was created. |
SPID_UPDATE_TIME | The time the record was updated. |
SPID_IS_DELETED | Whether this record is deleted. |
PW_SPUL_USERLOCALE_DIM
User locale dimension.
Column Name | Column Description |
---|---|
SPUL_PWII_INSTANCE_ID | The instance ID. |
SPUL_USERLOCALE_KEY | The user locale key. |
SPUL_CLIENT | The client. |
SPUL_USER_AREA | The user area. |
SPUL_LOCALE_KEY | The locale key. |
SPUL_CHANGED_DT | The date when this record was last changed. |
SPUL_START_DT | The start date of the record. |
SPUL_END_DT | The end date of the record. |
SPUL_IS_DELETED | Whether this record is deleted. |
PW_SPUD_USER_DIM
User dimension.
Column Name | Column Description |
---|---|
SPUD_PWII_INSTANCE_ID | The instance ID. |
SPUD_USER_NAME | The user name. |
SPUD_CLIENT | The client number. |
SPUD_USER_TYPE | The user type. |
SPUD_DEPT | The user's department. |
SPUD_BLDG | The user's building. |
SPUD_COST | The user's cost center. |
SPUD_LOC | The user's location. |
SPUD_REGION | The user's region. |
SPUD_ACCT | The user's account. |
SPUD_CLS | The user's group. |
SPUD_NAME0 | The user's name 0. |
SPUD_NAME1 | The user's name 1. |
SPUD_NAME2 | The user's name 2. |
SPUD_NAME3 | The user's name 3. |
SPUD_CHANGED_DT | The date when this record was last changed. |
SPUD_IS_DELETED | Whether this record is deleted. |
PW_SPSQ_SEQ
Sequel table.
Column Name | Column Description |
---|---|
SPSQ_TABLE_COLUMN | The table column. |
SPSQ_NEXT_FREE_SEQ | Next free sequel. |
PW_SPID_AI_SIDS
SIDs table.
Column Name | Column Description |
---|---|
SPID_SID_KEY | The SID key. |
SPID_SYSTEM_NAME | The system name. |
SPID_SID_NAME | The ID name. |
SPID_SID_SYSNO | The SID system number. |
SPID_SAP_IMPHOST | The SAP implement host. |
SPID_SAP_RELEASE | The SAP release. |
SPID_SID_USER | The user used to connect to the SID. |
SPID_SID_PASSTHROUGH_SERVER | Deprecated. Not in use. |
SPID_DB_STANDALONE | Whether this SID is a standalone DB server. |
SPID_RFC_DEST | Routing string for RFC connection. |
SPID_CENTRAL_INSTANCE | Application server key of the central instance. |
SPID_DB_HOST_NAME | Host name of the DB server. |
SPID_SID_LAST_IMPORT_DATE | Deprecated. Not in use. |
SPID_USE_SAPROUTER | Boolean indication whether to use routing string connection. |
SPID_SID_PASS | The password for the user. |
SPID_SID_DEFCLIENT | The SID default client. |
SPID_USER_LOC_FIELD | The user locale field. |
SPID_USER_ORG_FIELD | The user organization field. |
PW_SPDI_DISABLED_INSTANCES
Disabled instances table.
Column Name | Column Description |
---|---|
SPDI_INSTANCE_ID | The instance ID. |
PW_SPID_AI_SIDS_VIEW
SIDs view.
Column Name | Column Description |
---|---|
SPID_SID_KEY | The SID key. |
SPID_SYSTEM_NAME | The system name. |
SPID_SID_NAME | The ID name. |
SPID_SID_SYSNO | The SID system number. |
SPID_SAP_IMPHOST | The SAP implement host. |
SPID_SAP_RELEASE | The SAP release. |
SPID_SID_USER | The user used to connect to the SID. |
SPID_SID_PASS | The password for the user. |
SPID_SID_DEFCLIENT | The SID default client. |
SPID_SID_DEFAPPSVR | The SID default application server. |
SPID_USER_LOC_FIELD | The user locale field. |
SPID_USER_ORG_FIELD | The user organization field. |
SPID_SID_PASSTHROUGH_SERVER | The SID passthrough server. |
SPID_DB_STANDALONE | Whether this SID is a standalone DB server. |
SPID_RFC_DEST | Routing string for RFC connection. |
SPID_CENTRAL_INSTANCE | Application server key of the central instance. |
SPID_DB_HOST_NAME | Host name of the DB server. |
SPID_SID_LAST_IMPORT_DATE | Deprecated. Not in use. |
SPID_USE_SAPROUTER | Boolean indication whether to use routing string connection. |
SPID_SERVER | The server. |
SPID_INTERPOINT_NAME | The Interpoint name. |
PW_SPAS_AI_APPSVRS
Application servers view.
Column Name | Column Description |
---|---|
SPAS_APPSVR_KEY | The application server key. |
SPAS_SID_KEY | The SID key. |
SPAS_APPSVR_SID | The application server SID. |
SPAS_APPSVR_NAME | The application server name. |
SPAS_APPSVR_SYSNO | The application server sys number. |
SPAS_APPSVR_SAPROUTER | The application server SAP router. |
SPAS_INSM_ID | The instance server. |
PW_SPLC_AI_LOCALES
Locales view.
Column Name | Column Description |
---|---|
SPLC_LOC_KEY | The locale key. |
SPLC_LOC_NAME | The locale name. |
SPLC_LOC_SAPROUTER | The locale SAP router. |
SPLC_LOC_DESCRIPTION | The locale description. |
SPLC_USEICMP | Use ICMP. |
PW_SPCL_AI_CLIENTS
Clients view.
Column Name | Column Description |
---|---|
SPCL_CLIENT_KEY | The client key. |
SPCL_CLIENT_NAME | The client name, |
SPCL_CLIENT_COMMENT | The client comment. |
SPCL_CLIENT_LANG | The client's language. |
SPCL_CLIENT_DOCOLLECTION | The client do collection. |
SPCL_SID | The SID. |
SPCL_SID_KEY | The SID key. |
PW_SPSL_AI_SYSLOC
System locale view.
Column Name | Column Description |
---|---|
SPSL_SYS_KEY | The system key. |
SPSL_LOC_KEY | The locale key. |
SPSL_CHANGED_DT | The changed date. |
SPSL_IS_DELETED | Whether this record is deleted. |
AI_AVAILAGENT_APPSERVER_VIEW
Avail agent application server view.
Column Name | Column Description |
---|---|
SID_KEY | The SID key. |
APPSVR_KEY | The application server key. |
APPSVR_NAME | The application server name. |
APPSVR_SYSNO | The application server system number. |
APPSVR_SAPROUTER | The application server SAP router. |
SID_NAME | The SID name. |
SID_DEFCLIENT | The SID default client. |
SID_USER | The SID user. |
SID_PASS | The SID password. |
SID_RELEASE | The SAP release. |
CLIENT_LANG | The client’s language. |
PW_SPUN_USER_N
PW normalization table for users.
Column Name | Column Description |
---|---|
SPUN_ID | User ID. |
SPUN_HASH_VALUE | PW internal hash value. |
SPUN_STRING_VALUE | User name. |
SPUN_TIMESTAMP | Creation time. |
PW_SPTN_TRAN_N
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. |