Informatica help

Informatica help and metadata report query

Currently Active Sessions By Server

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"

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast