News We Recently Launched AD Migrator and AD Reporter.

Mozilla Firefox History Viewer
to Read Places .Sqlite

Mozilla Firefox History Viewer

If a user spends his time on internet, it means for that period of time, he is continuously using a web browser. These browsers have provided a richer web experience and are designed in such a way that whatever a user does on net-opening a website, submitting information, login details etc. takes place within the browser only. This is the reason, many unhoped-for cases are resolved through the artifacts collected from web browsers.

One of the widely used web browsers across the world is Mozilla Firefox. It is an open source platform which is used on Windows, Linux, and OS X. Every activity performed within the web browser is recorded in a database that is stored locally. Mozilla Firefox heavily utilizes SQLite DB and stores most of the browser history: cache, visited websites (along with dates), cookies, downloads etc. into it. SQLite database is a single disk file that either gets saved with .db or .sqlite file extension.

Amongst the various databases recording Firefox activities, the places.sqlite file have the maximum number of artifacts stored in it. This database is a bit complex and has multi-table schema. However, there are certain tables in the SQLite DB that can help to extract the best and helpful information for the case. The URLs that have been visited and at what point of time are two primary concerns of the forensics experts.

Download Now

How to Find the Places.sqlite File?

To find the places.sqlite file, users need to execute 3 to 4 simple steps as mentioned below.

Step-1. They just need to Open Mozilla Firefox Browser, & Go to the Profile section. Then Click on the Help button.

Moz Place

Step-2. Now, Click on the More Troubleshooting Information option to proceed.

Moz Place

Step-3. Here, in this screen, Click on the Open Folder button next to the Public Folder option.

Moz Place

Step-4. Here, users can see that the folder on the system opens up where the Places.sqlite file is visible.

Moz Place

Check SQLite Moz_places, Moz_Historyvisits and Moz_Bookmarks with Places.sqlite Viewer

Step-1. Launch the Software & Click on the Add File option.

Moz Place

Step-2. Now, Browse & Add places.sqlite file here & Click on Add option.

Moz Place

Moz_places

This table contains list of all the URLS that have been visited by the accused. Corresponding to every URL, a unique ID is created and this ID corresponds to the places_ID in the moz_historyvsists table.

Moz Place

Moz_historyvisits

The place_id here corresponds to the ID filed in the moz_places table.

Moz history Visits

Moz_Bookmarks

Bookmarks is one of finest source to find out the interest of the accused. The URLs that are bookmarked can be checked out in this table and the URL can be known through the ID that corresponds to the moz_places table.

Moz Bookmarks

All this information stored in SQLite database can be checked out through free Mozilla Firefox History Viewer program. The software enables analyzing the Firefox history saved in places.sqlite database on any Windows platform. More than that, related browser info like cookies, downloads etc. saved into SQLite can be viewed within the software interface.