We are planning on adding the ability to email the entire user list of the system and/or the membership of a specific project through the Spira UI, but for now this article explains how you can use a custom report to get a list of all the email addresses of the users of a Spira installation:
The steps are:
- Create a new custom report in Administration. Make sure Excel is listed as one of the output formats
- Add a new custom section to the report
- In this custom section, add the following ESQL query:
select R.EMAIL_ADDRESS from SpiraTestEntities.R_Users as R where R.IS_ACTIVE = True
- Go to Reports
- Choose your new report
- Choose MS-Excel as the output format
- Click on the button to generate the report
- You now have an Excel sheet with all the email addresses