SQL query : Calculate license utilise by project for a given period of time (145 Views)
Reply
Occasional Contributor
ADUGAR
Posts: 9
Registered: ‎01-08-2014
Message 1 of 5 (145 Views)

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.

Please use plain text.
Honored Contributor
shiv_p
Posts: 2,832
Registered: ‎04-23-2008
Message 2 of 5 (124 Views)

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..

Please use plain text.
Occasional Contributor
ADUGAR
Posts: 9
Registered: ‎01-08-2014
Message 3 of 5 (106 Views)

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.

Please use plain text.
Honored Contributor
shiv_p
Posts: 2,832
Registered: ‎04-23-2008
Message 4 of 5 (98 Views)

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.

 

 

Please use plain text.
Occasional Contributor
ADUGAR
Posts: 9
Registered: ‎01-08-2014
Message 5 of 5 (73 Views)

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.

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation