XF 2.2 How can I see last activity of all users in one go?

aj87

Member
Hi

How can I see last activity of all users in one go?
I know I can go into list all users and sort by last activity, but what i want to do is to show or export a list of all users with their last activity

thanks
 

Brogan

XenForo moderator
Staff member
That would require some form of custom development.

However, all you're going to get is a date if there is no session activity record (which there won't be for any member who hasn't been active very recently).
 

aj87

Member
That would require some form of custom development.

However, all you're going to get is a date if there is no session activity record (which there won't be for any member who hasn't been active very recently).
Yes this is what i want. Just literally a list of users and the date of their last activity on the forum
 

Brogan

XenForo moderator
Staff member
Run this query in phpMyAdmin:

SQL:
SELECT user_id, username, email, FROM_UNIXTIME(last_activity) FROM xf_user ORDER BY last_activity DESC

Export the output as required - sql, txt, csv, etc.
 
Top