Thank You!

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]

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).