Applies To:
HP ALM
Issue:
The customer would like to see how many projects they have, and the last time the projects were logged into. This will help with the archive process.
Solution:
SELECT DOMAIN_NAME, PROJECT_NAME, max(END_TIME)
FROM qcsiteadmin_db.SESSIONS_HISTORY
Group By DOMAIN_NAME, PROJECT_NAME
Order By END_TIME asc