Sqlite Forensics Tool – Know How It Works!


STEP 1

Click on Start > All Programs > Sqlite Forensic Explorer. To Launch the Sqlite Forensic Explorer from the installed location

Install Software
STEP 2

Now, Click on Add File button to add Sqlite file and start analyzing.

Add SQLite File
STEP 3

A pop-up box will appear, from there Browse and select the file type: either Sqlite File or Journal File.

File Options
STEP 4

Now, find Sqlite file followed by clicking on Browse button.

SQLite File
STEP 5

Select the particular Sqlite file and click on add button and let start the scanning proccess.

Note: same procedure will apply for journal file.

Browse File
STEP 6

In the left pane of the window you can see the moduls of selected Sqlite file in a tree structure and at the right pane you can see the preview of Sqlite file under the tabular bar.

Tabular Bar of Software
STEP 7

Hex tab lets you analyze the data in binary file format. The record bar shows the detail of the message.

Binary Format
STEP 8

The hex view also shows the page properties In ascending or descending order.

page properties
STEP 9

The Sqlite Forensics explorer provides the color schema that you can use to analyze the data in binary format.

Color Pattern
STEP 10

If you need to select the folder, which is required to export then you can do the same using the Export button.

Export Records
STEP 11

Export option allows to select either all export options such as Active Records, Deleted Records and All Media Files or desired one.

export option
STEP 12

Now, select the file type like CSV or PDF to export desired records as per your need.

CSV PDF
STEP 13

User can choose the destination location to export the files and then click on Save button.

Browse and Save File
STEP 14

An alert pop up box will open "Exported Successfully" after successfully completion of export.

Export Complete
STEP 15

Now, to inquire the items exported using Sqlite Forensic Explorer.

Go to the location where the PDF file located in your machine as shown below:

PDF
STEP 16

Now you can opne the PDF file using Adobe Acrobat Reader to view and analyze it.

view PDF file
STEP 17

Now to open the CSV, move to the location where CSV files located in your machine.

Export in CSV File
STEP 18

To open the file in CSV format double click on it.

Analyze CSV File
STEP 19

Now to analyze the schema of particular table, only you neeed to hover the cursor under the table properties.

Schema
STEP20

The Sqlite Forensic Explorer provide the symbol option to export the schema into PDF or CSV.

Export Schema