We have a requirement where we would like to know the details of users and projects which were not accessed for a quite long time, can anyone tell me how can we achieve this or any query which you are using for pulling the same.
You can derive the information from the SESSIONS_HISTORY table in the Site Admin database. This is the query I use within a Crystal Report.
select PROJECTS.DOMAIN_NAME, PROJECTS.PROJECT_NAME, MAX(SESSIONS_HISTORY.START_TIME)
left outer join qcsiteadmin_db.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