Thunderbird forensic

De Linuxmemo.

(Différences entre les versions)
(Page créée avec « Catégorie:Forensic global-messages.db.sqlite »)
Ligne 1 : Ligne 1 :
[[Catégorie:Forensic]]
[[Catégorie:Forensic]]
-
global-messages.db.sqlite
+
==global-messages.db.sqlite==
 +
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id;
 +
 
 +
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND contacs.name LIKE '%bank%';
 +
 
 +
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND contacts.name LIKE 'BEA';

Version du 7 janvier 2021 à 12:42

global-messages.db.sqlite

SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id;
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND contacs.name LIKE '%bank%';
SELECT contacts.name, identities.value FROM contacts, identities WHERE contacts.id=identities.id AND contacts.name LIKE 'BEA';
Outils personnels