Re: SQL query : Calculate license utilise by project for a given period of time (263 Views)
Reply
Occasional Advisor
ADUGAR
Posts: 10
Registered: ‎01-08-2014
Message 1 of 5 (335 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,841
Registered: ‎04-23-2008
Message 2 of 5 (314 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 Advisor
ADUGAR
Posts: 10
Registered: ‎01-08-2014
Message 3 of 5 (296 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,841
Registered: ‎04-23-2008
Message 4 of 5 (288 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 Advisor
ADUGAR
Posts: 10
Registered: ‎01-08-2014
Message 5 of 5 (263 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