Export ip address in csv

Hi @golded,

There is no way to export CSV data within Wordfence.

However, I’ve written a query for you:

SELECT INET6_NTOA(IP), ctime 
FROM wp_wfhits 
ORDER BY ctime DESC 
INTO OUTFILE 'D:/output2.csv' 
FIELDS TERMINATED BY ',' 
ENCLOSED BY '"' 
LINES TERMINATED BY '\n';

This will generate a CSV file named /output.csv that looks like this:

"::1","1550651582.887000"
"::1","1550651579.051000"
"::1","1550651547.256000"

Where the first column is the IP address, and the second is the unix timestamp. The rows are sorted from most recent to the oldest.

—

Can you explain what is wrong with the filtering? Note that you need to choose the correct time zone for the From and To filtering.

For example: https://i.imgur.com/9gZrC9S.png

Dave

Hi again,

To use that query, you can use SSH to connect to your host, and then run that query on your database. (Alternatively, you can use the PHPMyAdmin to run SQL)

Regarding the date filter, you need to set To: to a later date then From:.

For example:

From: 03/12/2019 1:00pm
To: 03/12/2019 6:00pm

This will select the data from 1:00pm to 6:00pm.

If you have From and To the same, then it won’t select any data because there is no range to select.

Dave