Analyzing Browser Forensics with Hindsight
Overview
Hindsight is an open-source browser forensics tool designed to parse artifacts from Google Chrome and other Chromium-based browsers (Microsoft Edge, Brave, Opera, Vivaldi). It extracts and correlates data from multiple browser database files to create a unified timeline of web activity. Hindsight can parse URLs, download history, cache records, bookmarks, autofill records, saved passwords, preferences, browser extensions, HTTP cookies, Local Storage (HTML5 cookies), login data, and session/tab information. The tool produces chronological timelines in multiple output formats (XLSX, JSON, SQLite) that enable investigators to reconstruct user web activity for incident response, insider threat investigations, and criminal cases.
Prerequisites
- Python 3.8+ with Hindsight installed (
pip install pyhindsight)
- Access to browser profile directories from forensic image
- Browser profile data (not encrypted with OS-level encryption)
- Timeline Explorer or spreadsheet application for analysis
Browser Profile Locations
| Browser |
Windows Profile Path |
| Chrome |
%LOCALAPPDATA%\Google\Chrome\User Data\Default\ |
| Edge |
%LOCALAPPDATA%\Microsoft\Edge\User Data\Default\ |
| Brave |
%LOCALAPPDATA%\BraveSoftware\Brave-Browser\User Data\Default\ |
| Opera |
%APPDATA%\Opera Software\Opera Stable\ |
| Vivaldi |
%LOCALAPPDATA%\Vivaldi\User Data\Default\ |
| Chrome (macOS) |
~/Library/Application Support/Google/Chrome/Default/ |
| Chrome (Linux) |
~/.config/google-chrome/Default/ |
Key Artifact Files
| File |
Contents |
| History |
URL visits, downloads, keyword searches |
| Cookies |
HTTP cookies with domain, expiry, values |
| Web Data |
Autofill entries, saved credit cards |
| Login Data |
Saved usernames/passwords (encrypted) |
| Bookmarks |
JSON bookmark tree |
| Preferences |
Browser configuration and extensions |
| Local Storage/ |
HTML5 Local Storage per domain |
| Session Storage/ |
Session-specific storage per domain |
| Network Action Predictor |
Previously typed URLs |
| Shortcuts |
Omnibox shortcuts and predictions |
| Top Sites |
Frequently visited sites |
Running Hindsight
Command Line
# Basic analysis of a Chrome profile
hindsight.exe -i "C:\Evidence\Users\suspect\AppData\Local\Google\Chrome\User Data\Default" -o C:\Output\chrome_analysis
# Specify browser type
hindsight.exe -i "/path/to/profile" -o /output/analysis -b Chrome
# JSON output format
hindsight.exe -i "C:\Evidence\Chrome\Default" -o C:\Output\chrome --format jsonl
# With cache parsing (slower but more complete)
hindsight.exe -i "C:\Evidence\Chrome\Default" -o C:\Output\chrome --cache
Web UI
# Start Hindsight web interface
hindsight_gui.exe
# Navigate to http://localhost:8080
# Upload or point to browser profile directory
# Configure output format and analysis options
# Generate and download report
Artifact Analysis Details
URL History and Visits
-- Chrome History database schema (key tables)
-- urls table: id, url, title, visit_count, typed_count, last_visit_time
-- visits table: id, url, visit_time, from_visit, transition, segment_id
-- Timestamps are Chrome/WebKit format: microseconds since 1601-01-01
-- Convert: datetime((visit_time/1000000)-11644473600, 'unixepoch')
Download History
-- downloads table: id, current_path, target_path, start_time, end_time,
-- received_bytes, total_bytes, state, danger_type, interrupt_reason,
-- url, referrer, tab_url, mime_type, original_mime_type
Cookie Analysis
-- cookies table: creation_utc, host_key, name, value, encrypted_value,
-- path, expires_utc, is_secure, is_httponly, last_access_utc,
-- has_expires, is_persistent, priority, samesite
Python Analysis Script
import sqlite3
import os
import json
import sys
from datetime import datetime, timedelta
CHROME_EPOCH = datetime(1601, 1, 1)
def chrome_time_to_datetime(chrome_ts: int):
"""Convert Chrome timestamp to datetime."""
if chrome_ts == 0:
return None
try:
return CHROME_EPOCH + timedelta(microseconds=chrome_ts)
except (OverflowError, OSError):
return None
def analyze_chrome_history(profile_path: str, output_dir: str) -> dict:
"""Analyze Chrome History database for forensic evidence."""
history_db = os.path.join(profile_path, "History")
if not os.path.exists(history_db):
return {"error": "History database not found"}
os.makedirs(output_dir, exist_ok=True)
conn = sqlite3.connect(f"file:{history_db}?mode=ro", uri=True)
# URL visits with timestamps
cursor = conn.cursor()
cursor.execute("""
SELECT u.url, u.title, v.visit_time, u.visit_count,
v.transition & 0xFF as transition_type
FROM visits v JOIN urls u ON v.url = u.id
ORDER BY v.visit_time DESC LIMIT 5000
""")
visits = [{
"url": r[0], "title": r[1],
"visit_time": str(chrome_time_to_datetime(r[2])),
"total_visits": r[3], "transition": r[4]
} for r in cursor.fetchall()]
# Downloads
cursor.execute("""
SELECT target_path, tab_url, start_time, end_time,
received_bytes, total_bytes, mime_type, state
FROM downloads ORDER BY start_time DESC LIMIT 1000
""")
downloads = [{
"path": r[0], "source_url": r[1],
"start_time": str(chrome_time_to_datetime(r[2])),
"end_time": str(chrome_time_to_datetime(r[3])),
"received_bytes": r[4], "total_bytes": r[5],
"mime_type": r[6], "state": r[7]
} for r in cursor.fetchall()]
# Keyword searches
cursor.execute("""
SELECT k.term, u.url, k.url_id
FROM keyword_search_terms k JOIN urls u ON k.url_id = u.id
ORDER BY u.last_visit_time DESC LIMIT 1000
""")
searches = [{"term": r[0], "url": r[1]} for r in cursor.fetchall()]
conn.close()
report = {
"analysis_timestamp": datetime.now().isoformat(),
"profile_path": profile_path,
"total_visits": len(visits),
"total_downloads": len(downloads),
"total_searches": len(searches),
"visits": visits,
"downloads": downloads,
"searches": searches
}
report_path = os.path.join(output_dir, "browser_forensics.json")
with open(report_path, "w") as f:
json.dump(report, f, indent=2)
return report
def main():
if len(sys.argv) < 3:
print("Usage: python process.py <chrome_profile_path> <output_dir>")
sys.exit(1)
analyze_chrome_history(sys.argv[1], sys.argv[2])
if __name__ == "__main__":
main()
References
1---2name: analyzing-browser-forensics-with-hindsight3description: Analyze Chromium-based browser artifacts using Hindsight to extract browsing history, downloads, cookies, cached content, autofill data, saved passwords, and browser extensions from Chrome, Edge, Brave, and Opera for forensic investigation.4domain: cybersecurity5subdomain: digital-forensics6tags: [browser-forensics, hindsight, chrome-forensics, chromium, edge, browsing-history, cookies, downloads, cache, web-artifacts]7version: "1.0"8author: mahipal9license: MIT10metadata:11 source: https://skillmd.com/skills/njones17/analyzing-browser-forensics-with-hindsight12---1314# Analyzing Browser Forensics with Hindsight1516## Overview1718Hindsight is an open-source browser forensics tool designed to parse artifacts from Google Chrome and other Chromium-based browsers (Microsoft Edge, Brave, Opera, Vivaldi). It extracts and correlates data from multiple browser database files to create a unified timeline of web activity. Hindsight can parse URLs, download history, cache records, bookmarks, autofill records, saved passwords, preferences, browser extensions, HTTP cookies, Local Storage (HTML5 cookies), login data, and session/tab information. The tool produces chronological timelines in multiple output formats (XLSX, JSON, SQLite) that enable investigators to reconstruct user web activity for incident response, insider threat investigations, and criminal cases.1920## Prerequisites2122- Python 3.8+ with Hindsight installed (`pip install pyhindsight`)23- Access to browser profile directories from forensic image24- Browser profile data (not encrypted with OS-level encryption)25- Timeline Explorer or spreadsheet application for analysis2627## Browser Profile Locations2829| Browser | Windows Profile Path |30|---------|---------------------|31| Chrome | %LOCALAPPDATA%\Google\Chrome\User Data\Default\ |32| Edge | %LOCALAPPDATA%\Microsoft\Edge\User Data\Default\ |33| Brave | %LOCALAPPDATA%\BraveSoftware\Brave-Browser\User Data\Default\ |34| Opera | %APPDATA%\Opera Software\Opera Stable\ |35| Vivaldi | %LOCALAPPDATA%\Vivaldi\User Data\Default\ |36| Chrome (macOS) | ~/Library/Application Support/Google/Chrome/Default/ |37| Chrome (Linux) | ~/.config/google-chrome/Default/ |3839## Key Artifact Files4041| File | Contents |42|------|----------|43| History | URL visits, downloads, keyword searches |44| Cookies | HTTP cookies with domain, expiry, values |45| Web Data | Autofill entries, saved credit cards |46| Login Data | Saved usernames/passwords (encrypted) |47| Bookmarks | JSON bookmark tree |48| Preferences | Browser configuration and extensions |49| Local Storage/ | HTML5 Local Storage per domain |50| Session Storage/ | Session-specific storage per domain |51| Network Action Predictor | Previously typed URLs |52| Shortcuts | Omnibox shortcuts and predictions |53| Top Sites | Frequently visited sites |5455## Running Hindsight5657### Command Line5859```bash60# Basic analysis of a Chrome profile61hindsight.exe -i "C:\Evidence\Users\suspect\AppData\Local\Google\Chrome\User Data\Default" -o C:\Output\chrome_analysis6263# Specify browser type64hindsight.exe -i "/path/to/profile" -o /output/analysis -b Chrome6566# JSON output format67hindsight.exe -i "C:\Evidence\Chrome\Default" -o C:\Output\chrome --format jsonl6869# With cache parsing (slower but more complete)70hindsight.exe -i "C:\Evidence\Chrome\Default" -o C:\Output\chrome --cache71```7273### Web UI7475```bash76# Start Hindsight web interface77hindsight_gui.exe78# Navigate to http://localhost:808079# Upload or point to browser profile directory80# Configure output format and analysis options81# Generate and download report82```8384## Artifact Analysis Details8586### URL History and Visits8788```sql89-- Chrome History database schema (key tables)90-- urls table: id, url, title, visit_count, typed_count, last_visit_time91-- visits table: id, url, visit_time, from_visit, transition, segment_id9293-- Timestamps are Chrome/WebKit format: microseconds since 1601-01-0194-- Convert: datetime((visit_time/1000000)-11644473600, 'unixepoch')95```9697### Download History9899```sql100-- downloads table: id, current_path, target_path, start_time, end_time,101-- received_bytes, total_bytes, state, danger_type, interrupt_reason,102-- url, referrer, tab_url, mime_type, original_mime_type103```104105### Cookie Analysis106107```sql108-- cookies table: creation_utc, host_key, name, value, encrypted_value,109-- path, expires_utc, is_secure, is_httponly, last_access_utc,110-- has_expires, is_persistent, priority, samesite111```112113## Python Analysis Script114115```python116import sqlite3117import os118import json119import sys120from datetime import datetime, timedelta121122123CHROME_EPOCH = datetime(1601, 1, 1)124125126def chrome_time_to_datetime(chrome_ts: int):127 """Convert Chrome timestamp to datetime."""128 if chrome_ts == 0:129 return None130 try:131 return CHROME_EPOCH + timedelta(microseconds=chrome_ts)132 except (OverflowError, OSError):133 return None134135136def analyze_chrome_history(profile_path: str, output_dir: str) -> dict:137 """Analyze Chrome History database for forensic evidence."""138 history_db = os.path.join(profile_path, "History")139 if not os.path.exists(history_db):140 return {"error": "History database not found"}141142 os.makedirs(output_dir, exist_ok=True)143 conn = sqlite3.connect(f"file:{history_db}?mode=ro", uri=True)144145 # URL visits with timestamps146 cursor = conn.cursor()147 cursor.execute("""148 SELECT u.url, u.title, v.visit_time, u.visit_count,149 v.transition & 0xFF as transition_type150 FROM visits v JOIN urls u ON v.url = u.id151 ORDER BY v.visit_time DESC LIMIT 5000152 """)153 visits = [{154 "url": r[0], "title": r[1],155 "visit_time": str(chrome_time_to_datetime(r[2])),156 "total_visits": r[3], "transition": r[4]157 } for r in cursor.fetchall()]158159 # Downloads160 cursor.execute("""161 SELECT target_path, tab_url, start_time, end_time,162 received_bytes, total_bytes, mime_type, state163 FROM downloads ORDER BY start_time DESC LIMIT 1000164 """)165 downloads = [{166 "path": r[0], "source_url": r[1],167 "start_time": str(chrome_time_to_datetime(r[2])),168 "end_time": str(chrome_time_to_datetime(r[3])),169 "received_bytes": r[4], "total_bytes": r[5],170 "mime_type": r[6], "state": r[7]171 } for r in cursor.fetchall()]172173 # Keyword searches174 cursor.execute("""175 SELECT k.term, u.url, k.url_id176 FROM keyword_search_terms k JOIN urls u ON k.url_id = u.id177 ORDER BY u.last_visit_time DESC LIMIT 1000178 """)179 searches = [{"term": r[0], "url": r[1]} for r in cursor.fetchall()]180181 conn.close()182183 report = {184 "analysis_timestamp": datetime.now().isoformat(),185 "profile_path": profile_path,186 "total_visits": len(visits),187 "total_downloads": len(downloads),188 "total_searches": len(searches),189 "visits": visits,190 "downloads": downloads,191 "searches": searches192 }193194 report_path = os.path.join(output_dir, "browser_forensics.json")195 with open(report_path, "w") as f:196 json.dump(report, f, indent=2)197198 return report199200201def main():202 if len(sys.argv) < 3:203 print("Usage: python process.py <chrome_profile_path> <output_dir>")204 sys.exit(1)205 analyze_chrome_history(sys.argv[1], sys.argv[2])206207208if __name__ == "__main__":209 main()210```211212## References213214- Hindsight GitHub: https://github.com/obsidianforensics/hindsight215- Chrome Forensics Guide: https://allenace.medium.com/hindsight-chrome-forensics-made-simple-425db99fa5ed216- Browser Forensics Tools: https://www.cyberforensicacademy.com/blog/browser-forensics-tools-how-to-extract-user-activity217- Chromium Source (History): https://source.chromium.org/chromium/chromium/src/+/main:components/history/