select day, seqid, sessionid, user_name, userid,
sum_exect_jtf+sum_exect_oaf+sum_exect_form sum_exect,
sum_thinkt_jtf+sum_thinkt_oaf+sum_thinkt_form sum_thinkt,
cnt_pages_all cnt_pages,
ucnt_pages, ucnt_flows, ucnt_apps, ucnt_resps, ucnt_langs,
startt, endt, cnt_fail
from jtf_pf_session_summ
SELECT DAY
, SEQID
, SESSIONID
, USER_NAME
, USERID
,
SUM_EXECT_JTF+SUM_EXECT_OAF+SUM_EXECT_FORM SUM_EXECT
,
SUM_THINKT_JTF+SUM_THINKT_OAF+SUM_THINKT_FORM SUM_THINKT
,
CNT_PAGES_ALL CNT_PAGES
,
UCNT_PAGES
, UCNT_FLOWS
, UCNT_APPS
, UCNT_RESPS
, UCNT_LANGS
,
STARTT
, ENDT
, CNT_FAIL
FROM JTF_PF_SESSION_SUMM
|
|
|