I need to know ALM usage for the last 6 months.

Question ID: 109156
0
0

In the ALM, I want to know how many, who and when people have logged in within the last 6 months.
I think I have version 12.5
Is there a way to that?

Marked as spam
Posted by (Questions: 103, Answers: 7)
Asked on August 1, 2019 2:20 am
4 views
Answers (1)
0
Private answer

There is no way to get this information with any of the built-in reporting or graphing tools that come with QC/ALM. This infromation is stored in the qc_siteadmindb database and none the the built-in reports can access it.

The information that you are looking for is stored in the qc_siteadmindb --> SESSIONS_HISTORY table on the database server.

This table holds information on...

The user name
When the user loggin
When the user logged out
The project and the domain they logged into
The type of client used (ex Client UI or Excel Add-in)

If you are using MS SQL you can query the entire table and export it to Excel where you filter the information

Marked as spam
Posted by (Questions: 0, Answers: 297)
Answered on August 1, 2019 2:22 am