# Full IP access log

**URL:** https://meta.discourse.org/t/full-ip-access-log/270050
**Category:** Support
**Created:** [June 29, 2023, 4:28pm UTC](https://meta.discourse.org/t/full-ip-access-log/270050 "2023-06-29T16:28:30Z")
**Posts on this page:** 1
**Showing post:** 2

<div class="post-metadata">

### Author: ![not-ethan](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/not-ethan/32/282617_2.png) [@not-ethan](https://meta.discourse.org/u/not-ethan)
#### Post date: [June 29, 2023, 10:02pm UTC](https://meta.discourse.org/t/full-ip-access-log/270050/2 "2023-06-29T22:02:54Z")

</div>

You can with the [data explorer](https://meta.discourse.org/t/discourse-data-explorer/32566) plugin and this query.

```sql
SELECT id, username, ip_address, registration_ip_address FROM users

```

That will select the id, username, last IP and Reg IP for every user.

---

_[View the full topic](https://meta.discourse.org/t/full-ip-access-log/270050)._