PTHCDOMDET_VW(SQL View) |
Index Back |
|---|
| SELECT A.DBNAME , 0 , B.PM_DOMAIN_TYPE , B.PM_HOST_PORT , B.PM_DOMAIN_NAME FROM PSPMAGENT B , PSPMSYSDEFN A WHERE B.PM_DOMAIN_MONITOR = 'Y' and A.PM_SYSTEMID = B.PM_SYSTEMID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | DBNAME | Character(8) | VARCHAR2(8) NOT NULL | Database Name |
| 2 | PTHC_SELECT | Number(1,0) | SMALLINT NOT NULL | Select |
| 3 | 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 |
| 4 | PM_HOST_PORT | Character(254) | VARCHAR2(254) NOT NULL | Performance Monitor host name. |
| 5 | PM_DOMAIN_NAME | Character(32) | VARCHAR2(32) NOT NULL | Performance Monitor Agent Name. |