How can you see how many posts users made in a day?

[TNERatedEdge]

How can you see how many posts users made in a day?

Is there an option in the admin panel?

[AusPhotography]

Custom select query...

SELECT Count(*) AS ActivityCount, `user`.`userid`, `user`.`username` AS Username
FROM `post`
INNER JOIN `user` ON `post`.`userid` = `user`.`userid`
WHERE FROM_UNIXTIME(`post`.`dateline`) >= DATE_SUB(NOW(), INTERVAL 1 DAY)
AND `post`.`visible` < 2
GROUP BY Username
ORDER BY ActivityCount DESC, Username ASC

[TNERatedEdge]

how do I do that?

[AusPhotography]

Directly to your database
-or-
AdminCP -> Maintenance -> Execute SQL Query