[Home] [Help]
View: JTF_PF_HOST_SUMMARY_VL
View Text
SELECT MASTER.DAY DAY
, MASTER.SERVERNAME SERVERNAME
, MASTER.SERVERPORT SERVERPORT
, MASTER.JSERVS JSERVS
, SUM_EXECT_JTF
, SUM_EXECT_OAF
, PAGEHITS_JTF
, PAGEHITS_OAF
, NVL(ERRATA.FAILS
, 0) FAILS
, MASTER.PAGES PAGES
, NVL(ERRATA.BADPAGES
, 0) BADPAGES
FROM (SELECT DAY
, SERVERNAME
, SERVERPORT
, COUNT(UNIQUE(JSERVPORT)) JSERVS
, SUM(DECODE(TECH_STACK
, 'JTF'
, EXECT
, 0)) SUM_EXECT_JTF
, SUM(DECODE(TECH_STACK
, 'OAF'
, EXECT
, 0)) SUM_EXECT_OAF
, SUM(DECODE(TECH_STACK
, 'JTF'
, 1
, 0)) PAGEHITS_JTF
, SUM(DECODE(TECH_STACK
, 'OAF'
, 1
, 0)) PAGEHITS_OAF
, COUNT(UNIQUE(PAGENAME)) PAGES
FROM JTF_PF_ALL_ACTIVITY_VL GROUP BY DAY
, SERVERNAME
, SERVERPORT ) MASTER
, (SELECT DAY
, SERVERNAME
, SERVERPORT
, COUNT(*) FAILS
, COUNT(UNIQUE(PAGENAME)) BADPAGES
FROM JTF_PF_ALL_ACTIVITY_VL
WHERE STATUSCODE = -100 GROUP BY DAY
, SERVERNAME
, SERVERPORT ) ERRATA
WHERE MASTER.DAY = ERRATA.DAY(+)
AND MASTER.SERVERNAME = ERRATA.SERVERNAME(+)
AND MASTER.SERVERPORT = ERRATA.SERVERPORT(+)
Columns
Name |
DAY |
SERVERNAME |
SERVERPORT |
JSERVS |
SUM_EXECT_JTF |
SUM_EXECT_OAF |
PAGEHITS_JTF |
PAGEHITS_OAF |
FAILS |
PAGES |
BADPAGES |