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';