Find duplicate users in same group

Kingshuk Mazumd
Tera Contributor

Same User added more than once in a group. I want to make a report I tried with sys_user_grmember table, but it didn't help.

#reports

2 REPLIES 2

Sanjay191
Kilo Patron

Hi @Kingshuk Mazumd 

So your question is that same user present in how many group right ?

Sanjay191
Kilo Patron

Hi @Kingshuk Mazumd 

You can use the group by with user on group member table you can find out how many group are part of this user , I think it will help you 
If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Thank You