cyrus accounts and monitoring activity/usage
pegasus at nerv.eu.org
Mon Aug 25 15:22:15 EDT 2003
On Mon, 25 Aug 2003 11:15:52 -0700 (PDT)
joe ritter <glestadt4 at yahoo.com> wrote:
> I am interested in looking at stats such as users that
> have never logged in, users that have accessed their
> account in the last 30 days, 60 days and 90 days etc.
We're using auxprop with mysql auth and it was trivial to add a couple more
lines into sasl to do another sql query upon auth attempt to update
last_seen field with now(). Then it is trivial to rank users among those
that visit daily, weekly, monthly or only once in a while ...
I still have to take some time and develop this further to run separate
queries on successful login and on failed login ...
More information about the Info-cyrus