Inflectra Customer Forums: Email All Users? (Thread)

Email All Users?

Julie Robertson (jrobertson@aperio.com) — Wed, 31 Aug 2011 16:32:43 -0400

Is there an easy method in SpiraTeam to email all Active Users (e.g. to send global announcement regarding planned downtime)? Note : My system already has email notifications; I'm just curious whether ST provides a global announcement function I don't immediately see.

Not currently I'm afraid.

David J (adam.sandman+support@inflectra.com) — Wed, 07 Sep 2011 17:10:13 -0400

Not currently I'm afraid.

If you have access to the database, you can query active users with these: --This query looks for ac

Dennis Weisgram (dmweisgram@aol.com) — Tue, 04 Dec 2012 21:25:15 -0500

If you have access to the database, you can query active users with these: --This query looks for active users with active logins across projects SELECT FIRST_NAME, LAST_NAME, EMAIL_ADDRESS FROM TST_USER WHERE LAST_LOGIN_DATE IS not NULL and ACTIVE_YN = 'Y'; --This query looks for active users with acitve logins for a select project(s) SELECT U.FIRST_NAME, U.LAST_NAME, U.EMAIL_ADDRESS FROM TST_USER U ,TST_PROJECT_USER PU WHERE PU.USER_ID = U.USER_ID AND U.LAST_LOGIN_DATE IS not NULL AND U.ACTIVE_YN = 'Y' AND PU.PROJECT_ID IN(