SQL Query to extract user information along with profile info
plabrown - February 21, 2008 - 01:45
| Project: | Advanced User |
| Version: | 4.7.x-3.x-dev |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | closed |
Jump to:
Description
Hi,
Do you have a query that will allow me to extract user and profile information? I need to generate an Excel file for the membership officer to check all site users information.
Peter.
#1
That might be dependent on what modules you have installed. You can use phpMyAdmin, assuming MySql, to look at the table structures and create a query. Look at tables with users and profile in the in the table name. If you elected to store profile information in nodes then you'll also need to find the related nodes. If you have other questions about this then I suggest you use the mail list support@lists.drupal.org since it has a wider audience.