000028982 - How to inactivate/disable all DDE rules and actions for an RSA Archer Module

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support on Jul 2, 2019
Version 5Show Document
  • View in full screen mode

Article Content

Article Number000028982
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x and 6.x
IssueThis article explains how to inactivate all DDE rules (events) in a specific application using a SQL query.

You would only utilize these scripts for troubleshooting or testing purposes.

 

These SQL commands are intended for troubleshooting and non-prod environments.


 

As always, perform a SQL backup in case a SQL restore is required.


 

Follow the steps below at your own risk!


 

As documented below, different major versions of RSA Archer require different scripts.  Be sure to use the correct script for your deployment.

Resolution

For RSA Archer 6.0 and above



declare @moduleName nvarchar(max);
set @moduleName='Recovery Tasks' -- Insert Module name here
declare @levelId int;
declare @moduleId int;
set @moduleId=(select module_id
from tblModuleTranslation where module_name=@moduleName)
set @levelId=(select level_id
from tblLevel where module_id=@moduleId)
update er
set event_rule_status=0
from tblEventRule er join tblivlayoutModule lm on er.layout_module_id = lm.layout_module_id where lm.level_id=@levelId
update ea
set event_action_status=0
from tblEventAction ea join tblIVLayoutModule lm on ea.layout_module_id = lm.layout_module_id
where level_id=@levelId --
set the status to 0 for OFF --
set the status to 1 for ON  


For RSA Archer 5.5 SP2 and above, ensuring that this is a version less than 6.x



declare @moduleName nvarchar(max);
set @moduleName='Recovery Tasks' ----insert module name ----
declare @levelId int;
declare @moduleId int;
set @moduleId=(select module_id from tblModuleTranslation where module_name=@moduleName) set @levelId=(select level_id from tblLevel where module_id=@moduleId)
update tblEventRule set event_rule_status=0 where level_id=@levelId
update tblEventAction set event_action_status=0 where level_id=@levelId
----set status = 1 to turn them on
----set status = 0 to turn them off

Attachments

    Outcomes