Jump to content

IPv6 Users

Featured Replies

Posted

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. 

  • 1 month later...
  • Author
On 5/11/2018 at 5:50 AM, bfarber said:

Why?

Because it would be interesting to me. 

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

 

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

 

Archived

This topic is now archived and is closed to further replies.

Recently Browsing 0

  • No registered users viewing this page.