I know in the user admin we can see if there is another account on a IP address when you click the registered IP or last login IP, can we also see all users that have been matched with double IP’s instead of checking all my users one by one?

Here’s a data explorer query. It’d be better if it did a group by so that it could sort by most-recent-create-date or something like that, but maybe this’ll help. 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) …

扫描匹配IP的账户

支持

MarcP (MarcP) 2019 年11 月 20 日 19:27 3

This seems to be working fine for me, didn’t know about Data Explorer Plugin at all… Thanks!

话题		回复	浏览量
Two users from same IP address Support	4	615	2023 年4 月 17 日
Need a IP duplication query Data & reporting sql-query	4	626	2019 年8 月 16 日
Add report: Duplicate IP address Feature	7	1962	2020 年8 月 13 日
Query regarding IP Lookup feature Support	3	629	2021 年10 月 20 日
Duplicate account icon for suspended users Feature	9	1559	2017 年8 月 27 日

扫描匹配IP的账户

相关话题