Remove duplicate records from Group Member[sys_user_grmember] table.

[HrishabhKumar]

How can we remove duplicates from Group Member table. I know we can use Fix scripts to do that, but I want to know the optimal approach.

[Dr Atul G- LNG]

Hi @HrishabhKumar 

Are you sure these are all the same users and haven't been added multiple times? Since the user names can be identical, try using the user ID or email to cross-check whether they are the same or different users.

[HrishabhKumar]

They are same @Dr Atul G- LNG 

[Dr Atul G- LNG]

Hi @HrishabhKumar 

In this case, open the group and go to the group member-related list. Move all the duplicate records to the left slush bucket, and the same process will apply. It's easy, quick, and will reflect the results immediately.

[Ankur Bawiskar]

@HrishabhKumar 

as per image each row in Group member is unique.

Are you saying Admin HK and Admin SB are same users and should not be added to same group?

If yes then you should check why there are same users for 1 purpose?

Based on that you can take the next steps

Logically those are separate users and have separate sysIds and hence system allowed insertion

If my response helped please mark it correct and close the thread so that it benefits future readers.