Introduction

Welcome to GWMBSize 32 for Windows v0.3.2 Beta. The Windows version of the popular GWCheck.log parser. This version has most of the capabilities of the DOS version and more.

GWMBSize is a utility to report the mailbox usage of your Groupwise users. The Groupwise Postoffice by default generates a logfile every week after maintenance. You have the ability to change the default settings to include the 'collect statistics' option. After this the mailbox usage per user is added to the log file.

Unfortunately this log file is very inconvenient to review.

GWMBSize reads this log file and puts all the information in an MHT (MHTML) file for quick reviewing and printing. Also a CSV file is created to import the information in a spreadsheet.

Always keep in mind, that GWMBSize does not read the mailbox sizes or item counts directly form the Groupwise system, it simply reads the information in the logfile. For any questions about the values displayed in the log file contact Novell support. This utility is not responsable for obtaining the values only for formatting the values in a different way. Please see the disclaimer for more information.

System Requirements

Any Windows 98 or compatible computer, I would suggest 64MB RAM at least for Windows 98, and 256MB or more for Windows 2000 and XP. When using very large logfiles more RAM is recommended. Internet Explorer 4 or higher is required for the build in HTML viewer. Screen resolution of at least 800x600, 1024x768 or higher recommended.

GWMBSize supports any Groupwise version starting from 5.5 running on any platform.

GWMBSize 32 for Windows only runs in Windows 98 or higher. (Not tested on Windows 95)

Preparing your logfiles

This picture describes the usage of the GWCHK32.EXE utility located in the software directory of your Groupwise system. Please execute this file and enter the appropriate paths to the postoffice database and the postoffice name.

Select for the Action: "Analyze/Fix Databases" and enable "Contents" and "Collect statistics" also enable "User" and "Message" on the Databases TAB.
Make sure to remember the setting of the Logging tab or enter an know path. (Verbose logging is not neccesary.)

This picture describes the usage of the POA scheduled check utility. Please schedule an action as displayed in the picture below. Schedule this action for example once a week. When the job has run, the postoffice administrator receives an email with the result files. Copy this files to the GWMBSize directory, c:\gwmbsize

Make sure to enable "Send results to: Administrator"

After this copy the log file to your GWMBSize directory.: c:\program files\gwmbsize32

Usage

GWMBSize 32 for Windows has a GUI version and a commandline version build in. The GUI version is used for manual creation of the reports and testing the settings available.

If you use the commandline parameters documented in the next section the GUI will not be displayed. All options will be caried out, including debug created but it simply will not be displayed. At this time there will be a brief flash of the GUI when the commandline version terminates. Use the commandline version for batch processing.

WARNING: This beta version has no I/O error detection, bad files, no read/write rights will simply crash the program. Better I/O detection will be build in later. Make sure the program has enough rights on the disks it will read and write from, to avoid crashes.

GUI version:
The program will start with its log displayed first. In this screen all regular and debug information is displayed. How many information is displayed depends on the debug settings. By default only the regular information is displayed and debug information is stored in the debug32.txt file. This file is by default created in the same folder as the program executable.

New in this version is the ability to create a dummy log file for testing purposes. It is always a good practice to test a dummy file if you have any problems. Use the Advanced tab to create a dummy file. Start with small number of mailboxes, ie 100 will be sufficient. If you enter a value less then 10 the program will create 10 anyway.

Read and parse a GWCheck logfile:
Use the above procedure to create the correct logfile. Start the program and click Select Log file, browse to the logfile and click Open. Then click Select Destination file and browse to a folder, enter a filename without extention and press Save. Review the settings for sorting column and sort direction and click on the Go button to start parsing the selected file. When the mainlog displays finish parsing log file you have the ability to view the log file and the CSV file in the TABs. The files are already saved. If you want to re-sort the output, change the settings, click apply and click the re-sort button. The changes will be saved to the output files.

Settings
Using the settings screen you have a lot of options to turn on and of.

Setting name | What it does?
Sort by item | Select the item to sort the information by, default is Size.
Sort direction | Select Ascending or Descending
Debug mode | Change this according to you wishes.
CSV Seperator | Choose from the list or enter a single character yourself.
Decimal Seperator | Choose for the dot or the comma.
CSV Header | Choose whether you want to have a header/footer or no info at all in the CSV file.
Top items | Allows you to export a top x many items, for instance the top 10 largest mailboxes
Above items | Allows you to export all mailboxes with 100MB or more, or more then 1000 inbox items. (Not available on all columns) Will be automaticaly disabled if not supported.
Column settings | Select the information you want in a certain column. Also select or deselect if a column is included in either the HTML or CSV file.
Commandline | This line represents the current settings, use this line to copy/paste it to you batch files or other scripts.
Apply button | Only applies the settings, it does not save them. They will be lost when you exit the program.
Defaults | Put all settings back to default.
Save settings | Applies and saves the settings.

Commandline version:
All three switches are mandatory. Also you cannot change the order of the switches.

C:\>GWMBSIZE32.EXE /IN:<input filename> /OUT:<output filename> /OPTIONS:ABCDEF

<input filename> : Enter the complete filename and path to the logfile.
<output filename>: Enter the complete filename and path to the output files, no extention needed.
ABCDE: These are the parameters for the settings where:

A=0, sort by username
A=1, sort by fullname
A=2, sort by inbox
A=3, sort by outbox
A=4, sort by wastebin
A=5, sort by size
A=6, sort by UID

B=0, sort ascending
B=1, sort descending

C=1, debug mode: Disk
C=3, debug mode: Off
Screen debug not possible in commandline mode.

