# Viewing edit activity
**URL:** https://meta.discourse.org/t/viewing-edit-activity/62304
**Category:** Support
**Created:** [May 8, 2017, 6:31pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304 "2017-05-08T18:31:54Z")
**Posts on this page:** 13
**Page:** 1
### Author:  [@jsha](https://meta.discourse.org/u/jsha)
#### Post date: [May 8, 2017, 6:31pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/1 "2017-05-08T18:31:54Z")
As an admin or moderator, is there a way to view the history of a user’s edits to other people’s posts? And/or a way to view a global history of all edits to others’ posts? I’d like to occasionally do a read-through to make sure such edits are reasonable, and be able to provide feedback to Regular-level members on how to make good edits.
---
### Author:  [@cpradio](https://meta.discourse.org/u/cpradio)
#### Post date: [May 8, 2017, 6:37pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/2 "2017-05-08T18:37:09Z")
[Data Explorer](https://meta.discourse.org/t/32566?silent=true) Plugin. The query you will want to start with
```plaintext
SELECT *
FROM post_revisions
```
You will probably want to eventually add date filters as I believe it limits to 200 results.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [June 3, 2019, 7:23am UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/3 "2019-06-03T07:23:27Z")
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [June 3, 2019, 5:36pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/4 "2019-06-03T17:36:46Z")
We have since added a built in report for this in the admin dashboard.
---
### Author:  [@jsha](https://meta.discourse.org/u/jsha)
#### Post date: [June 3, 2019, 6:26pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/5 "2019-06-03T18:26:32Z")
Awesome, thanks! I’ll check it out.
---
### Author:  [@jsha](https://meta.discourse.org/u/jsha)
#### Post date: [June 5, 2019, 8:48pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/6 "2019-06-05T20:48:11Z")
I think there may be a bug. When I visit [https://community.letsencrypt.org/admin/reports/post\_edits?end\_date=2019-06-05&start\_date=2019-05-01](https://community.letsencrypt.org/admin/reports/post_edits?end_date=2019-06-05&start_date=2019-05-01), I see “Post Edits — No data to display.”, even if I hit “Refresh Report” multiple times.
I know there are edits because I [lifted our restrictions on edits](https://community.letsencrypt.org/t/legitimate-posts-ending-in-spam-links/64465/49?u=jsha), and we recently [got another instance of a spammy edit](https://community.letsencrypt.org/t/legitimate-posts-ending-in-spam-links/64465/50?u=jsha).
---
### Author:  [@codinghorror](https://meta.discourse.org/u/codinghorror)
#### Post date: [June 6, 2019, 5:38am UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/7 "2019-06-06T05:38:43Z")
Can you repro this @tshenry
---
### Author:  [@tshenry](https://meta.discourse.org/u/tshenry)
#### Post date: [June 6, 2019, 10:08am UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/9 "2019-06-06T10:08:59Z")
I’m not able to repro at the moment. Still digging.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [July 6, 2019, 10:27am UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/11 "2019-07-06T10:27:43Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.
---
### Author:  [@tshenry](https://meta.discourse.org/u/tshenry)
#### Post date: [August 14, 2019, 7:36pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/12 "2019-08-14T19:36:54Z")
---
### Author:  [@tshenry](https://meta.discourse.org/u/tshenry)
#### Post date: [August 14, 2019, 7:40pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/13 "2019-08-14T19:40:19Z")
Hey Jacob, I just wanted to follow up here and let you know the issue with the Post Edits report has been fixed. You should see a nice a full list of post edits on the report going forward 🙂
---
### Author:  [@jsha](https://meta.discourse.org/u/jsha)
#### Post date: [August 30, 2019, 6:26pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/14 "2019-08-30T18:26:41Z")
Thanks! This is working great. Interestingly, in the time since I originally reported this, I came across a related need for a Post Edit report. [Spammers are posting innocuous things and later editing them to contain links](https://meta.discourse.org/t/human-driven-copy-paste-spam/97205).
The current Post Edit report only shows when User A edits User B’s post, which is definitely what I originally requested. It’s a little confusing though that it leaves out when User A edits User A’s post.
I think my use case is adequately solved by the [Data Explorer query described here](https://meta.discourse.org/t/human-driven-copy-paste-spam/97205/52), so I’m not requesting a code change, but I would recommend tweaking the title of this report to something like “Cross-user edits” or similar. 🙂
Thanks again for all your help.
---
### Author:  [@system](https://meta.discourse.org/u/system)
#### Post date: [September 29, 2019, 6:26pm UTC](https://meta.discourse.org/t/viewing-edit-activity/62304/15 "2019-09-29T18:26:46Z")
This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.