Where to find User ID information


(Ranga Ta) #1

Hi

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

Thanks
Ranga


(Vinoth Kannan) #2

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

/admin/users/:user_id/:username

(Jay Pfaffman) #3

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


Extract the data for each event by category
(Ranga Ta) #4

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

Thanks
Ranga


(Joshua Rosenfeld) #5

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.


(Ranga Ta) #6

Hi Joshua

How do we find the database connectivity information for the discourse

Thanks
Ranga


(Joshua Rosenfeld) #7

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


(Ranga Ta) #8

How can we query to discourse database


(Robin Ward) #9

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.


(Robin Ward) #10