[Home] [Help]
View: JTF_MON_USTAT
Product: | JTF - CRM Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
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
Name |
USER_NAME |
RESP_ID |
APP_ID |
SESSION_CNT |
PAGE_CNT |
PAGES_PER_SESSION |
FIRST_OCCURRENCE |
LAST_OCCURRENCE |