Monday, November 21, 2011

Mozilla Firefox History Reports

I've used FoxAnalysis for history reporting on Firefox in the past but it runs very, very slowly. I found a much faster way to do it by using the information on http://www.makeuseof.com/answers/save-print-firefox-history-including-time-date-information-mac/ . It works perfectly. I use the modified version of the SQL statement that is below to limit the date range, set an alias for the datetime column and limit the date range.

SELECT datetime(moz_historyvisits.visit_date/1000000,'unixepoch','localtime') as date, moz_places.url, moz_places.title
FROM moz_places, moz_historyvisits
WHERE moz_places.id = moz_historyvisits.place_id and date>'2011-11-13' and date<'2011-11-19' order by date

No comments:

Post a Comment