SQL query to get least access project in ALM ?
Question ID:
107083
| ♥ 0 |
SQL query to get least access project details in ALM and please help.
Marked as spam
|
Answers (2)
|
Private answer
@prathap7475 The data for this would be stored in either the SESSION_LICENSE, SESSION_LICENSE_HISTORY, or SESSIONS_HISTORY tables in the qcsiteadmin_db database schema. The query would depend on how you are defining least accessed. This could be any of the following just for thought. - Least accessed from a specific prior date range (project has been accessed 3 time in past month) Marked as spam
 Posted by jafar (Questions: 3, Answers: 168) Answered on September 23, 2016 1:25 pm
|
|
|
Private answer
Thank you @jafar :) Marked as spam
 Posted by prathap7475 (Questions: 23, Answers: 3) Answered on September 28, 2016 9:35 am
|