[Home] [Help]
View: JTF_PF_CLKSTRM_VL
View Text
(
SELECT
X.PAGEOBJECT.INFO.RECID
,
X.PAGEOBJECT.INFO.DAY
,
X.PAGEOBJECT.INFO.TIMESTAMP
,
X.PAGEOBJECT.DPF.PHYSICALPAGEID
,
X.PAGEOBJECT.DPF.LOGICALPAGEID
,
X.PAGEOBJECT.DPF.FLOWID
,
X.PAGEOBJECT.SES.APPID
,
X.PAGEOBJECT.SES.RESPID
,
X.PAGEOBJECT.SES.USERID
,
X.PAGEOBJECT.SES.SESSIONID
,
X.PAGEOBJECT.SES.LANGID
,
X.PAGEOBJECT.JSP.SCHEME
,
X.PAGEOBJECT.JSP.METHOD
,
X.PAGEOBJECT.JSP.NAME
,
X.PAGEOBJECT.JSP.STARTTIME
,
X.PAGEOBJECT.JSP.EXECUTIONTIME
,
X.PAGEOBJECT.JSP.STATUSCODE
,
X.PAGEOBJECT.JSP.CONTENTTYPE
,
X.PAGEOBJECT.JSP.CONTENTLENGTH
,
X.PAGEOBJECT.LOC.SERVERNAME
,
X.PAGEOBJECT.LOC.SERVERPORT
,
X.PAGEOBJECT.LOC.JSERVPORT
,
X.PAGEOBJECT.LOC.CLIENTNAME
,
X.PAGEOBJECT.LOC.CLIENTIP
,
X.PAGEOBJECT.LANG.SESSIONLANGUAGECODE
,
X.PAGEOBJECT.LANG.SERVERCHARACTERENCODING
,
X.PAGEOBJECT.LANG.PAGECHARACTERENCODING
,
X.PAGEOBJECT.LANG.CLIENTCHARACTERENCODING
,
X.PAGEOBJECT.LANG.CLIENTACCEPTEDLANGUAGES
,
X.PAGEOBJECT.LANG.CLIENTACCEPTEDCHARSETS
,
X.PAGEOBJECT.CLIENT.AUTHTYPE
,
X.PAGEOBJECT.CLIENT.PROTOCOL
,
X.PAGEOBJECT.CLIENT.REFERER
,
X.PAGEOBJECT.CLIENT.USERAGENT
,
X.PAGEOBJECT.CLIENT.CONTENTTYPE
,
X.PAGEOBJECT.CLIENT.CONTENTLENGTH
,
JTF_PF_CONV_PKG.GETPARAMSTRING(X.PAGEOBJECT.PARAMS)
,
JTF_PF_CONV_PKG.GETCOOKIESTRING(X.PAGEOBJECT.COOKIES)
FROM JTF_PF_REPOSITORY X
)