# How do I audit votes for fraudulent behavior

**URL:** https://meta.discourse.org/t/how-do-i-audit-votes-for-fraudulent-behavior/58487
**Category:** Support
**Tags:** topic-voting
**Created:** [November 22, 2016, 11:23pm UTC](https://meta.discourse.org/t/how-do-i-audit-votes-for-fraudulent-behavior/58487 "2016-11-22T23:23:31Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![kgish](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/kgish/32/121131_2.png) [@kgish](https://meta.discourse.org/u/kgish)
#### Post date: [November 22, 2016, 11:23pm UTC](https://meta.discourse.org/t/how-do-i-audit-votes-for-fraudulent-behavior/58487/1 "2016-11-22T23:23:31Z")

</div>

In order to prevent fraudulent behavior, I need to generate an overview of users and for each topic how many times they voted on it. How should I do this?

---

<div class="post-metadata">

### Author: ![joebuhlig](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/joebuhlig/32/193054_2.png) [@joebuhlig](https://meta.discourse.org/u/joebuhlig)
#### Post date: [November 23, 2016, 1:30pm UTC](https://meta.discourse.org/t/how-do-i-audit-votes-for-fraudulent-behavior/58487/2 "2016-11-23T13:30:17Z")

</div>

I would use the [Data Explorer](https://meta.discourse.org/t/32566?silent=true) plugin.

> [@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…

There are custom fields on the User model that indicate which topics they’ve voted on.

---

<div class="post-metadata">

### Author: ![system](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/system/32/443519_2.png) [@system](https://meta.discourse.org/u/system)
#### Post date: [September 19, 2020, 9:32am UTC](https://meta.discourse.org/t/how-do-i-audit-votes-for-fraudulent-behavior/58487/3 "2020-09-19T09:32:34Z")

</div>



---

<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 2, 2025, 4:06pm UTC](https://meta.discourse.org/t/how-do-i-audit-votes-for-fraudulent-behavior/58487/4 "2025-12-02T16:06:50Z")

</div>