How to check who added or removed group member to/from group?

swathigangadhar
Tera Expert

‎07-10-2017 12:46 AM

How to check who added or removed group member to/from group?

Many i times we come across a situation, where a person is removed from his group or added to another group which is not part of his work. How to know who did the changes?

0 Helpfuls
  • 11,479 Views
6 REPLIES 6

sbrnag
Mega Expert

‎07-10-2017 02:13 AM

Hi Swathi,



    Create a business rule on the table Group Members   (sys_user_grmember) on after conditioning with insert and delete options enabled. In the script, you can log or save in some audit table with the details changed (added or removed) group for which user and who has done. For getting the current user gs.getUser().



Example code.


Click on image for full image.


find_real_file.png



Thanks,


Nag.


Preview file
194 KB

iagruthijonnaga
Giga Contributor

‎06-28-2018 04:55 AM

Hello Swathigangadhar,

 

You can find the recored in "sys_audit_delete" table in xml section with user name deleted and from which group user is deleted,

 

and to know weather user is deleted from group by you can check sys_auidt table.

 

0 Helpfuls