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, 2016•Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • Comment • 0
  • View in full screen mode

Article Content

Article Number000028982
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x and 6.x
IssueInactivate all DDE Rules (events) in a specific application using a SQL query.
Different versions of Archer require different scripts.
ResolutionUse this version for 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


Use this version for 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


Use this version for Archer versions LESS THAN 5.5 SP2 where there are no "...translation" tables in the DB structure.
declare @moduleName nvarchar(max);
set @moduleName='Issues' --insert module name
declare @levelId int;
declare @moduleId int;
set @moduleId=(select module_id from tblModule where module_name=@moduleName)
set @levelId=(select level_id from tblLevel where module_id=@moduleId)
update tblEventRule set event_rule_status=1 where level_id=@levelId
update tblEventAction set event_action_status=1 where level_id=@levelId
----set status = 1 to turn them on
----set status = 0 to turn them off


 

Attachments

    Outcomes