cyrus accounts and monitoring activity/usage

[Jure Pecar]

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 ... 


-- 

Jure Pecar