Need a SQL to see when users connect by project

  • Questions
  • Need a SQL to see when users connect by project
Question ID: 104451
3
0

Need a SQL to see when users connect by project

Marked as spam
Posted by (Questions: 23, Answers: 1)
Asked on January 25, 2012 2:07 pm
6 views
Answers (2)
3
Private answer

You can have your DBA run a SQL against the master qc database/schema (qcsiteadmin_db)to get the information.

SELECT
U.USER_NAME,
PROJECT_NAME,
START_TIME,
END_TIME,
U.USER_NAME as ''Logins''
FROM
td.SESSIONS_HISTORY H,
td.USERS U
WHERE U.USER_NAME = H.USER_NAME
AND U.USER_NAME <> '_SYSTEM_USER_'
ORDER BY PROJECT_NAME, USER_NAME, START_TIME

![alt text][1]

[1]: /upfiles/SQL_Results.jpg

Marked as spam
Posted by (Questions: 0, Answers: 613)
Answered on January 25, 2012 2:11 pm
Thanks Sammy!
( at January 25, 2012 2:12 pm)
0
Private answer

Try this also under the SESSIONS_HISTORY table which contains:

Session ID
Start_Time
End_Time
Domain_Name
Project Name
User_Name
Client_Type

Marked as spam
Posted by (Questions: 2, Answers: 3)
Answered on January 25, 2012 2:23 pm