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.

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”