...
| Code Block |
|---|
select GS.NAME folder_name, 'T' as admin_exists, gg.name as group_name, GMLV.SUBJECT_ID from grouper_stems gs, grouper_groups gg, grouper_memberships_lw_v gmlv where GS.NAME like 'some:folder%' and GMLV.GROUP_ID(+) = GG.ID and GMLV.SUBJECT_SOURCE(+) = 'somesourceid' and GMLV.LIST_NAME(+) = 'members' and GG.PARENT_STEM = GS.ID and gg.extension = 'admin' union select GS.NAME folder_name, 'F' as admin_exists, null as group_name, null as subject_id from grouper_stems gs where GS.NAME like 'some:folder%' and not exists ( select 1 from grouper_groups gg where GG.PARENT_STEM = GS.ID and gg.extension = 'admin' ); |
Membership additions to a group that happened yesterday
Note: adjust the subject source and group name
| Code Block |
|---|
select * from grouper_pit_mship_group_lw_v gpmgv where gpmgv.group_name = 'test:someGroup2' and gpmgv.subject_source = 'jdbc' and gpmgv.the_end_time is null and gpmgv.the_start_time /1000000 > extract (epoch from date_trunc('day', current_date - Integer '1')) and gpmgv.the_start_time /1000000 < extract (epoch from date_trunc('day', current_date)) |
"Full sync" / "Full check" reportingÂ
...