GWReport is a simple tool for exporting some user information from Groupwise to an excel-file or csv-file.
At the moment the program can export the following attributes:
| attribute | minimal GW versie | | | Account ID | | | | Address Format | 7.0sp3 | | | Allowed Address Format | 7.0sp3 | | | Department | | | | Description | | | | Disable Login | 7.0sp3 | | | Distinguished Name | | | | External | | | | External Entity | | | | Fax Number | | | | Gateway Access | | | | Given Name | | | | Internet Domain Name | 7.0sp3 | | | Internet Domain Name Exclusive | 7.0sp3 | | | Last Client Type | 8.0 | *1 | | Last Modified By | | | | Ldap Authentication | 7.0sp3 | | | Mailbox Expiration Date | | | | Mailbox ID | | | | Mailbox Last Login Date | 8.0 | *1 | | Mailbox Size | 8.0 | *1 | | Net ID | | | | Phone Number | | | | Preferred Email ID | 7.0sp1 | | | Surname | | | | Title | | | | Visibility | | | *1 At the moment the program skips these values. This will probably be fixed in GW80SP2.
The Program
The first time the program is started, it will show a directory selection window (select a file in the domain directory e.g. domain.db).
The program will store the directory for subsequent runs.
 | Select another groupwise system. |
Sample
 
 | Select attributes to export. |
Deafult the attributes Mailbox Size, Disable Login, Mailbox Expiration Date and Preferred Email ID are selected.
| Red cross | clear selection | | Left/right arrow | add/remove selected attribute | | Up/Down arrow | change sort order | | Green Check | close window and change the query attributes | | Red cross at the top | cancel changes. |
 | Query |
There are three options at the left, Domains, PostOffices and Users.
Domains: export all domains (all users in the system) or a selection of domains. ( click on + sign and select domain(s) to export.
PostOffices: export all postoffices (all users in the system) or a selection of postoffices.
Users: exports all users or a selection of users The program will check all 3 options, but will export a user only onces. In most cases one of the options is used at any given time. Select the magnifying glass to do the actual query.
 | Export the data to Excel or a CSV. |
|
