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
Attachments
Article Info
Last Updated: 10/27/2014
Article ID: KB92
# Views: 834
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.