The "Login Management" plugin provides an overview of all active users, their last login and the number of logins.
The task deactivates users who have not logged on or have never used the account after a configurable number of days. In addition, users will be informed by email configurable days before the deactivation date.
Before installation of the extension, it is necessary to create the view login_management manually by executing the following command on your CELUM database.
CREATE VIEW login_management AS
SELECT u.ims_id, u.ims_firstname, u.ims_lastname, u.ims_name, u.ims_email, u.ims_kind, u.ims_created,
DATEDIFF(d, u.IMS_CREATED, GETDATE()) daysCreated,
MAX(s.ims_time) last_login,
COUNT(case when s.ims_event_type = 1 then 1 else null end) logins,
DATEDIFF(d, MAX(s.ims_time), GETDATE()) daysLastLogin
FROM ims_authorizable u
LEFT JOIN ims_stats s
ON s.ims_user_id = u.ims_id AND s.ims_event_type = 1
WHERE u.ims_discriminator = 'usr' AND u.ims_deactivated = 0 AND u.ims_authenticator_name != 'api'
GROUP BY u.ims_id, u.ims_firstname, u.ims_lastname, u.ims_name, u.ims_email, u.ims_kind, u.ims_created
CREATE VIEW login_management AS
SELECT u.ims_id, u.ims_firstname, u.ims_lastname, u.ims_name, u.ims_email, u.ims_kind, u.ims_created,
(TO_DAYS(CURDATE()) - TO_DAYS(u.ims_created)) daysCreated,
MAX(s.ims_time) last_login,
COUNT(case when s.ims_event_type = 1 then 1 else null end) logins,
(TO_DAYS(CURDATE()) - TO_DAYS(MAX(s.ims_time))) daysLastLogin
FROM ims_authorizable u
LEFT JOIN ims_stats s
ON s.ims_user_id = u.ims_id AND s.ims_event_type = 1
WHERE u.ims_discriminator = 'usr' AND u.ims_deactivated = 0 AND u.ims_authenticator_name != 'api'
GROUP BY u.ims_id
CREATE VIEW login_management AS
SELECT u.ims_id, u.ims_firstname, u.ims_lastname, u.ims_name, u.ims_email, u.ims_kind, u.ims_created,
(trunc(sysdate) - trunc(u.ims_created)) daysCreated,
MAX(s.ims_time) last_login,
COUNT(case when s.ims_event_type = 1 then 1 else null end) logins,
(trunc(sysdate) - trunc(max(s.ims_time))) daysLastLogin
FROM ims_authorizable u
LEFT OUTER JOIN ims_stats s
ON s.ims_user_id = u.ims_id AND s.ims_event_type = 1
WHERE u.ims_discriminator = 'usr' AND u.ims_deactivated = 0 AND u.ims_authenticator_name != 'api'
GROUP BY u.ims_id, u.ims_firstname, u.ims_lastname, u.ims_name, u.ims_email, u.ims_kind, u.ims_created
To be configured in {home}/appserver/conf/custom.properties.
type: String, required: yes, default: -
License key (delivered by brix IT Solutions)
type: List of long (comma-separated), required: no, default: -
Restrict the use of the plugin to this user group IDs (superadmins always see it in any case).
type: long, required: no, default: 0
Defines how many days since the last login/creation date the user account will be deactivated. If not defined, nothing happens.
Super Administrators (including the API-User) will never be deactivated
type: long, required: no, default: 0
Defines how many days before the deactivation the user should receive a reminder mail. If not defined, nothing happens.
type: time (seconds minutes hours days months years, separated with "space"), required: no, default:
0 0 1 * * ?
(each night at 01:00)
When and how often the task is running.
Login Management | CELUM |
---|---|
1.0.0 | 6.4 (tested with 6.8) |
1.0.1 | 6.4 (tested with 6.8) |
Release: 2021-01-22
Initial Version
Release: 2021-02-25
updated celum-mappings to 2.10.1
© brix IT Solutions