Skip to Content.
Sympa Menu

grouper-users - RE: [grouper-users] Membership Audit

Subject: Grouper Users - Open Discussion List

List archive

RE: [grouper-users] Membership Audit


Chronological Thread 
  • From: Chris Hyzer <>
  • To: It Meme <>
  • Cc: "" <>
  • Subject: RE: [grouper-users] Membership Audit
  • Date: Tue, 3 May 2011 17:14:24 -0400
  • Accept-language: en-US
  • Acceptlanguage: en-US

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.
>



Archive powered by MHonArc 2.6.16.

Top of Page