Wikis - Page

*Easy* way to report on GroupWise mailbox sizes

0 Likes

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.

Labels:

How To-Best Practice
Comment List
Parents
  • 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.
  • *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 ))
Comment
  • *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 ))
Children
No Data
Related
Recommended