Grouper Training - Administration - Lesson: Membership reports

Getting started

Members to add to locked_by_ciso

aadams
jadams3
badams
dadams

Report name

factStaffLockedOut

Description

employees locked out

Filename

employeesLockedOut_$$timestamp$$.csv

Viewers group

etc:sysadmingroup

Quartz cron

0 * * * * ?

Report query

select gmlv1.subject_id from grouper_memberships_lw_v gmlv1 where gmlv1.list_name = 'members' and gmlv1.group_name = 'ref:security:locked_by_ciso' and gmlv1.member_id in (select gmlv2.member_id from grouper_memberships_lw_v gmlv2 where gmlv2.list_name = gmlv1.list_name and gmlv2.group_name = 'ref:role:all_facstaff')