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.
Once you login as site admin, under site analysis....click on site analysis.
Click on Filert and then choose projects/users etc..
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.
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.
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.