SQL query to get least access project in ALM ?

  • Questions
  • SQL query to get least access project in ALM ?
Question ID: 107083
0
0

SQL query to get least access project details in ALM and please help.

Marked as spam
Posted by (Questions: 23, Answers: 3)
Asked on August 31, 2016 9:01 am
72 views
Answers (2)
0
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)
- The project with the longest time since last accessed (project hasn't been accessed in 3 months)
- Least accessed by current/active sessions (project has 3 active users, all other projects have more)

Marked as spam
Posted by (Questions: 3, Answers: 168)
Answered on September 23, 2016 1:25 pm
0
Private answer

Thank you @jafar :)

Marked as spam
Posted by (Questions: 23, Answers: 3)
Answered on September 28, 2016 9:35 am
EyeOnTesting