Dump of List of Posts Count Per User Command?

[hamster0914]

Hi,

Is there any way to dump a list of total post counts per username out of the database? The listing from the cpanel is too ungainly to do anything useful with a large site.

Thanks for any help.

Hamish

[Wayne Luke]

You can run the query of:

select username, posts from user;

Using phpMyAdmin, you can export the results of that query as a CSV file for use in a spreadsheet application.