Article Content
Article Number | 000028982 |
Applies To | RSA Product Set: Archer RSA Version/Condition: 5.x and 6.x |
Issue | This 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 abovedeclare @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.xdeclare @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 |