Grouper Users - Open Discussion List

[Chris Hyzer <>]

Try something like this (substitute in the sourceId and subjectId:

select *
from grouper_audit_entry_v, grouper_members gm
where string04 = gm.ID
and label_string04 = 'memberId'
and audit_category = 'membership'
and gm.SUBJECT_SOURCE = 'sourceId'
and gm.SUBJECT_ID = 'subjectId'

Chris

-----Original Message-----
From: It Meme 
[mailto:]
 
Sent: Tuesday, May 03, 2011 4:39 PM
To: Chris Hyzer
Subject: Re: [grouper-users] Membership Audit

Hi Chris:

Thank your for your email.

Is there a SQL query whereby I can run a membership audit on a person?

Thanks.

regards,

Hari

On Tue, May 3, 2011 at 12:40 PM, Chris Hyzer 
<>
 wrote:
> You can select from a SQL view for auditing information...
>
> select *
> from grouper_audit_entry_v
> where string07 = 'some:group:name'
> and audit_category = 'membership'
>
> Note this is only for direct actions taken against the group, not for 
> effective changes due to other groups.  For that data you will need 
> PointInTime audit information in 2.0 :)
>
> Thanks,
> Chris
>
> -----Original Message-----
> From: 
> 
>  
> [mailto:]
>  On Behalf Of It Meme
> Sent: Tuesday, May 03, 2011 2:28 PM
> To: 
> 
> Subject: [grouper-users] Membership Audit
>
> Hi:
>
> Does anyone have the SQL query to generate the default 'Membership
> Audit' that ships with Grouper1.6? Or can point me to where I can
> review it in the Subversion repository.
>
> Cheers.
>