SQLITE FORENSIC REPORTER TEMPLATES

The power of SQLite Forensic Reporter is contained within individual user templates, each template contains instructions how it should identify, decode and present a SQLite database. The identification can be either broad (file header) downto scalpel like precision identifying specific tables within a specific database. Once a SQLite database is identified a user can specify in the template how information is decoded using a built-in decoding routines and presented using powerful SQL queries.

This is a list of current templates included with SQLite Forensic Reporter:

Adobe Acrobat Reader Messages Data - v1.0.tdb
Adobe Related Data (pcd.db) - v1.0.tdb
Adobe Software Related Data - v1.0.tdb
Android Footprints - v1.0.tdb
Android mmssms_bk.db - v1.0.tdb
Ask Search Engine Toolbar - v1.0.tdb
Avast Log.db - v1.0.tdb
Avast URL.db - v1.0.tdb
Comodo Firewall Logs - v1.0.tdb
CyberLink Power Producer (1.0.0.1302) - v1.0.tdb
DivX Player Software Data - v1.0.tdb
DivX Player Software Font Data - v1.0.tdb
DivX Player Software Hardware Data - v1.0.tdb
DivX Player Software Related Data - v1.0.tdb
DivX Player Software Related Play List Data - v1.0.tdb
DropBox config.db - v1.0.tdb
DropBox filecache.db - v1.0.tdb
DropBox sigstore.db - v1.0.tdb
eBuddy (v1) - v1.0.tdb
eBuddy - v1.0.tdb
Elisa Media Database - v1.0.tdb
FileCure Software Related File Types - v1.0.tdb
FileCure Software Related History - v1.0.tdb
FileCure Software Related Ignore List - v1.0.tdb
Flixster - v1.0.tdb
Generic Word Suggestion DB - v1.0.tdb
Google Analytics - v1.0.tdb
Google App Engine Data (ape.db) - v1.0.tdb
Google App Engine Data (unknown) - v1.0.tdb
Google Chrome Archived History - v1.0.tdb
Google Chrome Cookies - v1.0.tdb
Google Chrome Network Action Predictor Data - v1.0.tdb
Google Chrome QuotaManager - v1.0.tdb
Google Chrome Shortcuts - v1.0.tdb
Google Chrome Top Sites - v1.0.tdb
Google Search History - v1.0.tdb
Intelli-studio File_v20_5.db - v1.0.tdb
Intelli-studio Folder_v20_5.db - v1.0.tdb
iPhone Call History - v1.0.tdb
iPhone Emails (v10) - v1.0.tdb
iPhone Emails (v18) - v1.0.tdb
iPhone Notes (v1) - v1.0.tdb
iPhone Photos - v1.0.tdb
iPhone Recordings (v1) - v1.0.tdb
iPhone SMSSearchdb - v1.0.tdb
iTranslate2 (v1.1) - v1.0.tdb
iTunes Backup (events) Game Data - v1.0.tdb
iTunes Backup (Feint) Game Data - v1.0.tdb
iTunes Backup (gameState) Game Data - v1.0.tdb
iTunes Backup (gameState) Game Data 2 - v1.0.tdb
iTunes Backup (greystripedb) Game Data - v1.0.tdb
iTunes Backup (Hashes) Game Data - v1.0.tdb
iTunes Backup (PGCommonDatabase) Game Data - v1.0.tdb
iTunes Backup (PGCommonDatabase) Game Data 2 - v1.0.tdb
iTunes Backup (private_user) Game Data - v1.0.tdb
iTunes Backup (recovery) Game Data - v1.0.tdb
iTunes Backup (RedBall) Game Data - v1.0.tdb
iTunes Backup (RedBall2GameState) Game Data - v1.0.tdb
iTunes Backup (rms) Game Data - v1.0.tdb
iTunes Backup (savedGames) Game Data - v1.0.tdb
iTunes Backup (settings) Game Data - v1.0.tdb
iTunes Backup (shaker) Game Data - v1.0.tdb
iTunes Backup (store) Game Data - v1.0.tdb
iTunes Backup (StoryTime) Game Data - v1.0.tdb
iTunes Backup (survivor) Game Data - v1.0.tdb
iTunes Backup (tapmall) Game Data - v1.0.tdb
iTunes Backup (water-Lite) Game Data - v1.0.tdb
iTunes Backup Account Data - v1.0.tdb
iTunes Backup Address Book - v1.0.tdb
iTunes Backup Address Book Data - v1.0.tdb
iTunes Backup Apple Help Data - v1.0.tdb
iTunes Backup Apple User Dictionary - v1.0.tdb
iTunes Backup Apsalar Data - v1.0.tdb
iTunes Backup Arsenal App Data - v1.0.tdb
iTunes Backup ASOS Clothing App Data - v1.0.tdb
iTunes Backup Aurasma Lite Entertainment App Data - v1.0.tdb
iTunes Backup AuxPhoto Data - v1.0.tdb
iTunes Backup BBC iPlayer Data - v1.0.tdb
iTunes Backup BBC News App Data - v1.0.tdb
iTunes Backup Big Oven Cooking App Data - v1.0.tdb
iTunes Backup Birthday Meaning App Data - v1.0.tdb
iTunes Backup Bookmarks App Data - v1.0.tdb
iTunes Backup Bookmarks Data - v1.0.tdb
iTunes Backup Brain Trainer App Data - v1.0.tdb
iTunes Backup Calendar Alarm Data - v1.0.tdb
iTunes Backup Calendar Data - v1.0.tdb
iTunes Backup Calendar Data 2 - v1.0.tdb
iTunes Backup Call History - v1.0.tdb
iTunes Backup Camera+ App Data - v1.0.tdb
iTunes Backup Channel 4 TV OD App Data - v1.0.tdb
iTunes Backup Consolidated.db Data - v1.0.tdb
iTunes Backup Cookies - v1.0.tdb
iTunes Backup Databases.db Data - v1.0.tdb
iTunes Backup Download Related Data - v1.0.tdb
iTunes Backup Driving Test Success App Data - v1.0.tdb
iTunes Backup EasyJet App Data - v1.0.tdb
iTunes Backup Family Quest App Data - v1.0.tdb
iTunes Backup Fantasy Football App Data - v1.0.tdb
iTunes Backup Featured Apps Data - v1.0.tdb
iTunes Backup Forum Runner App Data - v1.0.tdb
iTunes Backup Global Radio App Data - v1.0.tdb
iTunes Backup Google Analytics Data - v1.0.tdb
iTunes Backup Google Analytics Data 2 - v1.0.tdb
iTunes Backup Google Mail Data - v1.0.tdb
iTunes Backup Google Maps Mobile Data - v1.0.tdb
iTunes Backup Google Maps Mobile Search Data - v1.0.tdb
iTunes Backup Google Plus App Data - v1.0.tdb
iTunes Backup Google Translate App Data - v1.0.tdb
iTunes Backup Guardian News App Data - v1.0.tdb
iTunes Backup Gyro Calibration (gyroCal.db) - v1.0.tdb
iTunes Backup iBooks Annotation - v1.0.tdb
iTunes Backup iBooks App Data - v1.0.tdb
iTunes Backup IMDB App Data - v1.0.tdb
iTunes Backup IMDB App Data 2 - v1.0.tdb
iTunes Backup Infinity Quest Game Data - v1.0.tdb
iTunes Backup iRoast Cooking App Data - v1.0.tdb
iTunes Backup ItemTable Data - v1.0.tdb
iTunes Backup keyval.db - v1.0.tdb
iTunes Backup KGBDeals App Data - v1.0.tdb
iTunes Backup Layar App Data - v1.0.tdb
iTunes Backup LINE Messenger Data - v1.0.tdb
iTunes Backup LinkedIn App Data - v1.0.tdb
iTunes Backup LinkedIn Related Data - v1.0.tdb
iTunes Backup Living Social App Data - v1.0.tdb
iTunes Backup MapMyRun App Data - v1.0.tdb
iTunes Backup Media Lets Ad Cache Data - v1.0.tdb
iTunes Backup Media Lets Ad Tracking Data - v1.0.tdb
iTunes Backup Media Lets Close Button Cache Data - v1.0.tdb
iTunes Backup Message Data - v1.0.tdb
iTunes Backup Metro News Phone Ed. Data - v1.0.tdb
iTunes Backup Millionaire Game Data - v1.0.tdb
iTunes Backup Muslim Pro App Data - v1.0.tdb
iTunes Backup My Vue Cinema App Data - v1.0.tdb
iTunes Backup National Lottery App Data - v1.0.tdb
iTunes Backup Nectar Loyalty Card App Data - v1.0.tdb
iTunes Backup Nectar Loyalty Card App Data 2 - v1.0.tdb
iTunes Backup Notes Data - v1.0.tdb
iTunes Backup Olive Toast App Data - v1.0.tdb
iTunes Backup Olive Toast Cloud App Data - v1.0.tdb
iTunes Backup ooVoo Video Chat App Data - v1.0.tdb
iTunes Backup Photos Data - v1.0.tdb
iTunes Backup Picture Related Data - v1.0.tdb
iTunes Backup Qibla Direction App Data - v1.0.tdb
iTunes Backup QR Reader Core Data - v1.0.tdb
iTunes Backup QR Reader Data - v1.0.tdb
iTunes Backup RailEasy App Data - v1.0.tdb
iTunes Backup Recordings Info - v1.0.tdb
iTunes Backup Right Move Property App Data - v1.0.tdb
iTunes Backup Scalars Data - v1.0.tdb
iTunes Backup Shazam Music App Data - v1.0.tdb
iTunes Backup Skava Spanish for Dummies Data - v1.0.tdb
iTunes Backup Skobbler GPS Navigation App Data - v1.0.tdb
iTunes Backup Sky Go TV App Data - v1.0.tdb
iTunes Backup Sky Movies App Data - v1.0.tdb
iTunes Backup Skype App Data (bistats.db) - v1.0.tdb
iTunes Backup Skype App Data (msn.db) - v1.0.tdb
iTunes Backup Skype Data (main.db) - v1.0.tdb
iTunes Backup Skype Temp DB App Data - v1.0.tdb
iTunes Backup Skyscanner App Data - v1.0.tdb
iTunes Backup Skyscanner Travel App Data - v1.0.tdb
iTunes Backup SMS Data - v1.0.tdb
iTunes Backup Sound Cloud App Data - v1.0.tdb
iTunes Backup Store Data - v1.0.tdb
iTunes Backup Table Finder Restaurant App Data - v1.0.tdb
iTunes Backup The Independent News App Data - v1.0.tdb
iTunes Backup Thumbnail Cache Data - v1.0.tdb
iTunes Backup Tracking Data - v1.0.tdb
iTunes Backup Trainline Stations App Data - v1.0.tdb
iTunes Backup Trainline Time Tables App Data - v1.0.tdb
iTunes Backup Twitter Data - v1.0.tdb
iTunes Backup UAAnalyticsDB App Data - v1.0.tdb
iTunes Backup Unknown (TrustStore) App Data - v1.0.tdb
iTunes Backup Unknown Sports Related - v1.0.tdb
iTunes Backup Unknown System Related Data - v1.0.tdb
iTunes Backup Viber Contacts Data - v1.0.tdb
iTunes Backup VoiceMail Data - v1.0.tdb
iTunes Backup Voucher Cloud App Data - v1.0.tdb
iTunes Backup Voucher Codes App Data - v1.0.tdb
iTunes Backup WebAppCache Data - v1.0.tdb
iTunes Backup WhatsApp App Data - v1.0.tdb
iTunes Backup Yahoo Mail Data - 1.0.tdb
iTunes Backup Yahoo Messenger App Data - v1.0.tdb
iTunes Library.itdb (items only) - v1.0.tdb
iTunes Locations.itdb - v1.0.tdb
Kontiki - v1.0.tdb
Mozilla addons.sqlite - v1.0.tdb
Mozilla downloads.sqlite - v1.0.tdb
Mozilla extensions.sqlite - v1.0.tdb
Mozilla Firefox content-prefs.sqlite - v1.0.tdb
Mozilla Firefox Cookies - v1.0.tdb
Mozilla formhistory.sqlite - v1.0.tdb
Mozilla formhistory.sqlite - v1.1.tdb
Mozilla Permissions File - v1.0.tdb
Mozilla places.sqlite - v1.0.tdb
Mozilla search.sqlite - v1.0.tdb
Mozilla signons.sqlite - v1.0.tdb
Nectar Card Data - v1.0.tdb
Nero Feeds.db - v1.0.tdb
Nero is2.db Database - v1.0.tdb
Nero MediaHub.1.db - v1.0.tdb
Nero Software Related Data - v1.0.tdb
Nero Software Related Install Data - v1.0.tdb
Nero Software Related Uninstall Data - v1.0.tdb
NewzToolz File Decoder Encoder (Newsgroups Tool) - v1.0.tdb
Nimbuzz Messenger (v1) - v1.0.tdb
Nimbuzz Messenger - v1.0.tdb
Nokia PC Suite Mobile Phone Backup (Merged Contacts) - v1.0.tdb
Nokia PC Suite Mobile Phone Backup (with SMS) - v1.1.tdb
Nokia PC Suite Mobile Phone Backup - v1.0.tdb
Online Polish TV iplabase.sqlite - v1.0.tdb
Peer Guardian2 History - v1.0.tdb
PhotoBox - v1.0.tdb
Picasa Explorer - v1.0.tdb
Raptr Chat History - v1.0.tdb
Realplayer (Android) - v1.0.tdb
Safari Bookmarks.db - v1.0.tdb
Safari Cache.db (v10) - v1.0.tdb
Samsung Kies Mobile Phone Software Data - v1.0.tdb
Samsung Kies Mobile Phone Software Device Data - v1.0.tdb
Skype main.db (All tables) - v1.0.tdb
Skype main.db (Calls Only) - v1.0.tdb
Skype main.db (Chats Only) - v1.0.tdb
Skype main.db (Messages Only) - v1.0.tdb
Skype main.db (SMS Only) - v1.0.tdb
Skype main.db (Transfers Only) - v1.0.tdb
Skype main.db (Videos Only) - v1.0.tdb
Skype main.db (Voicemail Only) - v1.0.tdb
SopCast P2P Internet TV - v1.0.tdb
Spyware Doctor FileCache - v1.0.tdb
StreetCar - v1.0.tdb
Titanium Gears geolocation.db Data - v1.0.tdb
Tonium Pacemaker Playlist Information - v1.0.tdb
Truphone (v48) - v1.0.tdb
Truphone (v49) - v1.0.tdb
TVU Networks Multimedia Data - v1.0.tdb
Vopium Phone Software - v1.0.tdb
Whats App Message Store - v1.0.tdb
Whats App Messenger Chat (Blackberry) - v1.0.tdb
Whats App Messenger Chat (iPhone) - v1.0.tdb
Whats App Messenger Chat with Group Data (iPhone) - v1.0.tdb
Yahoo Messenger (0.94) - v1.0.tdb

Templates are ideal in situations where two databases are almost identical but differ slightly in structure therefore requiring slightly different processing to extract the data correctly.

SQLite Forensic Reporter templates can also be modified as and when database designs change. Once a template is created it can be added to the list of existing templates for reuse in future processing and shared with colleagues.