1229063 - Dump of email addresses as visible in Phonebook

Status: RESOLVED FIXED

(Infrastructure & Operations :: Infrastructure: LDAP, task)

Description

[Mike Hoye [:mhoye]]

In bug 1196895 I got a dump of emails, thinking that I was getting all the email addresses in Phonebook.  I wasn't clear in my request, though, that I needed all of the emails as well as everyone's various bugmail addresses (in particular whatever they need on github), so my numbers have been a ways off for the Firefox team, and crazy wrong for the FxOS team. 

I've rescraped Phonebook manually, but if there's a better way to do that, I'm requesting it here - can I get a flat list of all the email addresses and bugmail addresses in Phonebook? I don't need names or anything, ideally just an address per line.

Thanks.

Comment 1

[Justin Dow [:jabba]]

I've e-mailed a new list. Here's the query I used:

ldapsearch -x -D "mail=[e-mail],o=com,dc=mozilla" -W -h ldap.db.scl3.mozilla.com -b "dc=mozilla" '(&(!(employeeType=DISABLED))(objectClass=mozComPerson))' mail bugzillaEmail |grep -v "^\#" |grep -v "^dn:" | sed s/^mail:\ //g |sed s/^bugzillaEmail:\ //g > mail.txt

and then I edited the resulting file and removed blank lines and the comments that ldapsearch left at the bottom.

It should be possible for you to run this same query yourself, if on the VPN.

Comment 2

[Mike Hoye [:mhoye]]

Nice, thanks.