Hello Dieter,
You might be able to do this using a combination of tables RSZRANGE, RSZELTXREF and RSZCOMPDIR.
1. RSZRANGE - restrict on HIENM (Hierarhcy name) and it gives you the list of objects that use the hierarchy. Then download only the values of field ELTUID.
2. RSZELTXREF - use the values from RSZRANGE to populate the field TELTUID. When you run it, it will give you a list of the locations of the object i.e. query or structure.
3. RSZELTXREF - re-enter the values you have just downloaded into the TLTUID field again. Run it. (This will then give you a list of the queries that are using structures. Add these to the list you got from Step 2.
4. RSZCOMPDIR - enter the values from Step 2 and 3 into the COMPUID field, run it and you will get a list of the queries using the hierarchy.
Hope it helps.
Add a comment