000033246 - Update all RSA Archer Subscription Notifications to use updated content (post 5.5.4)

Document created by RSA Customer Support Employee on Jun 14, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 4Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000033246
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5.4
 
IssueAdministrations..Notifications..Manage Subscription Notifications
Need to run a script that changes all Subscriptions Notifications to Digest Content Published: Current Version Only option.
User-added image
This will force Archer to check that notifications still meet the criteria before being sent out.
ResolutionRun this:
UPDATE tblNotificationTemplate 
SET latest_content_version_filter=-1
WHERE interval_type_id=3 AND format_id=2

This changes only Subscription Notifications that have the option Daily, Weekly, Monthly, or Quarterly. It changes all Active and Inactive Notifications.
THIS UPDATES THE DATABASE. BE SURE TO BACKUP FIRST!

Attachments

    Outcomes