How to determine unused user accounts in RTC 4.x with Tomcat?
Is there a way I can extract a list of users that have no artifacts associated with them? We have a number of accounts created with wrong IDs, test accounts, etc. I need to end up with a list of users that are:
1. Already archived.
2. Have no artifacts associated with them.
Then if possible I would like to delete those users that match both criteria.
We are using Tomcat but not LDAP. I know I will need to edit the tomcat-users.xml file to remove the users, but that does not remove them from the jts database.
1. Already archived.
2. Have no artifacts associated with them.
Then if possible I would like to delete those users that match both criteria.
We are using Tomcat but not LDAP. I know I will need to edit the tomcat-users.xml file to remove the users, but that does not remove them from the jts database.
Comments
Kevin Ramer
May 03 '13, 12:24 p.m.1) If you have access to the RTC server side, use repotools -exportUsers
The line for an archived user will end with ,1
2) That might require some extensive query writing. I noticed that with RTC 4
the value choice for the query can be deferred until the query is run, so work item query could be setup for "Owner" to input at execution
1 vote
Mike Shkolnik
May 06 '13, 2:06 p.m.I can get a list of all archived owners through the web interface. Running queries for each of 390 archived owners would be rather tedious. I need something a little more automated. Unfortunately, while you can include Owner as input to a query, you can't query for an output of a list of owners. If there is some way I could script this without needing to know what I'm doing, please let me know.