Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

PW normalization table for organizations.

Column NameColumn Description
SPON_IDThe ID of the organization.
SPON_HASH_VALUEThe PW internal hash value.
SPON_STRING_VALUEThe name of the organization.
SPON_TIMESTAMPThe time the organization was created.

PW_SPIN_IP_N

PW normalization table for IP addresses.

Column NameColumn Description
SPIN_IDThe ID of the IP address.
SPIN_HASH_VALUEThe PW internal hash value.
SPIN_STRING_VALUEThe name of the IP address.
SPIN_TIMESTAMPThe time the IP address was created.

PW_SPAN_APP_N

PW normalization table for applications.

Column NameColumn Description
SPAN_IDThe ID of the application.
SPAN_HASH_VALUEThe PW internal hash value.
SPAN_STRING_VALUEThe name of the application.
SPAN_TIMESTAMPThe time the application was created.

PW_SPWD_WORKTYPES_DIM

Dimension table for work types.

Column NameColumn Description
SPWD_WORKTYPE_KEYThe work type key.
SPWD_WORKTYPE_NAMEThe work type name.
SPWD_WORKTYPE_INTERNALThe internal SAP work type name.

PW_SPPP_PRODUCT_PARAMS

Internal parameter table.

Column NameColumn Description
SPPP_PARAM_NAMEThe name of the parameter.
SPPP_PARAM_VALUEThe value of the parameter.

PW_SPTN_TRAN_N_VIEW

View on PW_SPTN_TRAN_N.

Column NameColumn Description
SPTN_ID_VIEWThe ID of the transaction.
SPTN_HASH_VALUE_VIEWThe PW internal hash value.
SPTN_STRING_VALUE_VIEWThe name of the transaction.
SPTN_TIMESTAMP_VIEWThe time the transaction was created.

PW_SPCF_AI_CONFIG

Configuration table for all of the collectors.

Column NameColumn Description
SPCF_CONFIG_KEYConfiguration key.
SPCF_LOCCFG_LAST_UPDLocal agent last update time.
SPCF_AVAILCFG_LAST_UPDAvailability agent last update time.
SPCF_WRKLDCFG_LAST_UPDWorkload agent last update time.
SPCF_LOCCFG_LAST_PUSHLocale agent last push time.
SPCF_AVAILCFG_LAST_PUSHAvailability agent last push time.
SPCF_WRKLDCFG_LAST_PUSHWorkload agent last push time.
SPCF_DEF_USER_AREAUser area mapping definition.
SPCF_DEF_USER_ORGUser organization mapping definition.
SPCF_DEF_LOCLocale mapping definition.
SPCF_DEF_APPApplication mapping definition.

PW_SPPG_AI_PINGERS

Locale pingers list.

Column NameColumn Description
SPPG_PINGER_KEYPinger key.
SPPG_LOC_KEYLocale key.
SPPG_PINGER_NAMEPinger name or IP address.

AI_CONFIG_VIEW

View on PW_SPCF_AI_CONFIG.

Column NameColumn Description
CONFIG_KEYConfiguration key.
LOCCFG_LAST_UPDLocal agent last update time.
AVAILCFG_LAST_UPDAvailability agent last update time.
WRKLDCFG_LAST_UPDWorkload agent last update time.
LOCCFG_LAST_PUSHLocale agent last push time.
AVAILCFG_LAST_PUSHAvailability agent last push time.
WRKLDCFG_LAST_PUSHWorkload agent last push time.
DEF_USER_AREAUser area mapping definition.
DEF_USER_ORGUser organization mapping definition.
DEF_LOCLocale mapping definition.
DEF_APPApplication mapping definition.

AI_LOCAGENTLOC_VIEW_1

View on PW_SPLC_AI_LOCALES.

Column NameColumn Description
LOC_KEYLocale key.
LOC_NAMELocale name.
USEICMPWhether the locale is using ICMP.

AI_LOCAGENT_PINGER_VIEW

View that joins PW_SPPG_AI_PINGERS and AI_LOCAGENTLOC_VIEW_1.

Column NameColumn Description
LOC_KEYLocale key.
LOC_NAMELocale name.
USEICMPWhether the locale is using ICMP.
DEVICENAMEPinger name.

AI_WRKLDAGENT_APPSERVER_VIEW

Column NameColumn 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.



Scroll Ignore
scroll-pdftrue
scroll-officetrue
scroll-chmtrue
scroll-docbooktrue
scroll-eclipsehelptrue
scroll-epubtrue
scroll-htmltrue
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/precise/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse