Quick question. We have over a couple hundred different users from all departments in many states as well as overseas. I would like to send system update notifications to all users through EPDM but not sure how.
For example: I add or delete some variables from file cards or update the workflow. I want to send an alert to the users through the system that there were changes and describe the changes.
How do you handle system updates and notifying the various users?
Thanks.
Ryan
I have a group I created called PDM_X_EVERYONE that I have automatically add new users and contains the rest. Run this query and it will give a user email address listed that can be copied into the TO: address from an email application. Granted it's not automated, but it also gives the flexibilty for you to put together whatever type notification or message to follow.
Declare @users varchar(max)
Set @users = ''
Select @users = @users + Email + ';'
FROM Users INNER JOIN
GroupMembers ON Users.UserID = GroupMembers.UserID INNER JOIN
Groups ON GroupMembers.GroupID = Groups.GroupID
Where Groups.Groupname = 'PDM_X_EVERYONE' and Enabled = 1
Select @users