Best way to see all records assigned to a user?

Question

Hi peep&acute;s Ok, you know how Sugar asks Would you like to reassign all of this user's records? when a user is made inactive. Well, what is the best way, beforehand, to find out what records are in question (and if there are any at all!)? An advanced query maybe? TIA, KGM

Kristjan Geir Mathiesen · Accepted Answer

Hi Kristjan Geir Mathiesen , Are you sure that you are entering the user ID in the query? I apologize for any confusion. To find the user ID, go to Administration > Users > Select the requested username. The ID will be present near the end of the URL, after the = sign. If you are hosted on-site, then you can check the users table to find the ID in the corresponding row. Please note the above example does not include data from custom fields, as it is only meant to give an idea of what records are assigned to a given user. You may also need a more complex query if you want to retrieve all of the requested data in a single report. The easiest method would be to edit the existing query according to which module you want to check, swapping "accounts" out with the name of the given module, e.g.: SELECT * FROM contacts WHERE assigned_user_id = 'user_id_here' AND deleted = '0'; Best wishes, Nathaniel