Precise Application Performance Platform 10.3.x

Page History

Versions Compared

Key

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

...

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.

Scroll Ignore

scroll-pdf	true
scroll-office	true
scroll-chm	true
scroll-docbook	true
scroll-eclipsehelp	true
scroll-epub	true
scroll-html	true

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/precise/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools