Re: How to find out when a project was last accessed
Here is the query for finding out when a project was last connected to. Where it says "qcsiteadmin_db10" substiture the name of your site admin database.
select PROJECTS.DOMAIN_NAME, PROJECTS.PROJECT_NAME, MAX(SESSIONS_HISTORY.START_TIME)
left outer join qcsiteadmin_db10.td.SESSIONS_HISTORY SESSIONS_HISTORY
on (PROJECTS.PROJECT_NAME=SESSIONS_HISTORY.PROJECT_NA ME) AND (PROJECTS.DOMAIN_NAME=SESSIONS_HISTORY.DOMAIN_NAME )
GROUP by PROJECTS.DOMAIN_NAME, PROJECTS.PROJECT_NAME
(Opinions and information contained in this post are wholly my own and do not reflect the opinions of my employer.)