delete_data_in_the_database_directly_via_ssh
This is an old revision of the document!
Table of Contents
Delete all "deleted campaigns" from database
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
sudo -u postgres psql phishing -c "DELETE FROM scenario_templates WHERE NOT is_deleted"
Delete all Awareness template
sudo -u postgres psql phishing -c "DELETE FROM awareness_templates WHERE NOT is_deleted"
Delete all file templates
sudo rm -rf /opt/phishing/files/scenario-templates/* sudo rm -rf /opt/phishing/files/awareness-templates/*
Delete all endusers
sudo -u postgres psql phishing UPDATE users SET is_deleted=true WHERE NOT is_deleted AND role_id=5; \q
Delete all LUCY users (not admin)
sudo -u postgres psql phishing -c "UPDATE users SET is_deleted=TRUE where role_id=3"
delete_data_in_the_database_directly_via_ssh.1525723050.txt.gz · Last modified: 2019/07/25 12:50 (external edit)