000029220 - A SQL script to inactivate a large amount of users in RSA Archer 5.5

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

Article Content

Article Number000029220
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.5 SP1
Platform: Windows
 
IssueA script is needed to inactivate a large number of users.
Resolution

Always backup database prior to performing SQL script changes.



Test in lower environments first.



Use this script at your own risk.



The set users to inactive.sql script is attached below. It also has exceptions. The exception users names need to be added in the IN statement. However, it is always recommended to try other options prior to direct database script usage. The following link has a tool that utilizes the API to do this as well.  See the document in the RSA Archer Customer/Partner Community on Bulk User Manager - a simple tool using the Archer API to change a user's account status in bulk.

Attachments

Outcomes