PSPMSESSIONS_VW

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 Field Type Column Type Description
PM_CONTEXT_VALUE1 Character(254) VARCHAR2(254) NOT NULL Context 1
PM_AGENTID Number(10,0) DECIMAL(10) NOT NULL Performance Monitor Agent Identifier.
PM_AGENT_STRT_DTTM DateTime(26) TIMESTAMP Agent Start Date/Time
index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
PTRef generated on 09-JUN-19