D=0, CSV Header
D=1, CSV Footer
D=2, CSV Header/Footer disabled

E=@ CSV Seperator, use one regular character only

F=. (dot) Decimal seperator, use the . for Europe and the , for the USA.

For example:
GWMBSIZE32.EXE /IN:C:\dummy.log /OUT:C:\Temp\result /OPTIONS:0110@.

This example will read the c:\dummy.log file, create the c:\temp\result.csv and c:\temp\result.mht with sorting descending by username, debug to disk, the @ sign for CSV seperation and the dot for decimal seperator in the MHT file, also a CSV header is added with the postoffice name, processing date etc.

Tip: Run the GUI version, make all settings using the Settings tab, hit apply and the commandline is displayed in the designated box for copy/pasting.

Optional switches
C:\>GWMBSIZE32.EXE /IN:<input filename> /OUT:<output filename> /OPTIONS:ABCDEF /COLUMN:0123456789,HTML:1111111111,CSV:1111111111 /TOP:5,ABOVE:6
The /COLUMN and /TOP:x,ABOVE switches are optional.
/COLUMN:ABCDEFGHIJ,HTML:1111111111,CSV:1111111111
Where:

Letter | Represents column | Value | Represents, by default
A | Column 1 | Value 0 - 9 | 0= Username
B | Column 2 | Value 0 - 9 | 1= Fullname
C | Column 3 | Value 0 - 9 | 2= Size
D | Column 4 | Value 0 - 9 | 3= Inbox
E | Column 5 | Value 0 - 9 | 4= Outbox
F | Column 6 | Value 0 - 9 | 5= Wastebin
G | Column 7 | Value 0 - 9 | 6= Sizelimit
H | Column 8 | Value 0 - 9 | 7= Treshold
I | Column 9 | Value 0 - 9 | 8= Exceeded
J | Column 10 | Value 0 - 9 | 9= UID

Value | Represents
0 | Username
1 | Fullname
2 | Size
3 | Inbox
4 | Outbox
5 | Wastebin
6 | Sizelimit
7 | Treshold
8 | Exceeded
9 | UID

the ,HTML:1111111111,CSV:1111111111 part allows you to enable or disable certain columns. Change any 1 to a 0 to exclude the column and change it back to a 1 to include the column. Make sure you always enter 10 zero's or one's or a combination.
The /TOP:5,ABOVE:6 optional parameters allows to set the Top items, or the Above items settings from the GUI version. Change it accordingly, put it to zero to disable.

FAQ

Q1: What is GWMBSize ?
A1: GWMBSize stands for GroupWise MailBox Size. This utility allows you to interpret the GWCheck log file for you and create a nice MHT report, and a CSV file. It supports Groupwise 5.5 and above.

Q2: How much does GWMBSize cost?
A2: Nothing, it absolutely free.

Q3: Is this software supported bij Novell?
A3: No, it is not, it's just provided by them on their Cool Tools website.

Q4: The values reported in the MHT or CSV file are incorrect is that GWMBSize's fault?
A4: Most likely not, because GWMBSize does not create the figures, it simply reads them from the log file, always check if the values are different then the ones in the log file. Is they are the same, don't blame GWMBSize for unwanted reports. If the values are different please send me an email, it must be a bug.

Q5: Does GWMBSize support gwcheck foreign languages?
A5: No it doesn't, currently it only supports the English gwcheck files. (It will be implemented if I receive enough foreign gwcheck files)

Q6:  What if my log file does not process?
A6: Please read the Contact section of the manual or website how to contact me for questions, bug reports etc.

Knows Bugs & Issues

The Apply, Save settings button's do not always work correctly
No I/O error detection

Personal Wish list

Add print buttons for HTML and CSV screens
Perfect I/O error detection
Multi language support, please send me logfiles in foreign languages of all version of Groupwise 5.5 and above. See contact section for more information.

Revision History

0.3.2  Beta

Fixed, support for French logfiles (5.5 version, thanks to a nice Frenchmen who sent me his logs)

Added, path to postoffice in HTML report.

0.3.1 Beta

Added: Experimental support for Groupwise 7 Beta

0.3 Beta

Fixed: Another >2 GByte problem fixed
Removed: Installer
Added: Print and Print preview buttons (html only)

0.2.1 Beta

Fixed: Support for >2 GByte mailboxes for 5.5 logs
Fixed: Internal routines, reduces risk for runtime errors
Added: French and German log file support
Added: filters 4 columns for 5.5 logs, they do not contain any information, also table width is changed

Compared to DOS version

Windows GUI for easier processing the log files
Compiles output to MHT instead of HTML & GIF files
Faster uses memory for processing instead of disk
Advanced option for creating dummy logfiles for testing and comparison
CSV header and footer information added
Support for long filenames

Contact

You can always contact me for questions, but before you do that make sure you fully read the manual. Also check the website (http://www.anykeyonline.nl or http://www.xs4all.nl/~spet/gwmbsize32) for the latest version or any other information.

If there is a problem please send me an email ([email-masked]) with the following information.

debug32.txt (this file is created every time you use the program, except when you turn this off.)
version of GWMBSize, Operating system, file system (FAT/NTFS/NetWare drive), Groupwise version.
Please add the logfile (zipped) to the email, I will handle it with full confidantiality.
screendump of the error message.

Contact me for suggestions.
If you have any suggestions for future versions of GWMBSize, don't hessitate to email them to me.

Disclaimer

This utility is distributed "as is" and without warranties as to performance, accuracy, or any other warranties whether expressed or implied. The author is not responsible for any costs or damages incurred, whether incidental or consequential, by the use or misuse of this utility.