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