Knowledge Base Article

Home Page > Knowledge Base > Spira Platform

Home Page > Knowledge Base > Spira Platform > SpiraPlan

Home Page > Knowledge Base > Spira Platform > SpiraTeam

Home Page > Knowledge Base > Spira Platform > SpiraTest

Article How to email everyone in the system

by Adam S on 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: 861
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.