Export all email address from Groupwise 2012

[Jesus]

I am dealing with a Groupwise 2012 system that uses multiple domains and a few different email address standards.  Not all uses use all the domains, and some users have custom addresses.

In order to tidy this up I want to extract a full list of all email addresses. 

I tried ldapsearch as follows:

# ldapsearch -D cn=admin,ou=perth,o=xxx -W -Z -LLL -h localhost -b o=xxx "(|(objectClass=inetOrgPerson)(objectClass=person))" sn givenname mail

But that only lists the primary email address.

So I exported the Groupwise address book to CSV, but again that only listed the primary email address.

Are there any other options that anyone can suggest?

Thanks

[Rimser]

So you are accessing GroupWise administration with ConsoleOne.There is a utility which is based on good old nwadmin. This utility can export and import a lot. Search for gwport32.exe and use it!

My brains are weak - did ConsoleOne contain a feature to go for all "Gateway Aliases"?

[laurabuckley]

@Jesus 

Disclaimer --> it's been years since I worked on GroupWise 2012.

If you have a system with multiple iDomains, the user will still have a default one set at the GWIA/Domain/PostOffice/User level --> that iDomain will be their primary email address.  That is what they will be "sending" from.  All other "available" email addresses is what they could possibly receive on.  Same with a custom email address... that will be their primary email address.  So the only thing that I see as being relevant in any system clean up is identifying what each user's primary email address is as that is what is really being used.

So, I'm not sure why you would want to identify anything further than the primary email address.

Cheers,

Laura

[mrosen]

@laurabuckley , actually, there is a potential reason: The users can be restricted to just one possible email address/domain vs all allowed.

And of course, in a system with multiple POs, each PO may have different settings.

[laurabuckley]

@mrosen  As far as I am aware, at the end of the day, the user only has one "Preferred Email Address" and that is used as their primary email address.

[mrosen]

@laurabuckley 
Yes, but he wants a list of *all* allowed email Adresses of the users, and that can vary.

BTW: eDir *should* have alist of all possible addresses, not just the primary. The emailaddress attribute is multivalued, and Groupwise 2012 *should* update it with all allowed ones (but that's not guaranteed).

[booktrunk]

I'm struggling with the same issue.

the groupwise api seems to be the way to go. There is an option to get all attributes for a user.

Here is a link to an api guide. https://www.novell.com/documentation/groupwise18/gwsdk_admin_rest_api/data/b15roopj.html

But i just don't have the time to dedicate to work out how the heck to use the json stuff i've logged into the api admin page not sure if it's literally type that in within it.

GET https://localhost:9710/gwadmin-service/diagnostics/object/USER.testDom1.testPO1.testUser1

[Jesus]

@Rimser 

Google revealed this utility as far back as 2002!

I also just realised that it is a .exe so I'd need to install ConsoleOne on Windows.  This site has Groupwise running on linux.

A TID here from 2003 gives instructions on how to use it.  I'll delve further with it if necessary.

[Jesus]

---

@laurabuckley wrote:

[...] So the only thing that I see as being relevant in any system clean up is identifying what each user's primary email address is as that is what is really being used.

So, I'm not sure why you would want to identify anything further than the primary email address.

Cheers,

Laura

---

@laurabuckley 

The email address list will be used as part of anti-spam measures, so that Groupwise won't even see email that doesn't have a valid email address, as opposed to just valid domains.  Prior to this we want to review all the email addresses, including nicknames, and distribution lists, and see what can be removed.

--

Gordon

[Jesus · Accepted solution]

---

@mrosen wrote:

BTW: eDir *should* have alist of all possible addresses, not just the primary. The emailaddress attribute is multivalued, and Groupwise 2012 *should* update it with all allowed ones (but that's not guaranteed).

---

As you wrote "multivalued" you got me revisiting my ldapsearch from my OP.  It definitely only shows the primary email address.  But looking further through the output, nicknames are included as well - so there is the proof of multivalued....  Just not the user's additional email addresses of the other three internet domains or permutations of Allowed Address Formats.

After checking Groupwise System I see there is an option that looks useful!!...

Groupwise System Operations - Internet Addressing - Publish to eDirectory tab

Ours is set to "Publish the Preferred Email address only"

the option I need is -  For each Internet Domain: "Publish all allowed addresses"  🎉 🍺

"Publish Nickname addresses" is already enabled

The only thing missing may be the distribution group email addresses, of which there aren't many.

[Jesus]

---

@Jesus wrote:

---

the option I need is -  For each Internet Domain: "Publish all allowed addresses"  🎉 🍺

 This updated eDir immediately and now ALL EMAIL ADDRESSES are listed in ConsoleOne AND ldapsearch!

I'll just work out the objectClass name for Distribution lists and the list will be complete.

[laurabuckley]

@Jesus Hi Gordon --> thank you for the explaination.  Now I understand.