Notify Service User Expiration

Alerts the Hosting team when the password for the eCommerce site and/or web services is nearing expiration. This notification has been implemented so that administrators can change the passwords and update configuration files to keep the sites operational.

 

Event Stored Procedure Name:  usp_NOTIFY_SERVICE_USER_PASSWORD_EXPIRATION

Chronicle Table Name: None

Trigger on Table

None

Business Change Options

The procedure is run to find out if the out if the eCommerce site and/or web services User account password is about to expire.  If the Password Reminder Period is currently set to “0” days this process will set it to “7” days, to give a fair warning.

 

There are four Application Parameters in the APP subsystem that are required for this notification.

·            PARAMETER_NAME='PASSWORD_EXPIRATION_PERIOD':  The procedure checks to see if the PSM_SERVICE_ACCT user’s password is about to expire after this period (days) is passed since the last password change.

·            PARAMETER_NAME='PASSWORD_REMINDER_PERIOD':  If today is equal to or less than the number of days for a reminder, this notification will fire.

·            PARAMETER_NAME='PSM_SERVICE_ACCT_PREFIX':  (new) This is a special name assigned to the Personify360 user that holds the eCommerce site connection password.

·            PARAMETER_NAME='DEFAULT_EMAIL_SERVICE_ACCT':  (new) This is the email account where this alert email is sent.

Sample Message Template

One or more service account passwords are expiring or have expired.

User Id

Password Expiration Date

Expired

##USER_ID##

##EXPIRATION_DATE##

##EXPIRED##

Please check the list above and take the appropriate action to reset these service account passwords.
In case of any concern please contact System Administrator.