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) …

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

IP가 일치하는 계정 스캔

제품 지원

MarcP (MarcP) 11월 20, 2019, 7:27오후 3

저한테는 잘 동작하는 것 같습니다. Data Explorer 플러그인에 대해서는 전혀 몰랐네요. 감사합니다!

글		댓글	조회수
Two users from same IP address Product Support	2	672	9월 12, 2019
Need a IP duplication query Data & reporting sql-query	3	714	7월 17, 2019
Add report: Duplicate IP address Feature	7	2087	8월 13, 2020
Query regarding IP Lookup feature Product Support	3	788	10월 20, 2021
Duplicate account icon for suspended users Feature	9	1642	8월 27, 2017

IP가 일치하는 계정 스캔

Related topics