Where to find User ID information

Hi

How to do we extract the username and user ID information for all the users

Thanks
Ranga

Go to the admin page of th user. There you can have user id in page url.

/admin/users/:user_id/:username
4 Likes

I think that you night want the data explorer plugin. It’ll let you do queries and download csv files.

Data Explorer Plugin is enabled, how do we download event or User ID information. Or SSO information from the User details?

Thanks
Ranga

You need to write an SQL query for the information you want. To get the user id for all users, enter the following query:

SELECT users.username, users.id
FROM users
ORDER BY id

That will sort by user id. If you want to sort by username, replace ORDER BY id with ORDER BY username.

Hi Joshua

How do we find the database connectivity information for the discourse

Thanks
Ranga

I’m sorry, I’m not sure what you’re asking…

How can we query to discourse database

You’ve been told how to use Data Explorer to query the database, but you keep asking the same question over and over and posted a second topic about it. It is frustrating for our community members to help you out and have their advice be ignored.

Please take the time to read the data explorer topic.

7 Likes