Difference between pages "Websites" and "Google Chrome"

From ForensicsWiki
(Difference between pages)
Jump to: navigation, search
 
(Disk Cache)
 
Line 1: Line 1:
'''Websites''' about [[digital forensics]] and related topics.
+
Google Chrome is a [[Web Browser|web browser]] developed by Google Inc.
  
= Digital Forensics =
+
== Configuration ==
; Bruce Nikkel's Computer Forensics Homepage
+
The Google Chrome configuration can be found in the '''Preferences''' file.
: [http://digitalforensics.ch/ Bruce Nikkel's Computer Forensics Homepage]
+
: Presentations, links, references
+
  
; Digital Forensic Solution Provider Website
+
On Linux
: [http://forensicpeople.com/ Forensic People Website]
+
<pre>
 +
/home/$USER/.config/google-chrome/Default/Preferences
 +
</pre>
  
; Certfied Computer Examiner Website
+
On MacOS-X
: [http://www.isfce.com/ Certfied Computer Examiner Website]
+
<pre>
: Open certification process for digital forensics.
+
/Users/$USER/Library/Application Support/Google/Chrome/Default/Preferences
 +
</pre>
  
; Computer Forensics Tool Testing (CFTT) project
+
On Windows XP
: [http://www.cftt.nist.gov/ Computer Forensics Tool Testing project]
+
<pre>
: The Computer Forensic Tool Testing (CFTT) project establishes methodologies for testing computer forensic tools by development of general tool specifications, test procedures, test criteria, test sets, and test hardware.
+
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Google\Chrome\User Data\Default\Preferences
 +
</pre>
  
; Computer Forensics and Investigations
+
On Windows Vista and later
: [http://computer-forensics-lab.org/ project “COMPUTER FORENSICS AND INVESTIGATIONS”]
+
<pre>
: Computer Forensics articles, and website of Igor Michailov
+
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\Default\Preferences
 +
</pre>
  
; Computer Forensics Tool Catalog
+
Or for '''Chrome SxS''' (Chrome side-by-side)
: [http://www.cftt.nist.gov/tool_catalog/ Computer Forensics Tool Catalog]
+
: The Computer Forensics Tool Catalog provides an easily searchable catalog of forensic tools to enable practitioners to find tools that meet their specific technical needs.
+
  
; Computer Forensics World
+
<pre>
: http://www.computerforensicsworld.com/
+
C:\Users\%USERNAME%\AppData\Local\Google\Chrome SxS\User Data\Default\Preferences
: Website with online discussion forums relating to computer forensics.
+
</pre>
  
; [[Cyberspeak podcast]]
+
Or for '''Chromium'''
: [http://cyberspeak.libsyn.com/ Cyberspeak Podcast]
+
: Computer forensics, network security, and computer crime podcast.
+
  
; Digital Forensics Discussion Forum
+
On Linux
: [http://www.multimediaforensics.com/ Digital Forensics Discussion Forum]
+
<pre>
: A forum for the discussion of computer and digital forensics examinations, certified and non-certified investigators welcome
+
/home/$USER/.config/chromium/Default/Preferences
 +
</pre>
  
; Digital Forensic Research Workshop (DFRWS)
+
On MacOS-X
: [http://www.dfrws.org/ Official Website for Digital Forensic Research Workshop]
+
<pre>
: Open forum for research in digital forensic issues, hosting annual meeting and annual forensics challenge.
+
/Users/$USER/Library/Application Support/Chromium/Default/Preferences
 +
</pre>
  
; E-Evidence Information Centre
+
On Windows XP
: [http://www.e-evidence.info/ E-Evidence Information Centre]
+
<pre>
: An online digital forensics bibliography, updated monthly
+
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Chromium\User Data\Default\Preferences
 +
</pre>
  
; FCCU GNU/Linux Forensic Boot CD
+
On Windows Vista and later
: [http://www.lnx4n6.be/ Belgian Computer Forensic Website]
+
<pre>
: Belgian Computer Forensic Website - Forensic Boot CD  - Linux
+
C:\Users\%USERNAME%\AppData\Local\Chromium\User Data\Default\Preferences
 +
</pre>
  
; Forensic Focus
+
=== Plugins ===
: http://www.forensicfocus.com/
+
: News, blog, forums, and other resources for folks engaged in or interested in digital forensics.
+
  
; International Association of Computer Investigative Specialists
+
Information about plugins can be found under the "plugins section" of the Preferences file.
: [http://www.iacis.info/ International Association of Computer Investigative Specialists]
+
: Volunteer non-profit corporation composed of law enforcement professionals.
+
  
; Litilaw Computer Forensics
+
=== DNS Prefetching ===
: [http://computer-forensics-litilaw.lexbe.com/ Litilaw Computer Forensics]
+
: Computer forensics article collection.
+
  
; MySecured.com
+
DNS is prefetched for related sites, e.g. links on the page.
: [http://www.MySecured.com/ MySecured.com]
+
This behavior is controlled by the setting "Predict network actions to improve page load performance", which is enabled by default.
: Mobile phone forensics, cellphone related investigation and data analysis site.
+
  
; NIST: Secure Hashing
+
If enabled the Preferences file contains:
: [http://csrc.nist.gov/CryptoToolkit/tkhash.html NIST: Secure Hashing]
+
<pre>
: The Computer Security Division's (CSD) Security Technology Group (STG) is involved in the development, maintenance, and promotion of a number of standards and guidance that cover a wide range of cryptographic technology.
+
  "dns_prefetching": {
 +
      "enabled": true,
 +
</pre>
  
; National Software Reference Library (NSRL)
+
If disabled the Preferences file contains:
: [http://www.nsrl.nist.gov/ National Software Reference Library]
+
<pre>
: The National Software Reference Library (NSRL) collects software from various sources and incorporates file profiles computed from this software into a Reference Data Set (RDS) of information.
+
  "dns_prefetching": {
 +
      "enabled": false,
 +
</pre>
  
; Open Source Digital Forensics
+
== Start-up DNS queries ==
: [http://www.opensourceforensics.org  “OpenSourceForensics.org”]
+
: The Open Source Digital Forensics site is a reference for the use of open source software in digital investigations (a.k.a. digital forensics, computer forensics, incident response).
+
  
; [University of Delaware]  Computer Forensics Lab
+
When Chrome starts it queries for several non-existing hostnames that consists of a 10 random characters, E.g.
: [http://128.175.24.251/forensics/default.htm University of Delaware]
+
<pre>
: Computer Forensics Lab Resource Site.
+
ttrgoiknff.mydomain.com
 +
bxjhgftsyu.mydomain.com
 +
yokjbjiagd.mydomain.com
 +
</pre>
  
; [University of Rhode Island]  Digital Forensics Center
+
This is used to determine if your ISP is hijacking NXDOMAIN results [http://www.google.com/support/forum/p/Chrome/thread?tid=3511015c72a7b314&hl=en].
: [http://dfc.cs.uri.edu/ University of Rhode Island]  
+
: Computer Forensics Lab Resource Site.
+
  
; Forensics Sciences Conference and Exhibition
+
== Disk Cache ==
: [http://http://euroforensics.com/]Euroforensics
+
Google Chrome uses multiple caches, from [http://src.chromium.org/viewvc/chrome/trunk/src/net/base/cache_type.h?view=markup]:
 +
<pre>
 +
// The types of caches that can be created.
 +
enum CacheType {
 +
    DISK_CACHE,  // Disk is used as the backing storage.
 +
    MEMORY_CACHE,  // Data is stored only in memory.
 +
    MEDIA_CACHE,  // Optimized to handle media files.
 +
    APP_CACHE,  // Backing store for an AppCache.
 +
    SHADER_CACHE, // Backing store for the GL shader cache.
 +
    PNACL_CACHE, // Backing store the PNaCl translation cache
 +
};
 +
</pre>
  
= Non-Digital Forensics =
+
<b>Note that $PROFILE (or %PROFILE%) the paths below is the profile dependent subdirectory which is normally Default but also could be Profile1, Profile2, etc.</b>
; NIST Image Group
+
: [http://fingerprint.nist.gov/ NIST Image Group]
+
: Many reports, including the [[NIST]] report on [[AFIS]] [[fingerprint]] testing.
+
  
= Wikis =
+
The Google Chrome disk cache can be found in:
; Forensics Wiki (Russian Language)
+
: [http://www.computer-forensics-lab.org/wiki/ Forensics Wiki in Russian]
+
  
= [[Blogs]] =
+
On Linux
  
= [[Journals]] =
+
<pre>
 +
/home/$USER/.cache/chromium/$PROFILE/Cache/
 +
/home/$USER/.cache/google-chrome/$PROFILE/Cache/
 +
/home/$USER/.config/chromium/$PROFILE/Cache/
 +
/home/$USER/.config/google-chrome/$PROFILE/Cache/
 +
</pre>
 +
 
 +
<pre>
 +
/home/$USER/.cache/chromium/$PROFILE/Media Cache/
 +
/home/$USER/.cache/google-chrome/$PROFILE/Media Cache/
 +
/home/$USER/.config/chromium/$PROFILE/Media Cache/
 +
/home/$USER/.config/google-chrome/$PROFILE/Media Cache/
 +
</pre>
 +
 
 +
<pre>
 +
/home/$USER/.config/chromium/$PROFILE/Application Cache/Cache/
 +
/home/$USER/.config/google-chrome/$PROFILE/Application Cache/Cache/
 +
</pre>
 +
 
 +
<pre>
 +
/home/$USER/.config/chromium/$PROFILE/GPUCache/
 +
/home/$USER/.config/google-chrome/$PROFILE/GPUCache/
 +
</pre>
 +
 
 +
<pre>
 +
/home/$USER/.cache/chromium/PnaclTranslationCache/
 +
/home/$USER/.cache/google-chrome/PnaclTranslationCache/
 +
</pre>
 +
 
 +
On MacOS-X
 +
<pre>
 +
/Users/$USER/Library/Caches/Chromium/$PROFILE/Cache
 +
/Users/$USER/Library/Caches/Google/Chrome/$PROFILE/Cache
 +
</pre>
 +
 
 +
<b>TODO confirm the following paths</b>
 +
<pre>
 +
/Users/$USER/Caches/Chromium/$PROFILE/Cache/
 +
/Users/$USER/Caches/Google/Chrome/$PROFILE/Cache/
 +
</pre>
 +
 
 +
<pre>
 +
/Users/$USER/Library/Caches/Chromium/$PROFILE/Media Cache
 +
/Users/$USER/Library/Caches/Google/Chrome/$PROFILE/Media Cache
 +
</pre>
 +
 
 +
<pre>
 +
/Users/$USER/Library/Application Support/Chromium/$PROFILE/Application Cache/Cache/
 +
/Users/$USER/Library/Application Support/Google/Chrome/$PROFILE/Application Cache/Cache/
 +
</pre>
 +
 
 +
<pre>
 +
/Users/$USER/Library/Application Support/Chromium/$PROFILE/GPUCache/
 +
/Users/$USER/Library/Application Support/Google/Chrome/$PROFILE/GPUCache/
 +
</pre>
 +
 
 +
<pre>
 +
/Users/$USER/Library/Caches/Chromium/PnaclTranslationCache/
 +
/Users/$USER/Library/Caches/Google/Chrome/PnaclTranslationCache/
 +
</pre>
 +
 
 +
On Windows XP
 +
 
 +
<b>TODO confirm the following paths</b>
 +
<pre>
 +
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Chromium\User Data\Cache\
 +
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Google\Chrome\User Data\Cache\
 +
</pre>
 +
 
 +
On Windows Vista and later
 +
<pre>
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Cache\
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Cache\
 +
</pre>
 +
 
 +
<pre>
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Application Cache\Cache\
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Application Cache\Cache\
 +
</pre>
 +
 
 +
<pre>
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Media Cache\
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Media Cache\
 +
</pre>
 +
 
 +
<pre>
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\GPUCache\
 +
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\GPUCache\
 +
</pre>
 +
 
 +
The Chrome Cache contains different files with the following file names:
 +
* index
 +
* data_#; where # contains a decimal digit.
 +
* f_######; where # contains a hexadecimal digit.
 +
 
 +
For more info see [[Chrome Disk Cache Format]].
 +
 
 +
== History ==
 +
Chrome stores the history of visited sites in a file named '''History'''. This file uses the [[SQLite database format]].
 +
 
 +
The '''History''' file can be found in same location as the '''Preferences''' file.
 +
 
 +
There is also '''Archived History''' that predates information in the '''History''' file.
 +
Note that the '''Archived History''' only contains visits.
 +
 
 +
=== Timestamps ===
 +
The '''History''' file uses the different timestamps.
 +
 
 +
==== visits.visit_time ====
 +
 
 +
The '''visits.visit_time''' is in (the number of) microseconds since January 1, 1601 UTC
 +
 
 +
Some Python code to do the conversion into human readable format:
 +
<pre>
 +
date_string = datetime.datetime( 1601, 1, 1 )
 +
            + datetime.timedelta( microseconds=timestamp )
 +
</pre>
 +
 
 +
Note that this timestamp is not the same as a Windows filetime which is (the number of) 100 nanoseconds since January 1, 1601 UTC
 +
 
 +
==== downloads.start_time ====
 +
 
 +
The '''downloads.start_time''' is in (the number of) seconds since January 1, 1970 UTC
 +
 
 +
Some Python code to do the conversion into human readable format:
 +
<pre>
 +
date_string = datetime.datetime( 1970, 1, 1 )
 +
            + datetime.timedelta( seconds=timestamp )
 +
</pre>
 +
 
 +
=== Example queries ===
 +
Some example queries:
 +
 
 +
To get an overview of the visited sites:
 +
<pre>
 +
SELECT datetime(((visits.visit_time/1000000)-11644473600), "unixepoch"), urls.url, urls.title FROM urls, visits WHERE urls.id = visits.url;
 +
</pre>
 +
 
 +
Note that the visit_time conversion looses precision.
 +
 
 +
To get an overview of the downloaded files:
 +
<pre>
 +
SELECT datetime(downloads.start_time, "unixepoch"), downloads.url, downloads.full_path, downloads.received_bytes, downloads.total_bytes FROM downloads;
 +
</pre>
 +
 
 +
How the information of the downloaded files is stored in the database can vary per version of Chrome as of version 26:
 +
<pre>
 +
SELECT datetime(((downloads.start_time/1000000)-11644473600), "unixepoch"), downloads.target_path, downloads_url_chains.url, downloads.received_bytes, downloads.total_bytes \
 +
FROM downloads, downloads_url_chains WHERE downloads.id = downloads_url_chains.id;
 +
</pre>
 +
 
 +
== Cookies ==
 +
Chrome stores the cookies in a file named '''Cookies'''. This file uses the [[SQLite database format]].
 +
 
 +
=== Extension Cookies ===
 +
Chrome stores the cookies used by extensions in a file named '''Extension Cookies'''. This file uses the [[SQLite database format]].
 +
 
 +
<pre>
 +
SELECT datetime(((cookies.creation_utc/1000000)-11644473600), "unixepoch"), cookies.host_key, cookies.name, cookies.value, cookies.path, \
 +
datetime(((cookies.expires_utc/1000000)-11644473600), "unixepoch"), cookies.secure, cookies.httponly, datetime(((cookies.last_access_utc/1000000)-11644473600), "unixepoch"), \
 +
cookies.has_expires, cookies.persistent, cookies.priority FROM cookies;
 +
</pre>
 +
 
 +
== See Also ==
 +
 
 +
* [[SQLite database format]]
 +
 
 +
== External Links ==
 +
* [http://en.wikipedia.org/wiki/Google_Chrome Wikipedia article on Google Chrome]
 +
* [http://www.chromium.org/user-experience/user-data-directory The Chromium Projects - User Data Directory]
 +
* [http://www.chromium.org/developers/design-documents/network-stack/disk-cache Chrome Disk Cache]
 +
* [http://www.google.com/support/forum/p/Chrome/thread?tid=3511015c72a7b314&hl=en Chrome support forum article random 10 character hostnames on startup]
 +
* [http://www.useragentstring.com/pages/Chrome/ Chrome User Agent strings]
 +
* [http://computer-forensics.sans.org/blog/2010/01/21/google-chrome-forensics/ Google Chrome Forensics] by [[Kristinn Guðjónsson]], January 21, 2010
 +
* [http://linuxsleuthing.blogspot.ch/2013/02/cashing-in-on-google-chrome-cache.html?m=1 Cashing in on the Google Chrome Cache], [[John Lehr]], February 24, 2013
 +
* [http://www.obsidianforensics.com/blog/history-index-files-removed-from-chrome/ History Index files removed from Chrome v30], by Ryan Benson, October 2, 2013
 +
* [https://hindsight-internet-history.googlecode.com/files/Evolution_of_Chrome_Databases.png Evolution of Chrome Databases], by Ryan Benson, November 12, 2013
 +
 
 +
== Tools ==
 +
=== Open Source ===
 +
* [https://code.google.com/p/hindsight-internet-history/ hindsight-internet-history]
 +
 
 +
[[Category:Applications]]
 +
[[Category:Web Browsers]]

Revision as of 03:42, 22 June 2014

Google Chrome is a web browser developed by Google Inc.

Configuration

The Google Chrome configuration can be found in the Preferences file.

On Linux

/home/$USER/.config/google-chrome/Default/Preferences

On MacOS-X

/Users/$USER/Library/Application Support/Google/Chrome/Default/Preferences

On Windows XP

C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Google\Chrome\User Data\Default\Preferences

On Windows Vista and later

C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\Default\Preferences

Or for Chrome SxS (Chrome side-by-side)

C:\Users\%USERNAME%\AppData\Local\Google\Chrome SxS\User Data\Default\Preferences

Or for Chromium

On Linux

/home/$USER/.config/chromium/Default/Preferences

On MacOS-X

/Users/$USER/Library/Application Support/Chromium/Default/Preferences

On Windows XP

C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Chromium\User Data\Default\Preferences

On Windows Vista and later

C:\Users\%USERNAME%\AppData\Local\Chromium\User Data\Default\Preferences

Plugins

Information about plugins can be found under the "plugins section" of the Preferences file.

DNS Prefetching

DNS is prefetched for related sites, e.g. links on the page. This behavior is controlled by the setting "Predict network actions to improve page load performance", which is enabled by default.

If enabled the Preferences file contains:

   "dns_prefetching": {
      "enabled": true,

If disabled the Preferences file contains:

   "dns_prefetching": {
      "enabled": false,

Start-up DNS queries

When Chrome starts it queries for several non-existing hostnames that consists of a 10 random characters, E.g.

ttrgoiknff.mydomain.com
bxjhgftsyu.mydomain.com
yokjbjiagd.mydomain.com

This is used to determine if your ISP is hijacking NXDOMAIN results [1].

Disk Cache

Google Chrome uses multiple caches, from [2]:

// The types of caches that can be created.
enum CacheType {
    DISK_CACHE,  // Disk is used as the backing storage.
    MEMORY_CACHE,  // Data is stored only in memory.
    MEDIA_CACHE,  // Optimized to handle media files.
    APP_CACHE,  // Backing store for an AppCache.
    SHADER_CACHE, // Backing store for the GL shader cache.
    PNACL_CACHE, // Backing store the PNaCl translation cache
};

Note that $PROFILE (or %PROFILE%) the paths below is the profile dependent subdirectory which is normally Default but also could be Profile1, Profile2, etc.

The Google Chrome disk cache can be found in:

On Linux

/home/$USER/.cache/chromium/$PROFILE/Cache/
/home/$USER/.cache/google-chrome/$PROFILE/Cache/
/home/$USER/.config/chromium/$PROFILE/Cache/
/home/$USER/.config/google-chrome/$PROFILE/Cache/
/home/$USER/.cache/chromium/$PROFILE/Media Cache/
/home/$USER/.cache/google-chrome/$PROFILE/Media Cache/
/home/$USER/.config/chromium/$PROFILE/Media Cache/
/home/$USER/.config/google-chrome/$PROFILE/Media Cache/
/home/$USER/.config/chromium/$PROFILE/Application Cache/Cache/
/home/$USER/.config/google-chrome/$PROFILE/Application Cache/Cache/
/home/$USER/.config/chromium/$PROFILE/GPUCache/
/home/$USER/.config/google-chrome/$PROFILE/GPUCache/
/home/$USER/.cache/chromium/PnaclTranslationCache/
/home/$USER/.cache/google-chrome/PnaclTranslationCache/

On MacOS-X

/Users/$USER/Library/Caches/Chromium/$PROFILE/Cache
/Users/$USER/Library/Caches/Google/Chrome/$PROFILE/Cache

TODO confirm the following paths

/Users/$USER/Caches/Chromium/$PROFILE/Cache/
/Users/$USER/Caches/Google/Chrome/$PROFILE/Cache/
/Users/$USER/Library/Caches/Chromium/$PROFILE/Media Cache
/Users/$USER/Library/Caches/Google/Chrome/$PROFILE/Media Cache
/Users/$USER/Library/Application Support/Chromium/$PROFILE/Application Cache/Cache/
/Users/$USER/Library/Application Support/Google/Chrome/$PROFILE/Application Cache/Cache/
/Users/$USER/Library/Application Support/Chromium/$PROFILE/GPUCache/
/Users/$USER/Library/Application Support/Google/Chrome/$PROFILE/GPUCache/
/Users/$USER/Library/Caches/Chromium/PnaclTranslationCache/
/Users/$USER/Library/Caches/Google/Chrome/PnaclTranslationCache/

On Windows XP

TODO confirm the following paths

C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Chromium\User Data\Cache\
C:\Documents and Settings\%USERNAME%\Local Settings\Application Data\Google\Chrome\User Data\Cache\

On Windows Vista and later

C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Application Cache\Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Application Cache\Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\Media Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\Media Cache\
C:\Users\%USERNAME%\AppData\Local\Google\Chromium\%PROFILE%\GPUCache\
C:\Users\%USERNAME%\AppData\Local\Google\Chrome\User Data\%PROFILE%\GPUCache\

The Chrome Cache contains different files with the following file names:

  • index
  • data_#; where # contains a decimal digit.
  • f_######; where # contains a hexadecimal digit.

For more info see Chrome Disk Cache Format.

History

Chrome stores the history of visited sites in a file named History. This file uses the SQLite database format.

The History file can be found in same location as the Preferences file.

There is also Archived History that predates information in the History file. Note that the Archived History only contains visits.

Timestamps

The History file uses the different timestamps.

visits.visit_time

The visits.visit_time is in (the number of) microseconds since January 1, 1601 UTC

Some Python code to do the conversion into human readable format:

date_string = datetime.datetime( 1601, 1, 1 )
            + datetime.timedelta( microseconds=timestamp )

Note that this timestamp is not the same as a Windows filetime which is (the number of) 100 nanoseconds since January 1, 1601 UTC

downloads.start_time

The downloads.start_time is in (the number of) seconds since January 1, 1970 UTC

Some Python code to do the conversion into human readable format:

date_string = datetime.datetime( 1970, 1, 1 )
            + datetime.timedelta( seconds=timestamp )

Example queries

Some example queries:

To get an overview of the visited sites:

SELECT datetime(((visits.visit_time/1000000)-11644473600), "unixepoch"), urls.url, urls.title FROM urls, visits WHERE urls.id = visits.url;

Note that the visit_time conversion looses precision.

To get an overview of the downloaded files:

SELECT datetime(downloads.start_time, "unixepoch"), downloads.url, downloads.full_path, downloads.received_bytes, downloads.total_bytes FROM downloads;

How the information of the downloaded files is stored in the database can vary per version of Chrome as of version 26:

SELECT datetime(((downloads.start_time/1000000)-11644473600), "unixepoch"), downloads.target_path, downloads_url_chains.url, downloads.received_bytes, downloads.total_bytes \
FROM downloads, downloads_url_chains WHERE downloads.id = downloads_url_chains.id;

Cookies

Chrome stores the cookies in a file named Cookies. This file uses the SQLite database format.

Extension Cookies

Chrome stores the cookies used by extensions in a file named Extension Cookies. This file uses the SQLite database format.

SELECT datetime(((cookies.creation_utc/1000000)-11644473600), "unixepoch"), cookies.host_key, cookies.name, cookies.value, cookies.path, \
datetime(((cookies.expires_utc/1000000)-11644473600), "unixepoch"), cookies.secure, cookies.httponly, datetime(((cookies.last_access_utc/1000000)-11644473600), "unixepoch"), \
cookies.has_expires, cookies.persistent, cookies.priority FROM cookies;

See Also

External Links

Tools

Open Source