I need to know how to run usage reports on users logged into specified projects

  • Questions
  • I need to know how to run usage reports on users logged into specified projects
Question ID: 107853
1
0

I have projects A and B, and I would like to find out who is accessing project A, and who is accessing project B. I would also like to know who is accessing both projects A and B at any given time. How can I do this?

Marked as spam
Posted by (Questions: 219, Answers: 23)
Asked on September 1, 2017 9:00 pm
6 views
Answers (1)
1
Private answer

I will be glad to assist you with this request. You will need to run the following query against the qcsiteadmin database, so you may need to get your DBA involved if you don't have access to the database.

Report who's accessing Project A:

SELECT [START_TIME]
,[END_TIME]
,[DOMAIN_NAME]
,[PROJECT_NAME]
,[USER_NAME]
FROM [qcsiteadmin_db].[td].[SESSIONS_HISTORY]
WHERE PROJECT_NAME = 'Project_A'
Report who's accessing Project B:

SELECT [START_TIME]
,[END_TIME]
,[DOMAIN_NAME]
,[PROJECT_NAME]
,[USER_NAME]
FROM [qcsiteadmin_db].[td].[SESSIONS_HISTORY]
WHERE PROJECT_NAME = 'Project_B'
Report who's accessing Projects A and B:

SELECT [START_TIME]
,[END_TIME]
,[DOMAIN_NAME]
,[PROJECT_NAME]
,[USER_NAME]
FROM [qcsiteadmin_db].[td].[SESSIONS_HISTORY]
WHERE PROJECT_NAME IN ('Project_A', 'Project_B')

I hope this helps!

Marked as spam
Posted by (Questions: 2, Answers: 280)
Answered on September 1, 2017 9:04 pm