...
| Code Block |
|---|
select * from grouper_sync gs, grouper_sync_group gsg where gs.provisioner_name = 'blah' and gs.id = gsg.grouper_sync_id and gsg.provisionable = 'T' |
Groups with provisioning assignments for a provisioner
Replace provisionerId with the ID of the provisioner
| Code Block |
|---|
select gaaagv.group_name, 'group' as owner_type from grouper_aval_asn_asn_group_v gaaagv
where gaaagv.attribute_def_name_name2 like '%etc:provisioning:provisioningTarget'
and gaaagv.value_string = 'provisionerId'
union all
select gaaasv.stem_name, 'stem' as owner_type from grouper_aval_asn_asn_stem_v gaaasv
where gaaasv.attribute_def_name_name2 like '%etc:provisioning:provisioningTarget'
and gaaasv.value_string = 'provisionerId' |
SQL loader membership queries
...