BusinessObjects Board

Who changed group membership?

Is there a way to track and report on changes to group membership and folder permissions?
I have full Auditing enabled.

Thanks!!
Mike


mikefraser :us: (BOB member since 2008-05-12)

Assuming BOBJ 4.x, for permissions, you would look in ADS_EVENT for records with the Event_Type_ID 10003 (rights modification).

For user group assignments, I’m not sure of the exact details, but you would link ADS_EVENT to ADS_OBJECT_TYPE_STR on Object_Type_ID from both tables and ADS_OBJECT_TYPE_STR.Language = ‘EN’ then filter on ADS_OBJECT_TYPE_STR.Object_Type_Name in (‘User’, ‘UserGroup’) and then link from ADS_EVENT to ADS_EVENT_DETAIL and look for a detail that would indicate a user group change. The Event_Detail_Type_ID values you want to look at are 65 - User Group Details, 16 - User Group ID, 15 - User Group Name.

-Dell


hilfy :us: (BOB member since 2007-04-16)