This discussion is archived
2 Replies Latest reply: Nov 5, 2007 11:32 PM by 390361 RSS

How to check used mail quota for any OCS user

525756 Newbie
Currently Being Moderated
Hi,

I want find out how much mail quota any OCS email user has used so far.
I am using OCS 10.1.2 release.

Any input will be highly appreciated.

Thanks,
Sujit
  • 1. Re: How to check used mail quota for any OCS user
    548107 Newbie
    Currently Being Moderated
    Please check UM Quota Report

    1) Login to es_mail schema

    2a) EXECUTE THE BELOW QUERY to fetch for all users

    select u.usage, f.folder_name
    from es_user u, es_folder f
    where u.userid=f.userid
    and f.folder_name like '%INBOX'
    order by u.usage desc

    OR

    2b) EXECUTE THE BELOW QUERY to fetch for a user.
    If you want to check the quota for a user named "kilavela" then use the below QUERY

    select u.usage, f.folder_name
    from es_user u, es_folder f
    where u.userid=f.userid
    and f.folder_name like '%INBOX'
    and f.folder_name like '%kilavela%'
  • 2. Re: How to check used mail quota for any OCS user
    390361 Newbie
    Currently Being Moderated
    Hi...

    Can you describe detaily step by step how to :

    1) Login to es_mail schema ........ because i'm a newbie

    2a) EXECUTE THE BELOW QUERY to fetch for all users

    select u.usage, f.folder_name
    from es_user u, es_folder f
    where u.userid=f.userid
    and f.folder_name like '%INBOX'
    order by u.usage desc

    OR

    2b) EXECUTE THE BELOW QUERY to fetch for a user.
    If you want to check the quota for a user named "kilavela" then use the below QUERY

    select u.usage, f.folder_name
    from es_user u, es_folder f
    where u.userid=f.userid
    and f.folder_name like '%INBOX'
    and f.folder_name like '%kilavela%'


    Thank you...