How to Delete duplicate above 200000 group members at a time

Nani18
Tera Contributor

I want to Delete above 200000 duplicate group members in many groups at a time by using background script without setlimit.

 

Is that possible...?

 

 

Thanks in advance 

Nani

9 REPLIES 9

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Nani18 

Deletion is not recommended — it’s better to deactivate the group.
If you delete a group that's being used elsewhere, the related records could be impacted.
Additionally, if the group is used in any logic or reports, those will also be affected.

If you still want to proceed with deletion, it’s better to do it in a lower environment like dev or pre-prod first in bit n pieces.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hello@ Atul

Thanks for your response.. 

 

I want to Delete duplicate group members not groups..

When you say "duplicate member," do you mean the same member being part of two groups?

 

https://www.servicenow.com/community/itsm-forum/find-duplicate-users-in-two-groups/m-p/2386378

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

Hello@atul

 

Same member added twice with the same sys_id in one group. colease select box unchecked earlier because of that I can see many groups having group members twice with Same sys_id ..now I have checked colease select box as true..issue is now resolved ...now the problem is I want to remove duplicate group members..i think you understood what I am trying to say...

 

Help me to delete those duplicate records by using script or any other way.