*Easy* way to report on GroupWise mailbox sizes


One of my more popular Cool Solutions tools has been GWAttachmentStats. The main purpose of this tool was to be able to get a sort-able list of my GroupWise mailbox sizes. This required running a specific report which creates a poorly formatted log file, then running GWAttachmentStats to clean it up and put it in a format that can be imported into a spreadsheet so that you can sort on the columns.

I just discovered a much easier way to do this and makes the GWCheck process obsolete!

It's this easy:

  1. In Console One, select your GroupWise System object

  • Select the Users from the object drop-down list

  • From the View menu, select Edit Columns (whoa! how'd I miss this all these years?!)

  • Add columns to this view, including Current Mailbox Size (MB) and look at all these other great fields to report on!:

  • Too bad that the Sort drop-down list next to Users doesn't list these newly-added columns as sortable options. So...

  • Select all user objects you see on a given page, then press Ctrl C to copy the selection into your clipboard and paste into a spreadsheet! Sort to your hearts content!

Unfortunately, you can't do a "Select All", C1 will only select the objects that you can actually see in the right pane so you have to repeat the Select/Copy/Paste a page at a time until you've pasted all the users you want in your report.

I especially like being able to see/sort on the Last Client Login Time and client type.

How cOOl is that?!

GWAttachmentStats provides other information about number of messages, and offers some details on the attachments so it's still a relevant tool, but for quick reporting/viewing of mailbox sizes (and other available columns in the C1 view), this is a much better/quicker/easier way.


How To-Best Practice
Comment List
  •   in reply to MigrationDeletedUser
    *Totally* agreed. This is why I submitted a bug report. In fact I've got the following "requests/bug reports" submitted. Perhaps you could do the same to arise awareness:
    - ConsoleOne - give us the ability to do a select all and select all objects in the pane, not just what you can see
    - ConsoleOne - give us the ability to click on a column to sort by (like one intuitively would assume you can do, like with a spreadsheet)
    - Groupwise/ConsoleOne - if you can't make it that we can sort by columns by clicking on the column, give us the selected columns in the sort drop-down box to select the column to sort by
    - Groupwise - Change GWCheck to provide some delimited format report that can be brought into a spreadsheet. The text-based gwcheck.log is too difficult to use for meaningful reporting without the use of a third-party utility (like GWAttachmentStats ( www.novell.com/.../14448.html ))
    At full screen I can get 42 users to cut and paste.
    With several thousand users to report on it would take hundreds of screens to get them all.
    You have to be careful too because when you page down it puts the last user on the prior screen on top so you have to un-select that one or you will duplicate the top one.
    That makes this technique unuseable for me.
  •   in reply to MigrationDeletedUser
    You can update your totals by selecting your Groupwise System object in Console One, select the Post Offices from the Object drop-down list, select your POs (that you want to update), go to the Tools / Groupwise Utilities / Mailbox-Library Maintenance, and select Audit report from the Action drop-down menu. This should give you updated information after the GWCheck is complete. For good measure, do a Refresh (from the View menu) to update your view.
  •   in reply to MigrationDeletedUser
    Sure 'nough - it is just GW8. I too don't have these fields in the GW7 PO. No wonder I missed it before. ;-)
  •   in reply to MigrationDeletedUser
    Tried this and the information does not look to be real time or anywhere near it. My mailbox size reports 50% of what it actually is, and my last login time was 3 months ago. However, I log into the GroupWise client everyday. On GW 8.01 HP both client and POA.
    Is this functionality something that's new w/ GW8? I can see values for current mailbox size and last client login time, but only for users on GW8 PO's.