How to Remove Unneeded or Outdated User Names from the Feed Information on the Data Feed General Tab in Archer

[KB-Sync1]

Article Number

000014720

Applies To

Product(s): Archer
Version(s): All Versions
Primary Deployment: On Premises/AWS Hosted/AWS SaaS

---

Description

There are many User Names listed in the Data Feed Information section on the General tab, but there is no way to remove these user accounts from Manage Users, as they do not show up there. These are backend accounts that are used by Archer.

0EMVM000005pAiP.jpg

Cause

The User Name list will grow as Data Feeds are added/updated/deleted.

Resolution

For normal user account maintenance, DO NOT use the steps below. Instead, go to Manage Users in Archer, use API, or use the Bulk User Manager tool: https://www.archerirm.community/t5/platform-technical-tips-tricks/bulk-user-manager-a-simple-tool-using-the-archer-api-to-change-a/ba-p/559661.

For Data Feed user accounts ONLY do the following:

1. Logout of Archer entirely.
2. Get a list of Data Feed user accounts by running the following SQL query against the Instance Database:

   SELECT * FROM tblUser WHERE user_type_id = 4

3. Take note of the user_id you want to delete.
4. Perform a SQL Backup of the Archer Instance Database first, as these are delete SQL's.
5. Delete the Data Feed user account by running the following SQL commands ONE AT A TIME against the Instance Database after replacing XX with the user_id from Step 3:

   DELETE FROM Tbluserpasswordhistory where user_id = XX
   
   DELETE FROM tblXUsersRoles where user_id = XX
   
   DELETE FROM tblUser WHERE user_id = XX

6. You should receive confirmation of the deletions success. You can also rerun the SQL from Step 2 to verify.
7. Log in to Archer go to Data Feed Manager and you will see that the User Name has been deleted.

NOTE: Below is a list of the user types and their corresponding code:

1 = General User 
2 = Service Account 
3 = Sysadmin
4 = Datafeed Service 
5 = Migration User
6 = ACP