delete_data_in_the_database_directly_via_ssh
Table of Contents
Delete all scenario templates
sudo -u postgres psql phishing -c 'DELETE FROM scenario_templates'
Delete all Awareness template
sudo -u postgres psql phishing -c 'DELETE FROM awareness_templates'
Delete all templates files
sudo rm -rf /opt/phishing/files/scenario-templates/*
sudo rm -rf /opt/phishing/files/awareness-templates/*
Delete all endusers
sudo -u postgres psql phishing -c 'DELETE FROM users WHERE role_id=5'
Delete all LUCY users (not admin)
sudo -u postgres psql phishing -c 'DELETE FROM users WHERE role_id=3'
delete_data_in_the_database_directly_via_ssh.txt · Last modified: 2021/05/19 08:10 by lucy