Hi there, on the large non-Discourse forum that I administer I find it very useful when there are site performance problems to check this report: [Screenshot from 2022-12-06 14-41-16] Fairly regularly the site gets hit by a nuisance crawler / scraper that brings the server to its knees, and the IP address can be checked on abuseipdb.com to confirm that it’s a nefarious agent and not a legitimate crawler. Or sometimes a registered user is up to something that hammers the server, and this report also helps to identify the source of the problem. Would it be possible to use the Discourse Data Explorer plugin to create something similar?

[image] rahim123: Would it be possible to use the Discourse Data Explorer plugin to create something similar? Definitely, I think this would be a great fit. For example, there are queries shipped by default with the Data Explorer plugin such as Most Active Lurkers. active users without posts and excessive read times, it accepts a post_read_count parameter that sets the threshold for posts read. Or User Participation Statistics Detailed statistics for the most active users. This can of course be tweaked to your use case… or you can write something custom to fit your needs.

Report for top page hit counter and page generation time per IP address or user

Community Building Data & reporting

rahim123 December 6, 2022, 9:03pm 3

Ah, thanks, I didn’t know that it came with queries shipped out-of-the-box.

Topic		Replies	Views
Daily graph of user time online Feature	2	2327	October 1, 2015
How to measure active users? Data & reporting sql-query	15	5237	March 6, 2025
Is there a log of user visits? Product Support	6	1712	October 27, 2018
Create report for amount of interactions per user Feature	4	1691	February 12, 2018
Forum Data Data & reporting	2	480	May 15, 2024

Report for top page hit counter and page generation time per IP address or user

Related topics