Admin Reporting from the vB User List

[oldengine]

Is there any way to extract a report from my user list to get a name and location report based upon their user group?

I have 18,000 users, and the group that I want the list from is 800 users!

[Jake Bunce]

You can do that in your:

Admin CP -> Users -> Search for Users

You will notice that you can search by group. And there are display options at the bottom to specify which fields are shown.

[oldengine]

Yikes! I was blinded by so many buttons and choices. :p

Now if I could get that to go into a file or on paper.

[Lats]

Probably best to run a query in phpmyadmin and export the results to excel or similar. This query grabs the username and location (field2)...

SELECT
username,
userfield.field2
FROM
user
LEFT JOIN
userfield
ON
userfield.userid = user.userid
WHERE
usergroupid = 6
ORDER BY
field2

[oldengine]

Thanks! I'll put my learning curve into it.

[ChipTz]

Hi,

Can you please inform how to run a simmilar query but to retrieve username and userid?

thank you

[Lats]

Hi,

Can you please inform how to run a simmilar query but to retrieve username and userid?

thank you
Sure, just add userid to the query, such as...

SELECT
username, userid
userfield.field2
FROM
user
LEFT JOIN
userfield
ON
userfield.userid = user.userid
WHERE
usergroupid = 6
ORDER BY
field2