GroupWise Mailbox Size Reports using the Admin Console

3 Likes
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

  • Click on Post Offices in menu on the left-hand side of the screen.

  • Select the relevant post office from the selection screen.

  • Once the properties of the post office display, select Users to retrieve a list of all users in that post office.

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

  • Now, here comes the magic, press CTRL SPACE to access the Advanced Querying and Reporting feature.

  • A drop-down list will appear with all the advanced criteria options.

  • Scroll down this list until you find mailboxSizeMb


002

Figure 2:  Advanced Filter Criteria




  1. Select the MailboxSizeMb option by clicking on it once.

  • Now enter the operator you wish to use: > = greater than, or < = less than.

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

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

  • Open your .csv file in a spreadsheet application of your choice.

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

Labels:

How To-Best Practice
Comment List
Anonymous
Parents
  • 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.
  • Thank you Andy. Much appreciated :)
Comment Children
No Data
Related Discussions
Recommended