Cool Solutions

GroupWise Mailbox Report Generator



By:

May 19, 2017 4:12 pm

Reads:1,737

Comments:2

Score:5

Print/PDF

Download MailBoxSizeReport.zip

Someone posted a question to the GroupWise support forum asking if any mailbox data is available in the GroupWise Admin Console. Unfortunately, only the mailbox size is available as a column in a user list. The poster specifically requested that the mailbox size limit would be useful to have.

This utility, MailboxSizeReport.exe was written in python using the GroupWise Rest API and compiled as a Windows (64-bit) application. Included in the download is a sample config file used to populate information on how to connect to the GroupWise Admin Service.

The utility will create an Excel spreadsheet showing all GroupWise users along with some user mailbox information. The information provided includes the GroupWise ID (Dom.PO.User), their current mailbox size in MB’s, the mailbox size limit in MB’s, the size threshold for warning users, and if the limits apply to the user’s caching mailbox.

Please see the help function in the utility for further details.

Enjoy.

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, Cool Tools, GroupWise

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.

2 Comments

  1. An awesome tool, thank you very much Morris for putting this together and sharing.

    Some observations for others using this:

    mailboxreport.xls is nicely readable with LibraOffice Calc and was generated successfully with a Windows7 system that does NOT have Microsoft Office at all.

    Setting the “Start in:” of a short cut to a different folder lets you have different gwconfig.cfg setups
    Ex: ClientA “Start in:” d:\clients\ClientA\GWwork & ClientB “Start in:” d:\clients\ClientB\GWwork each with appropriate gwconfig.cfg

    MailBoxSizeReport works when gwconfig.cfg has no password entered in gwconfig.cfg “gwpass = ” and then shows as blank in MailBoxSizeReport to hopefully trigger you to enter the password. Leaving that level of password in a clear text file isn’t the best of ideas.

    mailboxreport.xls overwrites any previous file by that name without warning. So remember to rename your mailboxreport.xls as a part of your generating process if you wish to use them to keep track of user mailbox growth.

    It would be nice to be able to configure a default directory for the report file in gwconfig.cfg so we wouldn’t have to browse each time and also useful for using for multiple systems. Clearing “Other Explorer MRUs” with tools such as CCleaner resets the folder you were last in back to the Windows default.

  2. By:booktrunk

    Thanks.

    It works a treat and it’s faster than exporting out of the web interface and messing around with it.

Comment

RSS