Is there any query to pull the details of the users that logged in QC for last 24hrs
like project name>user name > login time >logout time
I have access to the site admin database
I believe you will find what you are looking for in the SESSIONS_HISTORY table. You may need to combine it with other tables (like USERS) to get user names and PROJECTS to get project names.
I use the below SQL query to determine logon/logoff times and duration. Written for SQL Server.
SELECT [SESSION_ID] ,[START_TIME] ,[END_TIME] ,cast([END_TIME]-[START_TIME]as time(0))…
you can execute this query from the proj dashboard ...you dnt need access to qcsiteadmin