Organization Units Migration

When upgrading your existing Orchestrator where multiple Organization Units were defined to v2019.10, certain conditions could result in the existing OU's not being properly migrated to the Folders paradigm. Specifically, this occurs when an OU with one or more assigned users is deleted and results in those users being unable to use Orchestrator.

Two scripts are provided to correct this issue if it occurs in your Orchestrator upgrade:

• SelectUndeletedUserOrganizationEntires.sql
• DeleteAffectedUserOrganizationUnitsEntries.sql

Used in conjunction, this will delete any affected User to Organization Unit assignments for deleted OU's:

1. Download both scripts from the links above.
2. Run SelectUndeletedUserOrganizationEntires.sql and save the resulting data.
3. Run DeleteAffectedUserOrganizationUnitsEntries.sql.