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 ParentChildOrgs

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