Skip to main content
S
sconrad1-Visitor
1-Visitor
January 26, 2017
Solved

How can I bulk remove users from windchill?

  • January 26, 2017
  • 4 replies
  • 3173 views

Can anyone tell me how can I bulk remove users from windchill 10.2 please?

I can only import 50 users in to the participant administration and I have to remove 1400+ disconnected users.

Is there a way that I can remove all disconnected users at once?

Thank you in advance for any guidance you can give.

Best answer by BineshKumar1

If you are familiar with the database side, you can update the DB tables directly

  1. delete from RemoteObjectInfo where idA3A3=<idA2A2 from "select ida2a2 from wtuser where name like '%USERNAME%>;
  2. delete from OwningRepositoryLocalObject where idA3B5=<idA2A2 from "select ida2a2 from wtuser where name like '%USERNAME%>;
  3. Update WTUser set name=’{wt.org.wtuser:’ + CAST(idA2A2 as varchar) + ‘}’ + name, disabled=1, repairNeeded=0 where idA2A2=<"select ida2a2 from wtuser where name like '%USERNAME%>;

4 replies

B
BineshKumar12-ExplorerAnswer
2-Explorer
January 26, 2017

If you are familiar with the database side, you can update the DB tables directly

  1. delete from RemoteObjectInfo where idA3A3=<idA2A2 from "select ida2a2 from wtuser where name like '%USERNAME%>;
  2. delete from OwningRepositoryLocalObject where idA3B5=<idA2A2 from "select ida2a2 from wtuser where name like '%USERNAME%>;
  3. Update WTUser set name=’{wt.org.wtuser:’ + CAST(idA2A2 as varchar) + ‘}’ + name, disabled=1, repairNeeded=0 where idA2A2=<"select ida2a2 from wtuser where name like '%USERNAME%>;
S
sconrad1-VisitorAuthor
1-Visitor
February 3, 2017

Thank you for your input. I was asked not to do it from the DB for whatever reason... I ended up removing 2800+ users 50 at a time... This is something that needs to change. I can't see a valid reason that only 50 users should be removed at once.

Since it takes 5-10 minutes for windchill to remove the users.Doing it 50 at a time took 2 days to complete. I can't imagine how long it would take of we had over 10,000 users to remove.

B
BineshKumar12-Explorer
2-Explorer
February 3, 2017

I think we can increase the limit by setting the property com.ptc.netmarkets.userSearch.maxCount  in wt.properties  to a higher value.

    Terms & ConditionsAccessibility statement