IPv6 Users

[IPv6Freely]

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. 

[bfarber]

Why?

[IPv6Freely]

On 5/11/2018 at 5:50 AM, bfarber said:

Why?

Because it would be interesting to me. 

[Rhett]

https://www.google.com/intl/en/ipv6/statistics.html

Considering pretty much everyone uses google in some manner, this would be pretty accurate. 

[bfarber]

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 '%:%';

 

[Nathan Explosion]

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