Created By  inflectra.adam Monday, October 27, 2014
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:

  1. Create a new custom report in Administration. Make sure Excel is listed as one of the output formats
  2. Add a new custom section to the report
  3. In this custom section, add the following ESQL query:

    select R.EMAIL_ADDRESS from SpiraTestEntities.R_Users as R where R.IS_ACTIVE = True

  4. Go to Reports
  5. Choose your new report
  6. Choose MS-Excel as the output format
  7. Click on the button to generate the report
  8. You now have an Excel sheet with all the email addresses
Article Info
  • Last Updated: 10/27/2014
  • Article ID: KB92
  • Views: 2357