IPv6Freely Posted May 10, 2018 Share Posted May 10, 2018 Is there a good way to determine what % of users/topics/posts are from IPv6 users? I'd love to see that kind of statistic. Link to comment Share on other sites More sharing options...
bfarber Posted May 11, 2018 Share Posted May 11, 2018 Why? Link to comment Share on other sites More sharing options...
IPv6Freely Posted July 6, 2018 Author Share Posted July 6, 2018 On 5/11/2018 at 5:50 AM, bfarber said: Why? Because it would be interesting to me. Link to comment Share on other sites More sharing options...
Rhett Posted July 6, 2018 Share Posted July 6, 2018 https://www.google.com/intl/en/ipv6/statistics.html Considering pretty much everyone uses google in some manner, this would be pretty accurate. Link to comment Share on other sites More sharing options...
bfarber Posted July 9, 2018 Share Posted July 9, 2018 You could probably query your database directly to capture this information. Something along the lines of SELECT COUNT(*) FROM _table_ WHERE ip_address LIKE '%:%'; SELECT COUNT(*) FROM _table_ WHERE ip_address NOT LIKE '%:%'; Link to comment Share on other sites More sharing options...
Nathan Explosion Posted July 9, 2018 Share Posted July 9, 2018 IPv4: Select count(*) from table where inet_aton(ip_address) IS NOT NULL IPv6: Select count(*) from table where inet_aton(ip_address) IS NULL Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.