on Jun 14, 2016Article Content
| Article Number | 000029220 |
| Applies To | RSA Product Set: Archer RSA Version/Condition: 5.5 SP1 Platform: Windows |
| Issue | A 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. |