Labels

Wednesday, December 5, 2012

How to find Quality Center 10 last login details for all the projects using SQL?

Below is the query to get last login details for all the projects. We can execute this query in site admin so that it will save time in executing individual projects.


SELECT PROJECTS.DOMAIN_NAME as "DOMAIN NAME", PROJECTS.PROJECT_NAME as "PROJECT NAME", MAX(SESSIONS_HISTORY.START_TIME) as "LAST LOGIN"
FROM qcsiteadmin_db.PROJECTS left outer join qcsiteadmin_db.SESSIONS_HISTORY SESSIONS_HISTORY
On (PROJECTS.PROJECT_NAME=SESSIONS_HISTORY.PROJECT_NAME) AND (PROJECTS.DOMAIN_NAME=SESSIONS_HISTORY.DOMAIN_NAME)
GROUP by PROJECTS.DOMAIN_NAME, PROJECTS.PROJECT_NAME ;

No comments:

Post a Comment