02-09-2014 10:59 PM
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.
02-10-2014 03:46 AM
Once you login as site admin, under site analysis....click on site analysis.
Click on Filert and then choose projects/users etc..
02-10-2014 09:57 PM
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.
02-11-2014 01:09 AM
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.
02-12-2014 10:15 PM
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.