How to get a table of registered users who logged in during the last month

Hi Kyle,

One of my investors wants to have a table that shows who went onto the website and logged in and when and that during the last month (so if user ID xyz went on it several times per month then it should show each of these logins).

Any SQL table that tracks that? Antispam-plugin maybe?

Create a userlist with an advanced filter on the lastvisitdate, which is the last date they logged in. You can access it using u.`lastvisitdate` in your query. Using SQL date functions you can limit to only those who last logged in within the previous month. See the below for date function usages.

dev.mysql.com/doc/refman/5.6/en/date-and-time-functions.html

The below might work (untested).

Hi,

This is not what I meant

Is any part of CB (plugin or core) logging somewhere in the database which registered user has logged in when (and not only last login date since they are using the website every day)? I would then export the table as CSV, format it, make it look pretty and send it off to the investor (dont want to present this on the front-end).

Also, you have a bug in the email notifications. The READ MORE and the link in the email were missing the domain name:..

Here is what I did which possibly caused the problem: I clicked on NEW TOPIC in the Kunena header bar and then chose the Professional Forum.

Is any part of CB (plugin or core) logging somewhere in the database which registered user has logged in when (and not only last login date since they are using the website every day)? I would then export the table as CSV, format it, make it look pretty and send it off to the investor (dont want to present this on the front-end).

No, last visit date, registration date, and last update date are all that are tracked. The first 2 are entirely tracked by Joomla and are in the _users table.

Also, you have a bug in the email notifications. The READ MORE and the link in the email were missing the domain name:..

Known Kunena bug. We're working on an RC here so bound to be some issues