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.
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