Report on Group members being added or removed from groups (date)

[V_31]

Hi All,

I need to create a report which shows in a list view of who has been added or removed from a group (in date format)

I have tried to utilise the "sys_audit" table and have checked the the "Audit" box for the below dictionary entries but it only shows audits for people that are removed from groups.

sys_user_grmember
sys_user_grmember group
sys_user_grmember user

Also having the group name show as a unique id is not very helpful for the customer, can i show the name instead?

If this is not the correct way to generate the data, please let point me in the right direction.

As always, any input is much appreciated.

Kind regards

[Deepak Ingale1]

Hi,

One thing you can do is probably create a report on "sys_audit_role" table.

This table stores information whenever a person has been granted role or is revoked role, both directly or via group

However, this may not give you information about the group which does not have any role

Note : Please mark reply as correct if it has answered your orignal question or mark it as helpful if it has been helpful to you

[V_31]

Hi Deepak,

Thanks for the response but I do not need to know when roles have been added/removed from groups.

I need to know when a user has been added or removed from a group.

Do you have any suggestions for this?

again, much appreciated.

[Deepak Ingale1]

There is nothing much OOB then, you have to create something custom by your own then.

[V_31]

I thought as much but struggling to create a script to capture that date when a user was removed from the group.

Can you provide any guidance?

So far i have created a "Removed" (date/time) field and think i need to do something like the below.

1. create "before" business rule on the "Sys_audit" table

2. script that queries the above table for the created date/time

3. gliderecord on the "sys_user_grmember" table to copy Created time to "Removed" field on grmember table.

Please let me know if this makes sense and if so, can you help with the script?

Kind regards