On 10/31/07, Marc Dirix <[EMAIL PROTECTED]> wrote: > > select userid from dbmail_users where maxmail_size!=0 and > maxmail_size < curmail_size; > ___
Thanks Mark but for if calculation based on percentage, maxmail_size < curmail_size is not suitable because almost full mailboxes are not included. Almost full = 100% which is translated as overquota or full mailboxes. Of course the sql can be modified further. Thanks. -- zamri Linux System Administrator Kolej ShahPutra Kuantan Pahang Malaysia Tel : 609.573.777.7 ext 119 web : http://muhdzamri.blogspot.com
_______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
