Return
-
Title
How to delete old user accounts from the database -
Description
How to delete old user accounts from the database so they are no longer seen in the Acting Users filter. -
Cause
Employees no longer with the company appear as active users in the Active Administrator Console | Auditing tab. -
Resolution
First, make sure you have a current backup of the Active Administrator database.
Within the SQL Management Studio run the queries below, but make sure that they are ONLY run against the Active Administrator database.
-
delete from tblalertlog where accountid = 'accountid of specific user'
-
delete from tblaccount where accountdisplayname = 'domainname\samaccountname'
NOTE: The information in the script(s) provided is known to work successfully; however, they have not been officially tested by Quest Software Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by Quest Software Support and Development.
Quest Software Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.
-