How Can I Automatically Identify and Delete Childless Hierarchy Items?
I have a constantly shifting hierarchy in place which consists of 8 levels, level 1 (top) through level 8 (bottom). Within this hierarchy it's necessary to delete members of L7 when they have no L8 members which roll up to them. This scenario plays out regularly as L8 members are often realigned to roll up under different parents.
My Question: Is there some way to automate the identification and deletion of L7 members which don't have children? If I could run an action to clean the hierarchy it'd save me a meaningful amount of time pruning my hierarchy.