2 Replies Latest reply on Jan 7, 2013 5:36 PM by Jim Sculley

    System Update Notification

    Ryan Dietz

      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?






        • Re: System Update Notification
          Shawn Kelly

          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

          • Re: System Update Notification
            Jim Sculley

            I have a group of system control files (empty files with a .ctrl) extension that I move through a simple workflow for various types of files (templates, macros, etc).  If I need to change a drawing template, I first transition the corresponding control file (template.ctrl) to a 'Changes Pending' state.  When the changes to the actual template are complete, I move the control file to a new state and have a notification set up on the transition.


            Jim S.