Something that was very helpfull to me recently was being able to access Chrome's web history and search terms of a computer that I didnt have the login for.
I was able to successfully work out the information I needed.
The files are located in the application data under Google then Chrome then User Data
Windows 7/vista:
C:\Users\<Username>\AppData\Local\Google\Chrome\User Data\Default
They are SQLite DB files.
See the History or any of the History Index files.
You can query them with any SQLite tool
http://sourceforge.net/projects/sqlitebrowser/
The time format used in chrome is a bit weird heres how to get it into a usefull datetime.
SELECT id,title,url,datetime((last_visit_time/1000000)-11644473600, 'unixepoch', 'localtime') AS time FROM urls
Optionally tack on something to search for all titles that are like bus
WHERE title LIKE '%bus%'
I was able to export csv and xls using this tool.
http://www.speqmath.com/tutorials/sqlite_export/
No comments:
Post a Comment