Tracking Group Membership Changes Without Enabling Table Auditing

[attanhes]

What’s the best way to track who adds or removes users from groups (sys_user_grmember) without enabling audits on this many to many table?

[SANDEEP DUTTA · Accepted solution]

Hi @attanhes ,

I know you don't want to use Audit but that's the best way and recommended one to check sys_audit table for sys_user_grmember table.

However, if you don't want to use it, then you can go for a business rule on the table Group Members   (sys_user_grmember) on after condition 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().

Click on image for full image.

Reference : https://www.servicenow.com/community/developer-forum/how-to-check-who-added-or-removed-group-member-...

[attanhes]

Thank you Sandeep