Show deleted users in User Information List programmatically

Question

I am working with retrieving user info programmatically in WSS 3.0. I understand that users are stored in each Site Collection's User Information List. Deleted users are not visible in the User Information List on the people.aspx page. However, if you delete a user and add them again, they will take on the same ID as they had before. Where are these records stored?

Answer 1

You can pull deleted users from the SiteUserInfoList like this:

SPList myList = SPContext.Current.Web.SiteUserInfoList;

SPQuery query = new SPQuery { Query = "<Where><Eq><FieldRef Name='Deleted' /><Value Type='Boolean'>1</Value></Eq></Where>"};
SPListItemCollection entries = myList.GetItems(query);
if (entries == null || entries.Count == 0)
    throw new Exception("Users Not Found!");

You can query several other user properties as well. Details can be found at another of my answers here: http://sharepoint.stackexchange.com/a/30858/2881

Answer 2

In the SharePoint Content Database, under the Table "UserInfo". It is not supported to write the database directly.