Module 6 Web Related
Module 6 Web Related
LEARNING OBJECTIVES:
1
In this lesson, students will take part in lectures, hands-on exercises, instructor-led exercises, and student
practical exercises to gain an understanding of Web Browser related artifacts and the databases where those
browsers store their artifacts such as history, typed URLs, bookmarks, download activity, and cached files.
GOALS:
At the conclusion of this lesson, students will be able to identify, discuss, and utilize Magnet AXIOM to conduct
examinations of Web related artifacts. The student will also gain an understanding of how to utilize source linking
to gain access to the browser databases and the way AXIOM recovers artifacts from those ESE (Extensible Storage
Engine) and SQLite databases.
2
WEB RELATED ARTIFACTS CATEGORY
The category Web Related is typically one of the largest categories in AXIOM. This is due to the
extensive amount of time that people spend conducting online activities. Much of the information in
this category is parsed from multiple databases that are maintained by web browsers. AXIOM will
process information from the following for the category Web Related Artifacts:
The majority of web browsers store information in an SQLite database (IE and Edge being the
exception). Much of the information in this module will be related to information parsed from these
3
databases. The instructional materials will concentrate on the main web browsers currently in use:
1) Google Chrome, 2) Mozilla Firefox, 3) Microsoft Internet Explorer, and 4) Microsoft Edge.
Although we will discuss each of these browsers and associated artifacts in detail, this case does not
contain every type of artifact for every browser.
These results are included in the artifact categories of Refined Results and Web Related. The
information in Refined Results is compiled from the information in Web Related.
4
BROWSER ARTIFACT HIERARCHY
Because there are many different types of browser artifacts, it is important to have a workflow
while working through the artifacts. Each artifact displays different information within the
Evidence Pane. If one artifact does not have the data that an examiner is seeking, another
artifact may contain some of the data. Depending on the case, some web related artifacts may
be more important than others.
Some cases may find that they download of a specific program is key while other may be more
focused on what bookmarks are saved. Some investigations may focus more on the websites to
which a user has browsed or what information is in the web cache. In each case, the order of
operations in working through browser artifacts may change. Using the workflow depicted here
will allow you to be more efficient in locating relevant web browsing data.
GOOGLE CHROME
Google Chrome was first released in 2008 exclusively for use on Microsoft Windows. Since that
time, versions have been developed for macOS, iOS, Android, and Linux. Chrome is the most
popular browser in use and currently accounts for approximately 71% of the worldwide
browser market share.
5
CHROME BOOKMARKS (Chrome Shortcuts)
Bookmarks provide a means for the user to mark sites for which frequent and easy access is
desired. Every browser will have a means of creating these; they also provide a useful artifact
from an investigative standpoint. For Chrome, AXIOM parses these and populates the results in
the Artifact Category WEB RELATED > Chrome Shortcuts.
Chrome stores its bookmarks in a plain text file called “Bookmarks” and shortcuts in an SQLite
database, both located at:
Users\username\AppData\Local\ Google\Chrome\User Data\Default\
Attribute Description
6
FIGURE 6-6: CHROME BOOKMARK
CHROME COOKIES
Cookies are small files deposited onto a local browsing machine from visited websites. They can
store information about the user, browsing activity, and more. Cookies can be used to determine
that a user has visited a specific web site.
Chrome stores its cookies in an SQLite database named “Cookies” located at:
Users\username\AppData\Local\ Google\Chrome\User Data\Default\.
Attribute Description
7
Attribute Description
The following is an example of a cookie received by Google Chrome from the web site Amazon:
Google Analytics is a service offered by Google to provide a means for websites to track visitor
activity in a detailed manner. These cookies do not have to be related to the Google Chrome
browser. For example, Firefox and IE both maintain Google Analytics cookies.
These detailed cookies are used to determine the action of users more accurately, such as how they
got to a web site, where they came from, how long they were there, what pages they viewed, etc.
This type of information is used in Google’s business model to generate revenue.
AXIOM identifies cookies containing this information and compiles them under the Refined Results
artifact group. AXIOM also carves out Google Analytics cookies from other areas and will show
these carved items within the Web Related artifact group.
There are three types of Google Analytics Cookie information available. They are:
8
Attribute Description
2. SESSION COOKIES
Session Cookies track information regarding activity during a browsing session on a website.
These cookies are short-lived and will automatically expire (get deleted) if the visitor is idle for
30 minutes or longer. The fields tracked and parsed by AXIOM are:
Attribute Description
9
Attribute Description
In this example, the user visited the site for [Link], arriving on
8/27/2020 at 9:06:04 PM and viewing six pages.
3. REFERRAL COOKIES
These cookies indicate how a user navigated to a particular web site. This is
significant information as referrals to web sites generate are used in
advertising and generate a significant amount of revenue.
10
Attribute Description
Access Method Indicates whether the site was accessed organically or was referred.
Keyword The keywords used to arrive at the site.
Artifact The name of the artifact that the URL was discovered in.
Artifact ID The row ID of the URL in the original artifact table.
In the example above, the user visited the web site [Link]
using the web browser Mozilla Firefox. The Campaign is listed as ‘direct,’
which indicates that the user typed the URL directly into the web browser.
CHROME DOWNLOADS
Most browsers will track information regarding file downloads. AXIOM will show an artifact
category for download activity for the various browsers.
Chrome tracks download activity in the History file located at:
Users\username\AppData\Local\Google\Chrome\User Data\Default\
11
Attribute Description
CHROME HISTORY
Browsing History is one of the most important artifacts related to browser usage. It helps to
create a picture and pattern of user activity.
Chrome stores its browser history in an SQLite database named “History” located at:
12
There are multiple database tables which store history information used by AXIOM. AXIOM will list
two artifact categories to reflect this information – Chrome Web History (obtained from the table:
urls) and Chrome Web Visits (obtained from the table: visits). Each of these tables contains similar
information, with some differences.
AXIOM will show the following columns/fields for Chrome Web History:
Attribute Description
AXIOM will show the following columns/fields for Chrome Web Visits:
Attribute Description
13
Note: Because a value of 1 (user browsed) is by far the most common, it is
not stored in the database for efficiency’s sake and must be a given when no
value is present. AXIOM will not list any empty column data on the Details
card; if the Visit Source needs to be verified, the source link for the artifact
can be used to navigate to the History database > visit source table.
CHROME CACHE
Whenever a user visits a web site, information is automatically downloaded from the web site
to the user’s computer and saved in the Browser Cache. This information includes all code and
resources (scripts, pictures, etc.) that were used to render the web page on the user’s
computer. Each web browser maintains a cache file and AXIOM parses all these files.
When clicking on AXIOM Cache-related artifacts, AXIOM will attempt to render the cached file
or web page in the details pane:
Chrome has multiple locations for local caching of files. For each location, there will be a
corresponding index for the files. AXIOM will show in the Details card a source link for both the
index and the actual cached item. Files will be cached in the following locations, and each will
have a corresponding “index” file within it:
Users\username\AppData\Local\Google\Chrome\UserData\Default\Cache\
Users\username\AppData\Local\Google\Chrome\UserData\Default\GPUCache\
14
Users\username\AppData\Local\Google\Chrome\UserData\Default\Media Cache\
Files within these cache folders will have a naming convention of “data_xx and f_0000xx”.
AXIOM will show the following columns/fields for Chrome Cache Records:
Attribute Description
Typed URLS indicate when a URL has been typed (or copy/pasted) directly into the address bar
of the browser. The user doesn’t necessarily need to type the entire URL for it to be recorded as a
Typed URLs. As long as any portion of the URL is typed, the Typed Count is incremented for the
artifact. Chrome and Firefox both track this information within their browser history database
files. In both cases, a view of the browser history files in the Details Card of the Content Pane
will show the Typed URL status.
Chrome stores its Typed URLs within the History SQLite database located at:
15
• Users\username\AppData\Local\Google\Chrome\UserData\Default\
AXIOM displays the information in the Details pane for Chrome Web History and Chrome Web
Visits. The entry will show a number reflecting the number of times the URL has been typed.
CHROME AUTOFILL
Most browsers provide a means to store form information that would commonly be used
to fill out basic information on multiple websites, such as name, phone number, address,
etc.
Chrome stores its form data in an SQLite database named “Web Data” located at:
• Users\username\AppData\ Local\Google\Chrome\User Data\Default\
Information is stored in the table “autofill.” AXIOM will list the artifacts drawn from the Web
Data database in the Chrome Autofill artifact category. AXIOM will show the following
columns/fields for Chrome Autofill:
Attribute Description
Name The name of the autofill value.
Value The saved autofill value for this type of field.
Count The count of this autofill.
Date Created Date/Time - UTC The date and time that the autofill value was created.
(yyyy-mm-dd)
Last Used Date/Time - UTC The date and time that the autofill was last used.
(yyyy-mm-dd)
16
FIGURE 6-16: CHROME AUTOFILL
In this database, the Date Created refers to the first time that the autofill information was used.
Subsequent uses do not update this date/time. Therefore, if an entry has more than one Count,
we can determine when the first time was that it was autofilled and the total number of times
that it was autofilled, but not when those subsequent uses occurred.
Chrome Autofill Profiles contains a profile of all autofill information that Chrome uses to fill
in forms with saved values. Chrome also stores these data in an SQLite database named
“Web Data” located at:
• Users\username\AppData\ Local\Google\Chrome\User Data\Default\
Information is stored in multiple tables within the Web Data database. AXIOM will show the
following columns/fields for Chrome Autofill Profiles:
17
Attribute Description
Name The name for the autofill profile.
Email The email used in the autofill profile.
Number The phone number used in the autofill profile.
Company Th company name used in the autofill profile.
Address Line 1 The address Line 1 used in the autofill profile.
Address Line 2 The address Line 2 used in the autofill profile.
City The city used in the autofill profile.
State The state used in the autofill profile.
Zipcode The Zipcode used in the autofill profile.
Country The country used in the autofill profile.
Date Modified Date/Time - UTC (yyyy-mm-dd) The date and time that the profile was last modified.
CHROME LOGINS
Chrome Logins contains log in information that is collected when the user logs into a site using
Google Chrome. Among the information collected is the User Name, Password, Created Date/Time,
and URL. While the password is often encrypted, other information in Chrome Logins can
determine the specific sites that the user has been logging into along with the username that has
been used.
Attribute Description
URL The URL of the login page.
Username The username entered.
Password The password entered.
Created Date/Time - UTC (yyyy-mm-dd) The date and time that the data was created.
URL The URL of the web page being accessed with the
18
Attribute Description
credentials.
AXIOM will show the following columns/fields for Chrome Top Sites:
Attribute Description
URL The URL of the site.
Title The title of the site.
Last Updated The date and time when the site was last updated.
Date/Time - UTC
(yyyy-mm-dd)
Rank A ranking of the website, in terms of how frequently it was visited. A value of 1
indicates the most frequent and values increment to 8 as frequency decreases. A
value of -1 indicates a site that the user manually added to the list of top sites.
Thumbnail The thumbnail of the site.
MOZILLA FIREFOX
Mozilla Firefox, or simply Firefox, was first released in 2002. At the time, the browser
marketplace was dominated by Microsoft Internet Explorer. Firefox became popular due to its
speed and security. Within the first nine of months of release, Firefox was downloaded
19
approximately 60 million times. As of October 2019, Firefox has approximately 9.5% of the
worldwide browser market share.
FIREFOX BOOKMARKS
Firefox stores bookmarks in an SQLite database named “[Link]”, which also stores other
artifacts like history. The file is located at Users\username\AppData\Roaming\Mozilla\Firefox\
Profiles\[Link]\.
AXIOM pulls information from two tables within the database – moz_places and moz_bookmarks.
The following columns/fields will be shown:
Attribute Description
URL The URL of the website that was bookmarked.
Added Date/Time - UTC (yyyy-MM-dd) The date and time that the bookmark was created.
Last Modified Date/Time - UTC (yyyy-MM-dd) The date and time that the field was last modified.
Title The title of the bookmark.
Bookmark Type The type of bookmark (Bookmark Item or Bookmark Folder).
FIREFOX COOKIES
Firefox stores cookies in an SQLite database named “[Link]”. The file is located at:
Users\username\ AppData\Roaming\Mozilla\Firefox\Profiles\[Link]\
AXIOM pulls information from a table within the database, moz_cookies. The following
columns/fields will be shown:
Attribute Description
Host The host domain of the cookie.
Name The name of the cookie.
Value The value of the cookie.
Accessed Date/Time - UTC The date and time that the cookie was last accessed.
20
Attribute Description
(yyyy-MM-dd)
Created Date/Time - UTC The date and time when the cookie was created.
(yyyy-MM-dd)
Expiration Date/Time - UTC The date and time when the cookie will expire, if it is set to expire.
(yyyy-MM-dd)
Path The path to the cookie.
The following is an example of a cookie received by Firefox from the web site [Link]:
FIREFOX DOWNLOADS
Firefox tracks downloads in an SQLite database named “[Link]”, which also stores other
artifacts like history. The file is located at:
Users\username\AppData\Roaming\Mozilla\Firefox\Profiles\[Link]\
AXIOM pulls information from several tables within the database. The following columns/fields will
be shown:
Attribute Description
File Name The name of the file being downloaded.
21
Attribute Description
Download Source The URL of the file being downloaded.
Start Date/Time - The date and time when the download was started.
UTC (yyyy-MM-dd)
End Date/Time - The date and time when the download was ended.
UTC (yyyy-MM-dd)
Saved To The path to where the file was downloaded to.
Temp Path The path to where the file was saved during downloading.
State The state of the download can be Download In Progress, Download Complete,
Download Stopped, or Download Paused.
Referrer If the webpage used a mirror for downloading, this value is the path to the original
download URL.
Firefox stores its browser history in an SQLite database named “[Link]” located at:
• Users\username\AppData\Roaming\Mozilla\Firefox\Profiles\[Link]\
There are two database tables which store the history information used by AXIOM. Like Google
Chrome, AXIOM will list two artifact categories to reflect this information – Firefox Web History
and Firefox Web Visits. Web History keeps a record of unique web sites visited. Web Visits
keeps a record of the number of times a user visits a unique web site.
AXIOM will show the following columns/fields for Firefox Web History:
Attribute Description
URL The URL of the webpage.
Last Visited Date/Time - UTC (yyyy-MM-dd) The date and time that the webpage was last visited.
Title The title of the webpage.
Visit Count The number of times that the webpage has been visited.
Typed Indicates whether the user typed the URL (Yes or No).
22
FIGURE 6-23: FIREFOX WEB HISTORY
AXIOM will show the following columns/fields for Firefox Web Visits:
Attribute Description
URL The URL that was visited.
Title The title of the page that was visited.
Date Visited Date/Time - The date and time that the page was visited.
UTC (yyyy-mm-dd)
Typed Indicates whether the user typed the URL (Yes or No).
Transition Type Identifies how the transition to the page happened.
TRANSITION_LINK: User clicked on a link
TRANSITION_TYPED: User typed the URL into the address bar
TRANSITION_BOOKMARK: User clicked on a bookmark for the website
TRANSITION_EMBED: Content within a web page was load (this would include
imbedded images)
TRANSITION_REDIRECT_PERMANENT: Transition was a permanent redirect
TRANSITION_REDIRECT_TEMPORARY: Transition was a temporary redirect
TRANSITION_DOWNLOAD: A download link was clicked on
23
FIREFOX CACHE
Firefox stores cache files in a folder named “entries”. The folder is located at:
• Users\username\AppData\Roaming\Mozilla\Firefox\Profiles\[Link]\cache2\
entries
The index of the cached files is found in a file called “index”, found in the cache2 folder. AXIOM
will show the following columns/fields:
Attribute Description
URL The URL of the cached entry.
Created Date/Time - UTC (yyyy-mm-dd) The date and time that the cached entry was created.
MIME Type The MIME type of the cached data.
Content Size (Bytes) The content size of the cached data.
Image The image that should one be associated with the cached entry.
Content The content that should any be associated with the cached entry.
24
AXIOM displays this information under the artifact category Firefox Web History. Information will
indicate a “Yes” or “No” as to whether the URL has been typed into the address bar, as shown in
the following screen shot:
Attribute Description
Field Name The name of the field.
Value The value of the field.
First Used Date/Time - The date and time that the field was first used.
UTC (yyyy-MM-dd)
Last Used Date/Time - The date and time that the field was last used.
UTC (yyyy-MM-dd)
Times Used The number of times that the field has been used.
ID The unique ID of the field. A number which tells whether the entry was the first,
second, etc.., in the table.
25
FIGURE 6-27: FIREFOX AUTOFILL
Attribute Description
URL The URL of the bookmark.
Added Date/Time - UTC (yyyy-mm-dd) The date and time that the bookmark was added.
Name The name of the bookmark.
26
Attribute Description
Parent The name of the parent folder of the bookmark.
Type The type of bookmark.
Attribute Description
Favorite Name The name of the favorite as it shows up in Internet Explorer.
Modified Date/Time - UTC (yyyy- The last time that the user modified the favorite.
mm-dd)
User The user to whom the favorite belongs.
Favorites Root Location The local path that is the root storage point for the favorite.
Folder Structure The folder structure under which the favorite will show up
in Internet Explorer.
Icon URL The URL of the icon for the favorite if an icon does exist.
27
FIGURE 6-29: INTERNET EXPLORER FAVORITES
Attribute Description
Host The host that created the cookie.
Name The name of the cookie.
Accessed Date/Time - UTC (yyyy-mm-dd) The date and time the cookie was accessed.
Created Date/Time - UTC (yyyy-mm-dd) The date and time when the cookie was created.
Expiration Date/Time - UTC (yyyy-mm-dd) The date and time when the cookie expires.
28
The following fields are tracked in the database:
Attribute Description
Download Source The URL of the file that was downloaded.
File Name The file name of the download.
Start Time Date/Time - UTC (yyyy-mm-dd) The download start time.
End Time Date/Time - UTC (yyyy-mm-dd) The download end time.
Saved To The saved to location.
State The state of the download.
Opened By User Indicates whether the download is opened by the user.
Bytes Downloaded The bytes that were downloaded.
File Size (Bytes) The file size of the download.
Edge Chromium stores its browser history in an SQLite database named History located at:
• Users\username\AppData\Local\Microsoft\Edge\User Data\Default\History
There are two database tables which store the history information used by AXIOM. Like
Chrome and Firefox, AXIOM will list two artifact categories to reflect this information – Edge
Chromium Web History and Edge Chromium Web Visits. Web History keeps a record of unique
web sites visited. Web Visits keeps a record of the number of times a user visits a unique web
site.
AXIOM will show the following columns/fields for Edge Chromium Web History:
Attribute Description
URL The URL of the visited page.
Last Visited The date and time that the webpage was last visited.
Date/Time - UTC
(yyyy-mm-dd)
Title The title of the webpage that was visited.
Visit Count The number of times the webpage was visited. The value for this fragment is
interpreted to show the actual visit count. The source data starts counting at 0 (0
indicates a single visit occurred), whereas the value that is displayed here is the actual
visit count (1 indicates a single visit).
Typed Count This fragment is not populated for iOS.
29
FIGURE 6-32: EDGE CHROMIUM WEB HISTORY
AXIOM will show the following columns/fields for Edge Chromium Web Visits:
Attribute Description
URL The URL of the visited webpage.
Date Visited Date/Time - The date and time when the webpage was last visited.
UTC (yyyy-mm-dd)
Title The title of the webpage that was visited.
Typed Count The number of times that the website was accessed by the user typing the URL
(as opposed to clicking a link).
Transition Type Describes how the browser navigated to this URL. For example, if a user visits a
page by clicking a link on another page, the transition type is 'link'.
Visit Source The source of the visit.
_rawtime The hidden raw time.
Internet Explorer stores browser history in an Extensible Storage Engine (ESE) database named
“[Link].” Also known as Jet Blue, the ESE database is technology from Microsoft and is
at the core of several services, including Microsoft Exchange Server, Active Directory, and Windows
Search. The ESE database is located at:
30
Users\username\AppData\Local\microsoft\Windows\WebCache\
There are separate tables within the database for daily/Weekly History and Main History. Daily
History maintains the most recent 24 hours of history. Weekly history maintains the most recent
seven days of history. Main History maintains the entire history. AXIOM will show the following
columns/ fields for Internet Explorer 10-11 Daily/Weekly History and Internet Explorer 10-11 Main
History:
Attribute Description
As we saw in Refined Results, when a user navigates to a file using Windows Explorer and then
opens the file by double-clicking on it, this activity is recorded in the ESE database as a Locally
Accessed File with a URL beginning File:///. Therefore, it is common to see these entries in the
artifact categories related to Internet Explorer history.
Whenever a user visits a web site, information is automatically downloaded from the web site
to the user’s computer and saved in the Browser Cache. This information includes all code and
resources (scripts, pictures, etc.) that were used to render the web page on the user’s
computer. Each web browser maintains a cache file and AXIOM parses all these files.
31
When clicking on AXIOM Cache-related artifacts, AXIOM will attempt to render the cached file
or web page in the details pane:
Edge Chromium has multiple locations for local caching of files. For each location, there will be a
corresponding index for the files. AXIOM will show in the Details card a source link for both the
index and the actual cached item. Files will be cached in the following locations, and each will
have a corresponding “index” file within it:
Users\username\AppData\Local\Microsoft\Edge\User Data\Default\Cache\
Users\username\AppData\Local\Microsoft\Edge\UserData\Default\GPUCache\
Users\username\AppData\Local\Microsoft\Edge\UserData\Default\Media Cache\
Files within these cache folders will have a naming convention of “data_xx and f_0000xx”.
AXIOM will show the following columns/fields for Edge Chromium Cache Records:
Attribute Description
URL The URL of the cached item.
Last Visited Date/Time - UTC The date and time when the URL was last visited.
(yyyy-mm-dd)
First Visited Date/Time - UTC The date and time when the URL was first visited.
32
Attribute Description
(yyyy-mm-dd)
Last Sync Date/Time - UTC The date and time when the cache was last synced with the cloud.
(yyyy-mm-dd)
File Type The type of file that was cached.
Content Size (Bytes) The size of the cached file.
Image The cached image if the file type is an image. Otherwise, this column is
empty.
Content The cached file contents if the file type is not an image. Otherwise, this
column is empty.
Typed URLs indicate when a URL has been typed (or copy/pasted) directly into the address bar
of the browser. The user doesn’t necessarily need to type the entire URL for it to be recorded as a
Typed URLs. As long as any portion of the URL is typed, the Typed Count is incremented for the
artifact. Edge Chromium tracks this information within the browser history database files and
Typed URLs are displayed in the Edge Chromium Web History and Edge Chromium Web Visits
artifact categories.
Edge Chromium stores its Typed URLS within the History SQLite database located at:
• Users\username\AppData\Local\Microsoft\Edge\User Data\Default\
AXIOM displays the information in the Details pane for Edge Chromium Web History and Edge
Chromium Web Visits. The entry will show a number reflecting the number of times the URL has
been typed.
33
Profiles is listed as <Encrypted Data> in Artifact Explorer:
Upon viewing the data in File System Explorer, it can be seen that the data is not encrypted and that
the values can be viewed.
FIGURE 6-39: EDGE CHROMIUM AUTOFILL AND AUTOFILL PROFILES (FILE SYSTEM
EXPLORER)
SEARCH DATA
Searches executed on a search engine website or locally within a dedicated search box will often
be of investigative interest. Search engine queries will normally include the search term itself
embedded in the URL. AXIOM Examine will group these search URLs within either Google Search
Queries or Parsed Search Queries under Refined Results. Some browsers will also store these
search queries separately in dedicated structures.
34
FIGURE 6-40: SEARCH URL USING “q=”
35
FIGURE 6-42: FIREFOX SEARCHBAR HISTORY SEARCHES
AXIOM will show the following columns/fields for WebKit Browser Web History (Carved) Records:
Attribute Description
URL The URL of the visited webpage.
Title The title of the visited webpage.
Last Visited Date/Time - UTC The date and time that this webpage was last visited.
(yyyy-mm-dd)
Visit Count The number of times that the webpage was visited.
Typed Count The number of times that the website was accessed by the user typing the
URL (as opposed to clicking a link).
36
FIGURE 6-43: WEBKIT BROWSER WEB HISTORY (CARVED)
37