EmailLists

CSE email list of all-but-one (for PhD and Lic gifts)

Some years ago, Guilhem wrote a nice tutorial how to query Chalmers LDAP server for all email addresses in our department, which is routinely handy for reaching every CSE employee but one (mostly when emailing about graduation gifts). Unfortunately, Guilhem's original query no longer seems to work, so hopefully people will keep this page updated to save other people some time. :)

The easy way (aka the Outlook alternative)

Add the mailing list you want to the recipients (e.g. CSE Collection list),
Expand (the plus button on the left of the mailing list) until you find the person you want to exclude,
Delete that person from the recipients

The hard way (aka fun with LDAP)

Guilhem's original query:

ldapsearch -QLLLH ldap://ldap.chalmers.se -s base -b cn=cse-org-alla,ou=groups,dc=chalmers,dc=se memberUid

Currently working query (simply uses the divisions as search string, instead of CSE):

Perhaps this can be done easier, but I could not find a CSE container like cse-org-alla anymore. Maybe a more LDAP-savvy person can find it.

You can use the following to get an outlook-friendly formatted list:

ldapsearch -x -LLLH ldap://ldap.chalmers.se "(|(ou=formella metoder)(ou=Informationssäkerhet)(ou=Datavetenskap)(ou=Software Engineering)(ou=Datorteknik)(ou=Nätverk och system)(ou=Programvaruteknik)(ou=Administration DoIT))" | grep mail: | cut -d' ' -f 2 > CSE-current-email-list.txt; for line in $(cat CSE-current-email-list.txt); do echo -n $line\;; done; rm CSE-current-email-list.txt

This probably requires a working kerberos ticket (you could run it on remote11 if you don't have kerberos set up).

Finally: Don't forget to remove the person you want to exclude, once you have the list! ;)