Connection Usage Details

Displays sessions associated with a particular connection by repository by folder. This report is the first node in the analytic workflow associated with the Connection Usage primary report.

Click on the text to copy the query report to your clipboard.


SELECT "SUBJECT_AREA",
"WIDGET_TYPE",
"READER_WRITER_TYPE",
"REPOSITORY_NAME",
"SESSION_NAME",
"WIDGET_INSTANCE_ID",
"SESSION_INSTANCE_NAME",
"CNX_NAME",
"WORKFLOW_NAME"
FROM ( SELECT SESSION_REPOSIT_INFO.REPOSITORY_NAME,
ALL_SESSIONS.SUBJECT_AREA,
SESSION_LOG.WORKFLOW_NAME,
ALL_SESSIONS.SESSION_NAME,
SESSION_LOG.SESSION_INSTANCE_NAME,
SESSION_ALL_CNXS.CNX_NAME,
SESSION_ALL_CNXS.READER_WRITER_TYPE,
CASE
WHEN SESSION_ALL_CNXS.WIDGET_TYPE = 2
THEN
'Target Connection'
ELSE
CASE
WHEN SESSION_ALL_CNXS.WIDGET_TYPE IN (1,
3,
56,
45,
55,
84)
THEN
'Source Connection'
ELSE
NULL
END
END
AS WIDGET_TYPE,
(COUNT (SESSION_ALL_CNXS.WIDGET_INSTANCE_ID))
AS WIDGET_INSTANCE_ID
FROM REP_LOAD_SESSIONS ALL_SESSIONS,
REP_SESS_WIDGET_CNXS SESSION_ALL_CNXS,
REP_REPOSIT_INFO SESSION_REPOSIT_INFO,
REP_SESS_LOG SESSION_LOG
WHERE ( ALL_SESSIONS.SESSION_ID = SESSION_ALL_CNXS.SESSION_ID
AND ALL_SESSIONS.SESSION_VERSION_NUMBER =
SESSION_ALL_CNXS.SESSION_VERSION_NUMBER
AND ALL_SESSIONS.SESSION_ID <>
SESSION_REPOSIT_INFO.REPOSITORY_ID
AND ALL_SESSIONS.SESSION_ID = SESSION_LOG.SESSION_ID
AND ALL_SESSIONS.SESSION_VERSION_NUMBER =
SESSION_LOG.TASK_VERSION_NUMBER)
GROUP BY SESSION_REPOSIT_INFO.REPOSITORY_NAME,
ALL_SESSIONS.SUBJECT_AREA,
SESSION_LOG.WORKFLOW_NAME,
ALL_SESSIONS.SESSION_NAME,
SESSION_LOG.SESSION_INSTANCE_NAME,
SESSION_ALL_CNXS.CNX_NAME,
SESSION_ALL_CNXS.READER_WRITER_TYPE,
CASE
WHEN SESSION_ALL_CNXS.WIDGET_TYPE = 2
THEN
'Target Connection'
ELSE
CASE
WHEN SESSION_ALL_CNXS.WIDGET_TYPE IN (1,
3,
56,
45,
55,
84)
THEN
'Source Connection'
ELSE
NULL
END
END) "query"
ORDER BY "REPOSITORY_NAME", "SUBJECT_AREA"