X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=remove_ou_data%2FREADME;h=cbb2cb43d88aaf6ed557371785a2386bc984052f;hp=00d2bf3f45e10a3d9c13fd4659c2a7e84fc6c239;hb=0f04d792ca52ef7a8c91853046c476b3b5daf37f;hpb=06e695c596e784a9e2634b25612b4bd23ac047af diff --git a/remove_ou_data/README b/remove_ou_data/README index 00d2bf3..cbb2cb4 100644 --- a/remove_ou_data/README +++ b/remove_ou_data/README @@ -3,14 +3,6 @@ remove data belonging to an OU and its descendants in an Evergreen 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.