SQL view -- values associated with an organisation unit

I’m working on an instance that has multiple orphaned OUs. I am wondering if there is a way to run an SQL view that will show me the list of orphans and associated data elements and periods with values so I can delete those values and then delete the OUs.

1 Like