One GroupWise Link to rule them all?

Not quite, but a really useful link for getting a full list of your GroupWise users all in one place.

https://GWAdminNameorIP:9710/gwadmin-service/list/user.csv

That one link will give any admin ID (on GroupWise 2014 or later) more data than most of us can use, in the form of a CSV (comma-seperated values) file. When imported into your favourite spreadsheet (LibreOffice Calc for me) this currently spans out to column CE, but you can get exactly what we like with just a bit of effort. Any System|Domain|PostOffice Administrator can get that list, so this isn't for just any end user. Naturally, you will need to replace GWAdminNameorIP with the DNS name or IP address of one of your GroupWise servers with the GroupWise Admin agent running. This also assumes you are running on the default port of 9710, change if needed for your environment.

GroupWise 2014 introduced some amazing APIs and related hooks into the system, but initially they are all packaged as if we are all programmers and have root shell access to the servers. Buried in them we can quickly see that a lot of the data pulls are using cURL which is just a command line tool for getting or sending files using URLs (as per https://en.wikipedia.org/wiki/CURL ). Just taking the URLs out of those commands and plugging then into a web browser gets us lots of useful results.

I've found that we can get 5 different lists from a GroupWise system:

Domains, Users, Groups, Resources, and Nicknames using the following basic links.

https://GWAdminNameorIP:9710/gwadmin-service/list/domain.csv 
https://GWAdminNameorIP:9710/gwadmin-service/list/user.csv 
https://GWAdminNameorIP:9710/gwadmin-service/list/group.csv 
https://GWAdminNameorIP:9710/gwadmin-service/list/resource.csv 
https://GWAdminNameorIP:9710/gwadmin-service/list/nickname.csv 

As you will see, those give us more details than most of us need day to day, so to get a more usefully limited list, we just need to add to the end of any of those URLs is ?attrs= followed by a comma delimited list of the attributes we are looking for. We can see the available list in the top row from the full listings. Below are some of the links I use:

A list of all users with system type useful data:

 https://GWAdminNameorIP:9710/gwadmin-service/list/user.csv?attrs=name,postoffice,mailboxSizeMb,firstname,lastname,fid,syncNotFoundTime,lastClientLoginTime,timeCreated,timeLastMod,loginDisabled,mailboxLicenseType 

A list of identity details of all users:

 https://GWAdminNameorIP:9710/gwadmin-service/list/user.csv?attrs=name,postoffice,firstname,givenname,middleInitial,lastname,surname,telephoneNumber,MobilePhoneNumber,prefix,title,streetAddress,stateProvince,suffix,fid 

All nicknames with useful cross references:

 https://GWAdminNameorIP:9710/gwadmin-service/list/Nickname.csv?attrs=name,domain,postoffice,firstname,lastname,userName,fid 

Note that the User mailboxSizeMb and last login are not updated automatically but need a GWCheck Audit job run. It is easiest to just have that job set to run automatically, which is why it is a part of my standard set of GWChecks I setup at my clients

There is much more data in GroupWise beyond those 5 lists, but it becomes the realm of a bit of basic programming to get there. To get started, check out this CoolSolutions webinar.    And then refer to the GroupWise Documentation on the topic.