PM_SYSTEMIDPrompt Table: PSPMSYSDEF_VW
PM_AGENTIDPSPMAGENT4_VW(SQL View) |
Index Back |
|---|---|
View into Agent DefinitionsView Agent Information for performance monitor. |
| SELECT PM_SYSTEMID , PM_AGENTID , PM_DOMAIN_NAME , PM_AGENT_TYPE , PM_HOST_PORT , PM_AGENT_INACTIVE FROM PSPMAGENT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | PM_SYSTEMID |
Number(5,0) | INTEGER NOT NULL |
Performance Monitor System Identifier.
Prompt Table: PSPMSYSDEF_VW |
| 2 | PM_AGENTID |
Number(10,0) | DECIMAL(10) NOT NULL | Performance Monitor Agent Identifier. |
| 3 | PM_DOMAIN_NAME | Character(32) | VARCHAR2(32) NOT NULL | Performance Monitor Agent Name. |
| 4 | PM_AGENT_TYPE | Character(32) | VARCHAR2(32) NOT NULL | Performance Monitor Agent Name. |
| 5 | PM_HOST_PORT | Character(254) | VARCHAR2(254) NOT NULL | Performance Monitor host name. |
| 6 | PM_AGENT_INACTIVE | Character(1) | VARCHAR2(1) NOT NULL | Inactive Agent |