000033889 - How to identify RSA Archer 5.5.4.1 Applications or Questionnaires that have Notifications using the One Email or Separate Emails option

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

Article Content

Article Number000033889
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5.4.1
 
IssueHow to identify Applications or Questionnaires that have Notifications using the One Email or Separate Emails option.
 
User-added image
Resolution

Execute the following SQL queries against the Archer Instance database.


Identify Applications and Questionnaires where the Notification is using the One Email option:


SELECT mt.module_name, template_name, 'One Email'
FROM tblNotificationTemplate nt
JOIN tblLevel l ON l.level_id = nt.level_id
JOIN tblModule m ON l.module_id = m.module_id
JOIN tblModuleTranslation mt ON mt.module_id = m.module_id
WHERE email_recipient_option_id = 2
ORDER BY mt.module_name, template_name

Sample results:


User-added image


Identify Applications and Questionnaires where the Notification is using the Separate Emails option:


SELECT mt.module_name, template_name, 'Separate'
FROM tblNotificationTemplate nt
JOIN tblLevel l ON l.level_id = nt.level_id
JOIN tblModule m ON l.module_id = m.module_id
JOIN tblModuleTranslation mt ON mt.module_id = m.module_id
WHERE email_recipient_option_id = 1
ORDER BY mt.module_name, template_name

Attachments

    Outcomes