Thread

Skip Navigation LinksForums > SpiraTeam Forums > SpiraTeam Issues & Questi... > Email All Users?

Email All Users? RSS Feed

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
Adam SAdam S
re: Julie Robertson on Wednesday, August 31, 2011
Wednesday, September 7, 2011
Not currently I'm afraid.
Dennis WeisgramDennis Weisgram
re: Julie Robertson on Wednesday, August 31, 2011
Tuesday, December 4, 2012
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);
Tagged
Statistics
  • Started: 8/31/2011
  • Last Reply: 12/4/2012
  • Replies: 2
  • Views: 778
Powered by KronoDesk v1.1.0.15 | © Copyright Inflectra Corporation 2011-2016 | Licensed to Inflectra Corporation.