Removal of group

Nisha Mishra23
Tera Contributor

Is there any way we can find out who removed a particular user from a particular group?

2 ACCEPTED SOLUTIONS

aniket_hadron
Giga Expert

Go to System Definition > Deleted Records

Search for sys_user_grmember in table name

Identify the deleted record using  "Record Deleted" field which records the data when the data is delete 

Deleted user information is available in payload field. You need to open the record and check the JSON data for the user name.

View solution in original post

Robbie
Kilo Patron
Kilo Patron

Hi @Nisha Mishra23,

 

One way to confirm this is to view the 'Deleted Records' (By simply typing 'Deleted Records' into the navigation menu) 

Under the table filter, type 'sys_user_grmember'. (As shown below - this will filter all deleted records against the Group Membership table). 

Additionally configure the columns so you can see the 'updated by', 'created by' as well as the 'payload' fields - again as shown below.

From here you can edit the query by either entering the sys_id of the user who was deleted (recommended as the sys_id is unique) or you can add the users name etc 

 

Screenshot 2024-03-04 at 10.59.11.png 

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

 

Thanks, Robbie

View solution in original post

3 REPLIES 3

swathisarang98
Giga Sage
Giga Sage

Hi @Nisha Mishra23 ,

 

You can bring Activities from the form layout in sys_user_group table which will have all these changes captured.

Right Click on Group Record -> Configure ->Form Layout 

bring Activities(filtered) to right side of slush bucket save it

swathisarang98_2-1709549231170.png

 

swathisarang98_0-1709549051364.png

Please mark this comment as Correct Answer/Helpful if it helped you.

Regards,

Swathi Sarang

 

aniket_hadron
Giga Expert

Go to System Definition > Deleted Records

Search for sys_user_grmember in table name

Identify the deleted record using  "Record Deleted" field which records the data when the data is delete 

Deleted user information is available in payload field. You need to open the record and check the JSON data for the user name.

Robbie
Kilo Patron
Kilo Patron

Hi @Nisha Mishra23,

 

One way to confirm this is to view the 'Deleted Records' (By simply typing 'Deleted Records' into the navigation menu) 

Under the table filter, type 'sys_user_grmember'. (As shown below - this will filter all deleted records against the Group Membership table). 

Additionally configure the columns so you can see the 'updated by', 'created by' as well as the 'payload' fields - again as shown below.

From here you can edit the query by either entering the sys_id of the user who was deleted (recommended as the sys_id is unique) or you can add the users name etc 

 

Screenshot 2024-03-04 at 10.59.11.png 

To help others (or for me to help you more directly), please mark this response correct by clicking on Accept as Solution and/or Helpful.

 

Thanks, Robbie