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