Re: Report for Users logged into system and Duration
You can run a SQL query against the QCSITEADMIN_DB.SESSIONS_HISTORY table. For each connection, it provides start time, end time, domain and project, user ID, and client type (e.g., QC, "Testing Tool"/QTP, etc.). You can join this table to the QCSITEADMIN_DB.USERS table to get actual user names rather than user IDs.
Extract that to an Excel spreadsheet and you can adjust the data and pivot it to your heart's content.