SELECT SEQID,DAY,TIMESTAMP,SERVERNAME,SERVERPORT,JSERVPORT,FLOWID,SESSIONID,USERID,APPID,RESPID,LANGID,STARTT,PAGENAME,STATUSCODE,EXECT,THINKT,PO,TECH_STACK,PROXYID from JTF_PF_SES_ACTIVITY UNION ALL select SEQID,DAY,TIMESTAMP,SERVERNAME,SERVERPORT,JSERVPORT,FLOWID,SESSIONID,USERID,APPID,RESPID,LANGID,STARTT,PAGENAME,STATUSCODE,EXECT,THINKT,PO,TECH_STACK,PROXYID from JTF_PF_ANON_ACTIVITY
SELECT SEQID
, DAY
, TIMESTAMP
, SERVERNAME
, SERVERPORT
, JSERVPORT
, FLOWID
, SESSIONID
, USERID
, APPID
, RESPID
, LANGID
, STARTT
, PAGENAME
, STATUSCODE
, EXECT
, THINKT
, PO
, TECH_STACK
, PROXYID
FROM JTF_PF_SES_ACTIVITY UNION ALL SELECT SEQID
, DAY
, TIMESTAMP
, SERVERNAME
, SERVERPORT
, JSERVPORT
, FLOWID
, SESSIONID
, USERID
, APPID
, RESPID
, LANGID
, STARTT
, PAGENAME
, STATUSCODE
, EXECT
, THINKT
, PO
, TECH_STACK
, PROXYID
FROM JTF_PF_ANON_ACTIVITY
|
|
|