database. Each script uses a variable called ou_to_del that should
be set to the shortname of the OU to remove.
-Generate script to delete users:
-
-SELECT 'DELETE FROM actor.usr WHERE id = ' || id || ';'
-FROM actor.usr WHERE home_ou IN (
- SELECT (actor.org_unit_descendants(id)).id FROM actor.org_unit
- WHERE shortname = 'EXAMPLE'
-);
-
After running through the scripts, it should be possible to
remove the actor.org_unit entries themselves.
TODO:
+-- remove some reporter folders/reports/schedules
-- remove event output that is no longer associated with any events
--- remvoe user address auditor entries