Parent Child Orgs Report¶
This script runs from the Main Reports Menu if added to the Menu (Special Content > Text > Custom Reports Menu). It shows any organization that is either a parent or child of another organization.
The recommended name is
Use the following code to Create the SQL Script. See How to create a SQL Script.
SELECT ParentOrgId = p.OrganizationId ,ParentOrg = p.OrganizationName ,ChildOrgId = c.OrganizationId ,ChildOrg = c.OrganizationName FROM dbo.Organizations c JOIN dbo.Organizations p ON p.OrganizationId = c.ParentOrgId ORDER BY ParentOrg, ChildOrg