SBM Labs

Cyber Security Collaboration Project

Analysis of Google Chrome browsing history
05 Sep 2014

1. Install add-on "SQLite Manager" for the browser Mozilla Firefox.

2. Open file History.
- Ubuntu -> [user_home_directory]/.config/google-chrome/Default/History.
- Windows -> [user_home_directory]/AppData/Local/Google/Chrome/User Data/Default/History.

3. Go to the tab "Execute SQL" and execute sql query.

SELECT last_visit_time, url FROM urls WHERE url LIKE '%url1%' ORDER BY last_visit_time DESC

4. You should use function datetime() in order to convert timestamp to human view.

SELECT datetime(last_visit_time/1000000-11644473600,'unixepoch','localtime') AS time, url FROM urls WHERE url LIKE '%url1%' ORDER BY time DESC

Analysis of Mozilla Firefox browsing history