View: JTF_MON_USTAT

View Text

SELECT UNAME.USER_NAME
, HIT.RESP_ID
, HIT.APP_ID
, HIT.SESSION_CNT
, HIT.PAGE_CNT
, HIT.PAGES_PER_SESSION
, HIT.STIME
, HIT.ETIME
FROM (SELECT USER_ID
, RESP_ID
, APP_ID
, COUNT(UNIQUE(SESKEY)) SESSION_CNT
, COUNT(PAGE_ID) PAGE_CNT
, COUNT(PAGE_ID) / COUNT(UNIQUE(SESKEY)) PAGES_PER_SESSION
, MIN(START_TIME) STIME
, MAX(START_TIME) ETIME
FROM JTF_MON_ACT_LOG GROUP BY TO_DATE(TO_CHAR(START_TIME
, 'DD-MON-YYYY'))
, USER_ID
, RESP_ID
, APP_ID) HIT
, JTF_MON_UNAME_LOOKUP UNAME
WHERE HIT.USER_ID = UNAME.USER_ID

Columns