[horde] which table holds the data of last_login?

[Otto Stolz]

PS.
> Does anybody has code to achieve this? (those who have not logged in  
> in last three months).

For those who have *not* logged in, you have to reverse
the comparison in the "where" clause, of course:

    select from_unixtime(pref_value,"%Y-%m-%d") as "Last Login",
           pref_uid                             as User
    from horde_prefs
    where pref_name="last_login"
      and from_unixtime(pref_value,"%Y%m%d")<20071010
    order by pref_value;

Of course, you can always order by any other column, as required.

Good luck,
   OS