I think the accounts you have created is still exists in the TFS that's why it is listing all the users. Just go to TFSWorkItemTracking database in the database tier and look for the table called ADObjects inside this table you will be having all the details about the existing users. From here safely delete the unwanted users....but i would say this is the bad practice to do that ...sometimes this is way to do....

I think i have answer your question.

Hi Paso,

The warehouse keeps history of all users, even after they have been deleted from TFS. Like Kathirvel said, even though you deleted the local users from the server and TFS groups, these users still exist in the warehouse, and i think other parts of TFS to keep track of history.

You mention seeing all users when filtering on Assigned To. Is this on your own reports, or on reports that ship in the box, like "Work Items" ? In the "Work Items" report, only the users that have ever done anything with work items should be appearing as values in teh Assigned To parameter. This is because we crafted a query to do this. You can open up the Work Items report and see if you want to do something similar in your own reports.

If the local account and the domain account had the same name (for example, "Paso"), then "Paso" will appear twice in the person table - but one is for the local account, and the other for the domain account. Your understanding of this seems good.

I would not recommend deleting the users from the database tables.

mauli