Title: users.php
Last modified: August 19, 2016

---

# users.php

 *  [legend38](https://wordpress.org/support/users/legend38/)
 * (@legend38)
 * [16 years ago](https://wordpress.org/support/topic/usersphp-1/)
 * I want to go into my phpmyadmin and run a query that will display the same information
   as users.php in wp-admin. Basically, I need a report that gives all my usernames,
   name of user, email, and role, and (if possible) which blog they are assigned
   to. I have multiple blogs on one install.
 * IE: jack.myblog.com, jill.myblog.com, etc etc.
 * Does anyone know the query to do this?

The topic ‘users.php’ is closed to new replies.

## Tags

 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)
 * [php](https://wordpress.org/support/topic-tag/php/)
 * [users](https://wordpress.org/support/topic-tag/users/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [legend38](https://wordpress.org/support/users/legend38/)
 * Last activity: [16 years ago](https://wordpress.org/support/topic/usersphp-1/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics