# Two users from same IP address

**URL:** https://meta.discourse.org/t/two-users-from-same-ip-address/128419
**Category:** Support
**Created:** [September 12, 2019, 4:17pm UTC](https://meta.discourse.org/t/two-users-from-same-ip-address/128419 "2019-09-12T16:17:29Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![verilog15](https://avatars.discourse-cdn.com/v4/letter/v/9f8e36/32.png) [@verilog15](https://meta.discourse.org/u/verilog15)
#### Post date: [September 12, 2019, 4:17pm UTC](https://meta.discourse.org/t/two-users-from-same-ip-address/128419/1 "2019-09-12T16:17:29Z")

</div>

Hello all,  
Is there a way to see if two users were created by the same person (maybe they were created from same ip)?

---

<div class="post-metadata">

### Author: ![Thomas\_G](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/thomas_g/32/200158_2.png) [@Thomas\_G](https://meta.discourse.org/u/Thomas_G)
#### Post date: [September 12, 2019, 5:08pm UTC](https://meta.discourse.org/t/two-users-from-same-ip-address/128419/2 "2019-09-12T17:08:20Z")

</div>

Head to their admin section and check the IP’s. If someone has created a second account, the first account will appear there.

---

<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 12, 2019, 6:12pm UTC](https://meta.discourse.org/t/two-users-from-same-ip-address/128419/3 "2019-09-12T18:12:25Z")

</div>

This [data explorer](https://meta.discourse.org/t/32566?silent=true) query will tell you if they have the same IP address, which is not the same as being the same person.

```plaintext
WITH users_per_ip AS (
SELECT
count(1) AS user_count,
u.registration_ip_address AS ip,
max(u.created_at) last_create,
min(u.created_at) first_create,
(max(u.created_at) - min(u.created_at)) diff,
case when (max(u.suspended_at) is not null 
      or max(u.silenced_till) is not null )
      then 1 else 0 end bad
FROM users u
GROUP BY ip
)

SELECT
u.id AS user_id,
date_trunc('day',u.created_at)::date created,
date_trunc('day',upi.diff) days,
bad,
upi.ip AS ip_address
FROM users_per_ip upi
JOIN users u
ON u.registration_ip_address = upi.ip
WHERE upi.user_count > 1
ORDER BY upi.last_create DESC

```

---

<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: [April 17, 2023, 4:55pm UTC](https://meta.discourse.org/t/two-users-from-same-ip-address/128419/4 "2023-04-17T16:55:08Z")

</div>



---

<div class="post-metadata">

### Author: ![JammyDodger](https://sea3.discourse-cdn.com/meta/user_avatar/meta.discourse.org/jammydodger/32/254611_2.png) [@JammyDodger](https://meta.discourse.org/u/JammyDodger)
#### Post date: [April 17, 2023, 6:09pm UTC](https://meta.discourse.org/t/two-users-from-same-ip-address/128419/5 "2023-04-17T18:09:23Z")

</div>