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

[aj87]

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

 

[Paul B]

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]

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

 

[Paul B]

Run this query in phpMyAdmin:

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.

 

[AndyB]

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

You might like this add-on:

https://www.xf2addons.com/resources/user-agent.18/

 

[Ozzy47]

That does nothing of what the OP asked for.

 

[Robert9]

It is just that what op has asked!
See all users from the last 24 (or x) hours.
If there is nothing better this one helps.

 

[aj87]

You might like this add-on:

https://www.xf2addons.com/resources/user-agent.18/

this add-on done exactly what I wanted - thanks @AndyB