Is there a way to find out how many activated, registered users there are?


The Drupal way would be to use Views to create a report for yourself (I would avoid querying any tables in the db directly.)

If you don't have the Views module installed, download and install it from

Once installed, create a new View on the User object. You will be able specify which fields you want to display, sort order, and filters.

Depending on which version of Views you are using (might be Views 2 in Drupal 6) you may also need to use an additional module called Views Calc in order to get the count of records returned:

You can query the users table, counting the number of rows where status = 1, which will give you the number of active user accounts.

Tags: Drupal 6 / Users / Nodes

Similar questions

How to structure a "many-to-many" relationship between nodes
I would like to have 2 node types, Sellers and Products. Each seller can have many products, and each product can have many sellers. Also, the relationship between Sellers and Products would need to contain a price. What would be the best way to create that relationship, making it easy to list all the Products a seller sells on their page (with pri...
creating nodes with many to many relationship type with some fields?
This is in line with How to structure a "many-to-many" relationship between nodes. To keep things in line with the example from the linked thread, what if i was a book warehouse and i had a list of all my books but i want to allow each seller to name his own price and show that book in the seller's store view with only the price that he s...
Views one to many relationship, display many records in columns
I have a View with a one to many relationship. ID and Session are in my main table, and "mark"'s are rows in a custom table. When I look up a single ID, I get this result because of the 'many' results in the custom table. ID | Session | mark 15 | Spring 2013 | 16 15 | Spring 2013 | 3 15 | Spring 2013 | 5.5 My desired result is: ID | Session | mark ...
Create many to many Relationship with a specific fields in a Content type to taxonomy
I am currently encounter a problem, I have one content type (Type) and two taxonomy needed to be link up, in that content type, I need to apply a many to many relationship among a field (Name: Core) and two taxonomy Terms (Such like below image), I would like to ask is there any method to implement this idea??
How many taxonomy terms are too many?
I have a website where I publish book reviews. For each book I publish 2-3 quotes from the book. I'm using the following fields as taxonomy, so that when a user clicks on them he/she can find more content of that category. Lets say, over the period of time, I add reviews of about 5000 books, then there will be 5000 taxonomy terms for "book name". S...
Cant create View with Many to Many Relationship
I have a situation with three content types. (Simplified) A Person is referenced in many Transactions, and a Transaction also has a reference to a Company. I.e. Person -< Transactions >- Company Here the Transaction holds the entity reference to a Person, and a reference to a Company. I need to create a view that given a value from the Compan...

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.