Sql to find disabled users

Hello All,

I was wondering some one can assist me with creating an sql search of RT. I
am looking to find all disaled users in my system and then use the
rt-shredder pluggin to delete them.

Also maybe a search that shows accounts that have not logged in for over
two years.

Any help is very much appreciated.

Best Regards,
-Jesse

Hi Jesse,

Hello All,

I was wondering some one can assist me with creating an sql search of RT. I
am looking to find all disaled users in my system and then use the
rt-shredder pluggin to delete them.

I’ve not looked into the disabled-ness of a user, but to start
digging, I’d grep the following file:

lib/RT/User.pm

Also maybe a search that shows accounts that have not logged in for over two
years.

This might me tougher.

-m

This might me tougher.

s/me/be/

-m

Thank you Matt. I’ll let everyone what I find out.On Tuesday, September 29, 2015, Matt Zagrabelny mzagrabe@d.umn.edu wrote:

This might me tougher.

s/me/be/

-m

Jesse Maseto
Head of Support
ByWater Solutions
Support & Consulting for OSS
Office - Stratford,CT
T/F 888.900.8944


Jesse@bywatersolutions.com