SELECT
br.name AS it_or_business_role_name,
br.type AS it_or_business_role_type,
it.name AS org_role_name,
it.type AS org_type
FROM identityiq.spt_bundle_children c
JOIN identityiq.spt_bundle it ON it.id = c.child
JOIN identityiq.spt_bundle br ON br.id = c.bundle
WHERE
it.name = 'Pedia - IT - DPA Role';
=================================================================
import java.util.ArrayList;
import java.util.List;
import sailpoint.api.SailPointContext;
import sailpoint.object.Bundle;
import sailpoint.object.Filter;
import sailpoint.object.QueryOptions;
import sailpoint.tools.GeneralException;
private static List getRolesBasedOnContainer(String container) {
List aList = null;
QueryOptions qo = null;
try {
aList = new ArrayList();
qo = new QueryOptions();
qo.add(Filter.eq("inheritance.name", container));
List<Bundle> objects = context.getObjects(Bundle.class, qo);
for (Bundle bundle : objects) {
aList.add(bundle.getName());
}
} catch (GeneralException e) {
System.out.println("GeneralException : " + e.getMessage());
}
return aList;
}
String container = "Pedia - IT - DPA Role";
List bundles = getRolesBasedOnContainer(container);