Simple display of usernames and contact details of project members

[vincent.mcintyre+trac@…]

When starting to use trac I wanted to get a list of the developer login names and their email addresses, so I could tell whether the reason they were not getting ticket emails was because they hadn't set this up with '/settings', or some other reason.

I ended up writing a custom report, like this (debian, trac 0.10.3-1etch2):

SELECT a.value AS developer, b.value AS email
FROM  session_attribute a,  session_attribute b
WHERE a.sid = b.sid and a.name = 'name' and b.name='email'
ORDER BY a.value

which is a bit yucky as it exposes details of the session_attribute table. Also it does not list people who have never visited '/settings' yet - it would be nicer to pull the names from the permission table but my sql-foo isn't up to that yet.

I searched for a macro or plugin that would do this, in vain. It would be useful to have this functionality available as a macro.

There are some privacy implications with exposing email addresses like this. Possibly the feature could be built into the admin pages, ie TRAC_ADMIN would be required to view the information.

Not sure what the component should be here, please adjust as you think fit.

[Alec Thomas]

​AccountManagerPlugin has this facility already.

Trac does not have awareness of all possible users due to the way it uses HTTP authentication, so this won't go into core (unless AccountManager itself does).