Skip Navigation LinksHome Page > Forums > SpiraTeam Forums > SpiraTeam Issues & Qu... > Email All Users?

Email All Users?

Wednesday, August 31, 2011

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.

2 Replies

Wednesday, September 7, 2011

inflectra.david

re: julierob Wednesday, August 31, 2011

Not currently I'm afraid.

Tuesday, December 4, 2012

jackswastedlife

re: julierob Wednesday, August 31, 2011

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(<ENTER THE PROJECT IDS HERE);

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885

Statistics

Started: Wednesday, August 31, 2011
Last Reply: Tuesday, December 4, 2012
Replies: 2
Views: 3019

Email All Users?

Spira Helps You Deliver Quality Software, Faster and With Lower Risk

Edit Thread

Edit Message

Search Results