PSPMSESSIONS_VW

(SQL View)
 Index Back

Active user sessions

Performance monitor view to show currently active sessions.

SELECT T3.PM_CONTEXT_VALUE1 , T3.PM_AGENTID , T3.PM_AGENT_STRT_DTTM FROM PSPMTRANSHIST T3 WHERE T3.PM_TRANS_DEFN_ID = 116 AND PM_TRANS_STATUS = '1' AND PM_TRANS_DURATION <> 0 AND T3.PM_CONTEXT_VALUE1 IN ( SELECT T.PM_CONTEXT_VALUE1 FROM PSPMTRANSHIST T WHERE T.PM_TRANS_DEFN_SET = 1 AND T.PM_TRANS_DEFN_ID = 109 AND T.PM_MON_STRT_DTTM > %TimeAdd(%CurrentDateTimeIn, -720) AND T.PM_PARENT_INST_ID <> PM_TOP_INST_ID AND T.PM_CONTEXT_VALUE1 NOT IN ( SELECT T2.PM_CONTEXT_VALUE1 FROM PSPMTRANSHIST T2 WHERE T2.PM_TRANS_DEFN_SET = 1 AND T2.PM_TRANS_DEFN_ID = 108 AND T2.PM_CONTEXT_VALUE1 = T.PM_CONTEXT_VALUE1 AND T2.PM_MON_STRT_DTTM > %TimeAdd(%CurrentDateTimeIn, -720)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 PM_CONTEXT_VALUE1 Character(254) VARCHAR2(254) NOT NULL Context 1
2 PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
3 PM_AGENT_STRT_DTTM DateTime(26) TIMESTAMP Agent Start Date/Time