Removing past users from the SuiteCRM

[rsp]

All,

We want to remove the ex employees from the SuiteCRM, but these employees should not be associated with any records in the CRM. ( like leads, opportunity, account).

How to find those list of ex employees?

[pgr]

It’s a bit of work, but using phpMyAdmin you can find an id across any table, I describe it here

DB Tables emails and emails_text safe to empty

You can delete from the DB but you need to be careful not to leave any “hanging threads”. Start by understanding the relationships between the tables. This is how I’d do it. I would go in emails_text table and choose a row that I want to delete. Take a note of the row’s id field. Now, in phpMyAdmin, choose the database (not a single table, select the whole database) and choose Search from the top menu. type the id in the search box in the box with all the table names, select all of them (cl…

This way of searching is very useful to understand SuiteCRM

[rsp]

Thanks a lot

Method : Using phpMyAdmin’s “Search” Feature

1. Open phpMyAdmin.

2. Select your database (SuiteCRM) from the left sidebar.

3. Click on the “Search” tab in the top menu (not the one in the structure or table view).

4. In the “Words or values to search for” field, enter the string you want to search (e.g., 'apple').

5. Under “Inside tables”, check the box “Select all” (or manually pick the tables you want).

6. Optionally select “Find” → “at least one of the words”, or change the match type if needed.

7. Click Go.

It will then return all matching entries across all selected tables and fields.