PSPMEVENT20_VW (SQL View)	Index Back
Current Event View View into the performance monitor current event table.

PSPMEVENT20_VW

(SQL View)

Current Event View

View into the performance monitor current event table.

SELECT A.PM_AGENTID FROM PSPMEVENTARCH A WHERE A.PM_EVENT_DEFN_SET = 1 AND A.PM_EVENT_DEFN_ID = 901 AND A.PM_PROCESS_ID <> 0 GROUP BY A.PM_AGENTID HAVING COUNT(*) >= 2

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description

1 PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.