QC/ALM license usage information for reporting?
Question ID: 104846
1
0

How can I run reports on license usage? Site Analysis in Site Admin isn’t quite getting me what I need. I want to be able to access the database directly for my own reporting, but don’t know where to look.

Marked as spam
Posted by (Questions: 424, Answers: 91)
Asked on February 4, 2013 4:37 pm
107 views
Answers (1)
1
Private answer

The information you're looking for is held in the Site Admin database's SESSIONS_HISTORY table. You can run your SQL queries against this table which contains these fields:

- **Session ID** (int): Unique ID (Primary key).
- **Start_Time** (DateTime): Date and time that the user logged in.
- **End_Time** (DateTime): Date and time that the user logged out. If null it means the session is active.
- **Domain_Name** (Varchar 255): Domain of the project which the user logged in to.
- **Project_Name** (Varchar 255): Project that the user logged in to.
- **User_Name** (Varchar 60): User name.
- **Client_Type** (Varchar 50): Client type (either a normal user or a QTP test execution client).

So, for example, if you wanted to report on how many users logged in for a specific date:

SELECT user_name,count(*)
FROM qcsiteadmin_db.SESSIONS_HISTORY
WHERE START_TIME >= '02-FEB-13?
group by user_name
order by count(*) desc

Marked as spam
Posted by (Questions: 0, Answers: 771)
Answered on February 4, 2013 4:45 pm
0
Excellent! Running my queries against SESSIONS_HISTORY is exactly what I needed. Thanks!
( at February 4, 2013 4:46 pm)
EyeOnTesting

Welcome back to "EyeOnTesting" brought to you by Orasi Software, Inc.

X
Scroll to Top