Quality Center Support and News
Showing results for 
Search instead for 
Do you mean 

SQL query : Calculate license utilise by project for a given period of time

Highlighted
Occasional Advisor

SQL query : Calculate license utilise by project for a given period of time

There is a Site Analysis tab i QC which store the license utilise by the individual project. Can you please provide the Query to find license utilise by individual.

 

Many Thanks.

4 REPLIES
Honored Contributor Honored Contributor

Re: SQL query : Calculate license utilise by project for a given period of time

Once you login as site admin, under site analysis....click on site analysis.

 

Click on Filert and then choose projects/users etc..

Occasional Advisor

Re: SQL query : Calculate license utilise by project for a given period of time

Thank for your reply.

 

I want the SQL Query for the same. In which database table this information is store. How can we fetch the details.

Honored Contributor Honored Contributor

Re: SQL query : Calculate license utilise by project for a given period of time

did you check qcsiteadmin_db?

 

The data about connections and licenses is stored in the SESSIONS_HISTORY and SESSION_LICENSE_HISTORY tables in qcsiteadmin_db.

 

SESSIONS_HISTORY table shows all connections i.e. user sessions, while SESSION_LICENSE_HISTORY table shows the license usage generated from each user session. 

 

USERS table holds the info about the users.

 

 

Occasional Advisor

Re: SQL query : Calculate license utilise by project for a given period of time

Thanx for you reply.

 

Actually I need the information as below

 

Date                  Project name          license utilised

12-2-2014        Project1                        30

12-3-2014        Project1                        30

 

In above query it shows userwise license utilised. I need project name and license utilised by them.