How to tell when the last login to a project was
Question ID:
107251
| ♥ 0 |
We are trying to deactivate projects that have not used for more than 6 month. Can you tell how to identify projects via ALM Administration or via backend where there was no login activity in the past 6 months, please?
Marked as spam
|
Posted by Answers (1)
|
Private answer
There is a LAST_TOUCH_TIME field in the PROJECTS table of the qcsiteadmin_db database that should have the information that you are looking for. This query should work you will need to run it from the SQL Management Studio select PROJECT_NAME, LAST_TOUCH_TIME Marked as spam
 Posted by jefptman (Questions: 0, Answers: 309) Answered on November 4, 2016 2:57 pm
|