2 Replies Latest reply on Nov 6, 2007 7:32 AM by 390361

    How to check used mail quota for any OCS user

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