Email All Users?

Wednesday, August 31, 2011 4:32:43 PM
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 5:10:13 PM
Avatar
re: julierob on Wednesday, August 31, 2011 4:32:43 PM
Not currently I'm afraid.
Tuesday, December 4, 2012 9:25:15 PM
Avatar
re: julierob on Wednesday, August 31, 2011 4:32:43 PM
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);
Statistics
  • Started: Wednesday, August 31, 2011 4:32:43 PM
  • Last Reply: Tuesday, December 4, 2012 9:25:15 PM
  • Replies: 2
  • Views: 946