Good morning, I need to mass invalidate client / agent users in OTRS 6 that:
1. Never authenticated
2. Last authentication more than 90 days ago
Can anyone help me?
Valid mass change of users to invalid.
Moderator: crythias
-
rodrigonvsosoftbox
- Znuny newbie
- Posts: 3
- Joined: 27 May 2019, 15:25
- Znuny Version: 6.0.8
- Real Name: Rodrigo Naves de Oliveira
- Company: Softbox
-
root
- Administrator
- Posts: 4251
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Valid mass change of users to invalid.
Hi,
what's a client for you? A customer user?
- Roy
what's a client for you? A customer user?
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
rodrigonvsosoftbox
- Znuny newbie
- Posts: 3
- Joined: 27 May 2019, 15:25
- Znuny Version: 6.0.8
- Real Name: Rodrigo Naves de Oliveira
- Company: Softbox
Re: Valid mass change of users to invalid.
That's right friend, Customer User.
-
root
- Administrator
- Posts: 4251
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Valid mass change of users to invalid.
Hi,
Check the tables users and user_preferences and the preferences_keys UserLastLogin and UserLastLoginTimestamp. And for the customer_user it's customer_preferences.
Try it first on a test system and delete the cache after you update anything in the tables.
Or check for a commercial add-on like https://www.znuny.com/add-ons/znuny4otr ... ctiveusers (should also work for customer user)
- Roy
Check the tables users and user_preferences and the preferences_keys UserLastLogin and UserLastLoginTimestamp. And for the customer_user it's customer_preferences.
Try it first on a test system and delete the cache after you update anything in the tables.
Or check for a commercial add-on like https://www.znuny.com/add-ons/znuny4otr ... ctiveusers (should also work for customer user)
- Roy
Znuny and Znuny LTS running on CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
Use a test system - always.
Do you need professional services? Check out https://www.znuny.com/
Do you want to contribute or want to know where it goes ?
-
rodrigonvsosoftbox
- Znuny newbie
- Posts: 3
- Joined: 27 May 2019, 15:25
- Znuny Version: 6.0.8
- Real Name: Rodrigo Naves de Oliveira
- Company: Softbox
Re: Valid mass change of users to invalid.
Good morning guys, As I could not get a solution to invalidate the mass users, I ran manually. Anyway thanks for the support.