delete_data_in_the_database_directly_via_ssh
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
delete_data_in_the_database_directly_via_ssh [2018/05/07 21:58] – lucy | delete_data_in_the_database_directly_via_ssh [2021/05/19 08:10] (current) – [Delete all templates files] lucy | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== Delete all " | ||
- | sudo -u postgres psql phishing | ||
- | delete from exports where campaign_id in (select id from campaigns where is_deleted=true); | ||
- | delete from campaigns where is_deleted=true; | ||
- | |||
- | |||
===== Delete all scenario templates ===== | ===== Delete all scenario templates ===== | ||
- | sudo -u postgres psql phishing -c ' | + | sudo -u postgres psql phishing -c ' |
===== Delete all Awareness template ===== | ===== Delete all Awareness template ===== | ||
- | sudo -u postgres psql phishing -c ' | + | sudo -u postgres psql phishing -c ' |
+ | |||
+ | ===== Delete all templates files ===== | ||
- | ===== Delete all file templates ===== | ||
sudo rm -rf / | sudo rm -rf / | ||
+ | |||
sudo rm -rf / | sudo rm -rf / | ||
===== Delete all endusers ===== | ===== Delete all endusers ===== | ||
- | sudo -u postgres psql phishing | + | sudo -u postgres psql phishing |
- | UPDATE | + | |
- | \q | + | |
===== Delete all LUCY users (not admin) ===== | ===== Delete all LUCY users (not admin) ===== | ||
- | sudo -u postgres psql phishing -c 'UPDATE | + | sudo -u postgres psql phishing -c 'DELETE FROM users WHERE role_id=3' |
delete_data_in_the_database_directly_via_ssh.1525723127.txt.gz · Last modified: 2019/07/25 12:51 (external edit)