IP format in wfHits

  • Resolved kokoko

    (@raaaa86)


    7 years, 3 months ago

    Hi,

    I see that IP is stored in wfHits table like:
    0x00000000000000000000ffff2d3f52285. Is there a way to see proper IP address?

    Thanks

Viewing 2 replies - 1 through 2 (of 2 total)
  • wfdave

    (@wfdave)

    7 years, 3 months ago

    Hi @raaaa86,

    You can use the following query to see the IPs in the proper format:

    SELECT INET6_NTOA(IP) from wp_wfhits;

    If that doesn’t work, please also try this query:

    SELECT INET_NTOA(IP) from wp_wfhits;

    Dave

    Thread Starter kokoko

    (@raaaa86)

    7 years, 3 months ago

    Hi @wfdave,

    First one works. Thank you so much for help.

    • This reply was modified 7 years, 3 months ago by kokoko.
Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘IP format in wfHits’ is closed to new replies.