I want count for how many users have accessed the site

Re: I want count for how many users have accessed the site

by Rick Jerz -
Number of replies: 0
Picture of Particularly helpful Moodlers Picture of Testers

In configurable report format, try my code below.  You still need to decide what dates you are interested in seeing, and how you want to group them.  (When I run this, for example, dates shown as "1969" are for users who have never accessed the site.)

SELECT firstname, lastname,  

from_unixtime(lastaccess)

FROM prefix_user

order by lastaccess desc