Cool Solutions

GroupWise Mailbox Size Reports using the Admin Console

Laura Buckley

By:

October 7, 2016 8:40 am

Reads:5,728

Comments:6

Score:5

Print/PDF

Managing the size of our GroupWise system is something that we should be doing proactively.  This not something you want to neglect and then face a situation where your system is out of disk space and thus won’t process mail. Imagine this happening in the middle of a working day – no email and you are trying to fix disk space issues – not pleasant, and something that can be avoided.

Mailbox size quotas is one way to manage how much space each user may use.  It is my experience that without restricting, within reason, how much historical mail may be stored, users will consume all that is available to them, thus all available disk space available to your GroupWise system.

You can generate Mailbox size reports using Curl at the command line. Here is the command:

curl -k --user gwadmin:adminpwd https://10.10.10.10:9710/gwadmin-service/list/user.csv?attrs=domain,postoffice,name,mailboxSizeMb > mailboxsize.csv

That’s pretty neat and straight forward.  However, not all GroupWise administrators have root access to their servers.  With security auditing and separation of duties becoming more prevalent this might just be the case for you.

Do not despair.  We can generate a .csv file on mailbox size from within the GroupWise Admin Console using the Advanced Querying and Reporting feature.  This means that we may report on mailbox sizes meeting specific criteria, for example, all mailboxes over 500 Mb.

First things first.  You will want to ensure that your stats on mailbox size is up to date.  To ensure that this is the case you first run an audit report on your system.  To outline this process:

Admin Console -> System -> Information -> Audit Report

Note that this will take some time to complete depending on the size of your GroupWise system.

You can create the mailbox size report per post office, domain, or system.

In our example we’re going to create a mailbox size report for one particular post office.

  1. Open/Login to the GroupWise Admin Console
  2. Click on Post Offices in menu on the left-hand side of the screen.
  3. Select the relevant post office from the selection screen.
  4. Once the properties of the post office display, select Users to retrieve a list of all users in that post office.
  5. Just above the list of users, on the right-hand side of the screen, is an entry box that looks like this:

001

Figure 1:  Search Entry Box

  1. Click once in the Search Entry Box to make it active.
  2. Now, here comes the magic, press CTRL+SPACE to access the Advanced Querying and Reporting feature.
  3. A drop-down list will appear with all the advanced criteria options.
  4. Scroll down this list until you find mailboxSizeMb

002

Figure 2:  Advanced Filter Criteria

  1. Select the MailboxSizeMb option by clicking on it once.
  2. Now enter the operator you wish to use: > = greater than, or < = less than.
  3. Once you have entered your operator enter the number of megabytes you wish to filter on. For example:  MailboxSizeMB > 500 will create a filtered list of all mailboxes that are over 500Mb.  The filtered list will display.
  4. Click on the Export button found above the filtered list, roughly in the middle of the toolbar.

003

Figure 3:  Export Button

  1. A dialog box will display. Click on Ok to continue with your data export.

004

Figure 4:  Confirmation Dialog Box

  1. Browse to the location in which you want to save your .csv export file and give it a name.
  2. Open your .csv file in a spreadsheet application of your choice.
  3. Slice-and-dice the information anyway it suits you.

I encourage you to explore the other reporting options available on the drop-down list.  The list is fairly extensive and gives you the ability to pull some very powerful reports on your GroupWise system.

I trust that you find this article useful.  If you have any suggestions for future articles please do not hesitate to contact me.

4 votes, average: 5.00 out of 54 votes, average: 5.00 out of 54 votes, average: 5.00 out of 54 votes, average: 5.00 out of 54 votes, average: 5.00 out of 5 (4 votes, average: 5.00 out of 5)
You need to be a registered member to rate this post.
Loading...

Tags: , ,
Categories: Collaboration, GroupWise, Technical

6

Disclaimer: This content is not supported by Micro Focus. It was contributed by a community member and is published "as is." It seems to have worked for at least one person, and might work for you. But please be sure to test it thoroughly before using it in a production environment.

6 Comments

  1. By:Laura Buckley

    Hi Folk,

    Just an update on my article. You may install Curl on a Windows pc and use that to run the Curl commands against your GroupWise servers to complete commands requiring Curl. You will not need root OS access to your Linux servers to accomplish this.

    Many thanks to Morris.

    Cheers,

  2. By:booktrunk

    Thanks Laura.

    That’s really useful.

  3. If you don’t see the column showing used space (i.e. default settings) you need to go add it.

    Select the main Users option on the far left (not just Domain or PostOffice levels).
    Just above the search field is a gear icon that lets you select the columns you want to see. Once you’ve done that, those selections are what you will see for all User lists in GWAdmin
    for where ever you log in with your ID.

    As for the URLs you see in the CURL commands, try them in a browser and then log in with a GroupWise administrator account (shows in System, Administrators for any level. I’ve been playing with them and may well have a CoolSolution of my own shortly about what you can do there.

  4. By:Eric2001

    Laura, am i missing something? I’m using Linux for my GW system. I do NOT see the EXPORT button. I can put in my criteria and press enter (i.e. mailboxSizeMb>2000) and if does filter the list immediately, but I have no EXPORT button and no way to add mailbox size to the columns like we did in ConsoleOne. Great article if we can get it to work for us. We’ve wanted this for sometime now.

    • By:Laura Buckley

      Hi,

      With regards to the size column. In the GroupWise Admin Console select Users from the menu on the left-hand side. Once the list of users has populated in the main screen look above the Search entry box on the top right-hand side and find a little cog/gear icon. Click on that. Select “Current Mailbox Size (Mb)” from the drop-down available options on the right-hand side. Add that to the “Selected Columns”. Click on OK. Now the mailbox size column will be visible. Do that and then let us know if the export button shows up. Please also confirm what version of GroupWise 2014 you are running as I’m not sure when exactly the Export button was added or if it was always there in 2014.

      Looking forward to hearing back from you.

      Cheers,

Comment

RSS