[Home] [Help]
View: JTF_MON_PSTAT
Product: | JTF - CRM Foundation |
Description: | |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT PNAME.URL
, PNAME.DESCRIPTION
, PNAME.PAGE_NAME
, HIT.HITS
, HIT.SESSION_CNT
, HIT.SESLEN
, HIT.AVG_TIME
, HIT.STIME
, HIT.ETIME
FROM ( SELECT PAGE_ID
, COUNT(PAGE_ID) HITS
, COUNT(UNIQUE(SESKEY)) SESSION_CNT
, COUNT(PAGE_ID)/COUNT(UNIQUE(SESKEY)) SESLEN
, AVG(WEIGHT) AVG_TIME
, MIN(START_TIME) STIME
, MAX(START_TIME) ETIME
FROM JTF_MON_ACT_LOG GROUP BY PAGE_ID) HIT
, JTF_MON_PAGE_LOOKUP PNAME
WHERE HIT.PAGE_ID = PNAME.PAGE_ID
Columns
Name |
URL |
DESCRIPTION |
PAGE_NAME |
HITS |
SESSION_CNT |
PAGES_PER_SESSION |
AVG_TIME |
FIRST_OCCURRENCE |
LAST_OCCURRENCE |