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) 2019年十一月20日 19:27 3

这对我来说似乎运行正常，我之前完全不知道 Data Explorer Plugin 这个插件……谢谢！

話題		回覆	觀看
Two users from same IP address Support	2	669	2019年九月12日
Need a IP duplication query Data & reporting sql-query	3	699	2019年七月17日
Add report: Duplicate IP address Feature	7	2059	2020年八月13日
Query regarding IP Lookup feature Support	3	751	2021年十月20日
Duplicate account icon for suspended users Feature	9	1616	2017年八月27日

扫描匹配IP的账户

相關主題