Users Activity.

Tags:
Question ID: 104580
1
0

Hi!

I want to make a report that shows list of all users and date and time when they logged in ALM11 last time. I want to know their last activity as well.

Thank you

Marked as spam
Posted by (Questions: 1, Answers: 1)
Asked on August 29, 2012 3:10 pm
23 views
Answers (3)
1
Private answer

What do you want to use to construct the report?

What specific ''last activity'' do you want to report?

This SQL will show you the last time each user logged in, based on the information stored in the SESSIONS_HISTORY table in the Site Admin database. How far back in time that data goes is based on a configuration parameter in Site Administration.

select USER_NAME, MAX(START_TIME) from SESSIONS_HISTORY GROUP by USER_NAME

As written, this query will show the last login time only for users who have actually logged in. So, the output will not include users in you User table that have never logged in (or for whom there is no remaining history of a login).

Marked as spam
Posted by (Questions: 1, Answers: 101)
Answered on August 29, 2012 4:56 pm
1
Private answer

This query will give you the list of all users currently defined in the USERS table in Site Admin, with the last time they logged on. It will include users who have no history of logging in remaining in the SESSIONS_HISTORY table.

select [User],max(START_TIME) as ''Login_TS''
from
(
select USER_NAME as ''User'' from USERS
) AllUsers
left outer JOIN SESSIONS_HISTORY ON [User]=SESSIONS_HISTORY.USER_NAME
group by [User]

Marked as spam
Posted by (Questions: 1, Answers: 101)
Answered on August 29, 2012 5:27 pm
1
Private answer

Thank You!

Marked as spam
Posted by (Questions: 1, Answers: 1)
Answered on August 30, 2012 9:55 am