# Daily graph of user time online

**URL:** https://meta.discourse.org/t/daily-graph-of-user-time-online/33965
**Category:** Feature
**Created:** [September 30, 2015, 6:20pm UTC](https://meta.discourse.org/t/daily-graph-of-user-time-online/33965 "2015-09-30T18:20:51Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [September 30, 2015, 6:20pm UTC](https://meta.discourse.org/t/daily-graph-of-user-time-online/33965/1 "2015-09-30T18:20:51Z")

</div>

I’m using Discourse as a platform for online instruction. It would be helpful if I could get data that showed the activity stats available at /admin/users/list/active for the last X days. Is there an easy way to get that?

If I could get a dump of [Topics Viewed, Posts Read, Read Time] for all users that’d be great.

---

<div class="post-metadata">

### Author: ![codinghorror](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/codinghorror/32/110067_2.png) [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [September 30, 2015, 8:05pm UTC](https://meta.discourse.org/t/daily-graph-of-user-time-online/33965/2 "2015-09-30T20:05:04Z")

</div>

If you have [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin installed, you can query it out with that.

---

<div class="post-metadata">

### Author: ![pfaffman](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/pfaffman/32/120154_2.png) [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [October 1, 2015, 7:19pm UTC](https://meta.discourse.org/t/daily-graph-of-user-time-online/33965/3 "2015-10-01T19:19:05Z")

</div>

To save someone a search. . . [Data explorer](https://meta.discourse.org/t/32566?silent=true) is here:

> [@Discourse Data Explorer](https://meta.discourse.org/t/data-explorer-plugin/32566):
>
> discourse2Summary Discourse [Data Explorer](https://meta.discourse.org/t/32566?silent=true) allows you to make SQL queries against your live database, allowing for up-to-the-minute stats reporting.open_bookInstall Guide This plugin is bundled with Discourse core. There is no need to install the plugin separately.information_source If you’re looking for examples or support for any custom queries, you can find lots of topics in our #Data & reporting category under the #sql-query tag. If there’s not one to suit your pa…

---

<div class="post-metadata">

### Author: ![chapoi](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/chapoi/32/537252_2.png) [@chapoi](https://meta.discourse.org/u/chapoi)
#### Post date: [December 4, 2025, 11:37am UTC](https://meta.discourse.org/t/daily-graph-of-user-time-online/33965/4 "2025-12-04T11:37:01Z")

</div>


