PM_AGENTID01=Application Server
02=Web Server
03=Database
04=Process Scheduler
05=Integration Broker
06=Performance Monitor
99=Unknown
N=No
Y=Yes
Y/N Table Edit
Default: N
Prompt Table: PSPMSYSDEFN
PSPMAGENT_VW |
index back |
|---|---|
Agent Definitions View |
| SELECT PM_AGENTID , PM_AGENT_TYPE , PM_DOMAIN_NAME , PM_DOMAIN_TYPE , PM_DOMAIN_DIR , PM_DOMAIN_MONITOR , PM_HOST_PORT , PM_INSTANCE , PM_SYSTEMID FROM PSPMAGENT WHERE PM_DOMAIN_MONITOR = 'Y' AND PM_DOMAIN_TYPE = '01' AND PM_AGENT_INACTIVE <> 'Y' |
| PeopleSoft Field Name | Field Type | Column Type | Description |
|---|---|---|---|
| PM_AGENTID |
Number(10,0) | DECIMAL(10) NOT NULL | Performance Monitor Agent Identifier. |
| PM_AGENT_TYPE | Character(32) | VARCHAR2(32) NOT NULL | Performance Monitor Agent Name. |
| PM_DOMAIN_NAME | Character(32) | VARCHAR2(32) NOT NULL | Performance Monitor Agent Name. |
| PM_DOMAIN_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
Performance Monitor Domain Type.
01=Application Server 02=Web Server 03=Database 04=Process Scheduler 05=Integration Broker 06=Performance Monitor 99=Unknown |
| PM_DOMAIN_DIR | Character(254) | VARCHAR2(254) NOT NULL | Performance Monitor Domain Directory. |
| PM_DOMAIN_MONITOR | Character(1) | VARCHAR2(1) NOT NULL |
Performance Monitor, monitor indicator flag. If set to 'Y', the agent is a special domain monitor agent.
N=No Y=Yes Y/N Table Edit Default: N |
| PM_HOST_PORT | Character(64) | VARCHAR2(64) NOT NULL | Performance Monitor host name. |
| PM_INSTANCE | Character(32) | VARCHAR2(32) NOT NULL | Server Instance |
| PM_SYSTEMID | Number(5,0) | INTEGER NOT NULL |
Performance Monitor System Identifier.
Prompt Table: PSPMSYSDEFN |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |