Currently Active Sessions By Server report

Displays the total number of sessions currently running by PowerCenter Server. This cached report is attached to the 5 Minute Refresh schedule, which refreshes every 5 minutes.

Click on the text to copy the query report to your clipboard.


select "REPOSITORY_NAME",
"TASK_ID",
"SERVER_NAME",
"END_TIME"
from (SELECT  SESSION_TASK_INST_RUN.SERVER_NAME,  SESSION_TASK_REPOSIT_INFO.REPOSITORY_NAME,  TO_DATE(TO_CHAR(SESSION_TASK_INST_RUN.END_TIME, 'yyyy-MM-dd'), 'yyyy-MM-dd') as END_TIME,  (COUNT(SESSION_TASK_INST_RUN.TASK_ID)) as TASK_ID FROM        REP_TASK_INST_RUN SESSION_TASK_INST_RUN,     REP_REPOSIT_INFO SESSION_TASK_REPOSIT_INFO  WHERE  (SESSION_TASK_INST_RUN.TASK_ID <> SESSION_TASK_REPOSIT_INFO.REPOSITORY_ID   AND  SESSION_TASK_INST_RUN.TASK_TYPE = 68) AND  (SESSION_TASK_INST_RUN.END_TIME IS NULL )  GROUP BY  SESSION_TASK_INST_RUN.SERVER_NAME,  SESSION_TASK_REPOSIT_INFO.REPOSITORY_NAME,  TO_DATE(TO_CHAR(SESSION_TASK_INST_RUN.END_TIME, 'yyyy-MM-dd'), 'yyyy-MM-dd')) "query"