We are shutting down the user-creation part of the website and we are deleting all the users. When I try to delete users, I’m told that some of the users have content and I would need to assign them to another user (or delete). How can I see which users have content and what content they have?

The easiest thing to would be to skip all that and just assign a specific user to all the posts directly in the database (back it up first of course)

Something along the lines of

UPDATE posts SET post_author = 1 WHERE post_author != 1

Then you can delete all the other users.

Though if you are going to leave the site up I would keep two. The one with all the posts assigned to them with minimal rights and a separate admin user.

​

And since you are in the database already you can go ahead and delete all the users without all that box checking

It should be something like this

DELETE FROM users WHERE ID NOT IN (1, 2)

DELETE FROM usermeta WHERE user_id NOT IN (1, 2)