Quality Center – Site Analysts Gui – Query Used

  • Questions
  • Quality Center - Site Analysts Gui - Query Used
Question ID: 104157
1
0

Does anyone know what query the QC server uses to display the Site Analysis GUI?

The same goes for the License Status GUI?

Thank you

Marked as spam
Posted by (Questions: 1, Answers: 0)
Asked on July 15, 2010 6:11 pm
22 views
Answers (1)
0
Private answer

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.

Marked as spam
Posted by (Questions: 0, Answers: 2)
Answered on August 10, 2010 5:24 pm