Thanks for the document. Yes i have read that , actually i am looking for some option to do it in bulk like deleting all 4000 records at a time .
Why not select the 4000k+ users, modifying all to Delete (status) and then Delete all?
yes right , I can always do that. But will that not affect the performance ?
Possibly impacting in your env performance, and this process has a lengthy re-cache.
But I'm talking without knowing your infrastructure. Anyway, do this activity outside of production hours, open a planned change for the weekend. Is the best way.
I tested it below.
I downloaded the spreadsheet for people and added the user details in CTM_LoadPeople sheet.
I added below columns only and imported the sheet through UDM and people records status changed to Delete.
Profile Status = 5
Now you can search all people records with delete status directly from CTM:People form OR write an escalation for midnight to delete the people records with status delete.