You can either set the log level in Site Admin to ''Debug'' and go look in the logs for the specific query, or you can try this query
SELECT START_TIME AS EVENT_TIME,
1 AS EVENT_TYPE,
IDENTIFIER,
DEFECTS,
REQUIREMENTS,
TESTLAB FROM (SELECT SESSIONS_HISTORY.*,
(SELECT MIN((SLH_MUID + SLH_USER_NAME)) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID) AS IDENTIFIER,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=3) as REQUIREMENTS,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=13) as COMPONENTS,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=10) as ADVANCED_REPORTS,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=7) as MANAGEMENT,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=12) as DASHBOARD_OLD,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=11) as DASHBOARD,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=9) as VC_ENABLED,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=2) as TESTLAB,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=1) as DEFECTS FROM SESSIONS_HISTORY) HISTORY_START_TIME_TABLE
WHERE ( (END_TIME IS NULL) OR (END_TIME >= /P/YYYY-MM-DD 00:00:00.0) )
UNION ALL
SELECT END_TIME AS EVENT_TIME,
2 AS EVENT_TYPE,
IDENTIFIER,
DEFECTS,
REQUIREMENTS,
TESTLAB FROM (SELECT SESSIONS_HISTORY.*,
(SELECT MIN((SLH_MUID + SLH_USER_NAME)) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID) AS IDENTIFIER,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=3) as REQUIREMENTS,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=13) as COMPONENTS,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=10) as ADVANCED_REPORTS,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=7) as MANAGEMENT,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=12) as DASHBOARD_OLD,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=11) as DASHBOARD,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=9) as VC_ENABLED,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=2) as TESTLAB,
(SELECT COUNT(*) FROM SESSION_LICENSE_HISTORY WHERE SLH_SESSION_ID=SESSION_ID AND SLH_LICENSE_TYPE=1) as DEFECTS FROM SESSIONS_HISTORY) HISTORY_END_TIME_TABLE
WHERE ( (END_TIME IS NULL) OR (END_TIME >= /P/YYYY-MM-DD 00:00:00.0) ) AND (END_TIME IS NOT NULL)
ORDER BY EVENT_TIME
Raj.