X-Git-Url: http://git.equinoxoli.org/?p=migration-tools.git;a=blobdiff_plain;f=remove_ou_data%2FREADME;h=cbb2cb43d88aaf6ed557371785a2386bc984052f;hp=c740409c18ccf1426b392856e003ef7f622a2676;hb=0f04d792ca52ef7a8c91853046c476b3b5daf37f;hpb=c919228a7234c1fdfa9f9cfbae245fc30731eb85 diff --git a/remove_ou_data/README b/remove_ou_data/README index c740409..cbb2cb4 100644 --- a/remove_ou_data/README +++ b/remove_ou_data/README @@ -3,18 +3,9 @@ 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. TODO: -- remove event output that is no longer associated with any events --- remvoe user address auditor entries