Feature #33347

Include updated_on and passwd_changed_on columns when exporting users to CSV

Added by Go MAEDA 4 months ago. Updated 3 months ago.

Status:ClosedStart date:
Priority:NormalDue date:
Assignee:Go MAEDA% Done:

0%

Category:Accounts / authentication
Target version:4.2.0
Resolution:Fixed

Description

currently, there is no means to see updated_on and passwd_changed_on columns of users table. However, those timestamps are useful or necessary for admins or information security managers.

I think an easy way to make the timestamps visible is to include them when exporting users to CSV. It is easy to implement because there is any impact on the user interface.

31198-v3.patch Magnifier (1.79 KB) Mizuki ISHIKAWA, 2020-04-28 09:53

33347-v4.patch Magnifier (1.76 KB) Go MAEDA, 2020-04-29 07:13


Related issues

Related to Redmine - Feature #33592: Include updated_on and passwd_changed_on columns in API r... Closed

Associated revisions

Revision 19740
Added by Go MAEDA 3 months ago

Include updated_on and passwd_changed_on columns when exporting users to CSV (#33347).

Patch by Mizuki ISHIKAWA.

Revision 19741
Added by Go MAEDA 3 months ago

Update locales (#33347).

History

#1 Updated by Mizuki ISHIKAWA 3 months ago

  • File 31198.patch added

I have attached a patch to add columns.

#2 Updated by Mizuki ISHIKAWA 3 months ago

  • File 31198-v2.patch added

It was fixed because the test was incorrect.

#3 Updated by Go MAEDA 3 months ago

  • File deleted (31198.patch)

#4 Updated by Mizuki ISHIKAWA 3 months ago

Fixed because the test sometimes failed due to time zone.

#5 Updated by Go MAEDA 3 months ago

  • File deleted (31198-v2.patch)

#6 Updated by Go MAEDA 3 months ago

  • Target version set to Candidate for next major release

#7 Updated by Go MAEDA 3 months ago

  • File 33347-v4.patchMagnifier added
  • Target version changed from Candidate for next major release to 4.2.0

I have slightly updated the patch as follows.

  • Move the "Updated" column to after the "Created" column. This order is consistent with several REST API
  • Change the translation for passwd_changed_on from "Last password change on" to "Password last changed"

Setting the target version to 4.2.0.

#8 Updated by Go MAEDA 3 months ago

  • Status changed from New to Closed
  • Assignee set to Go MAEDA
  • Resolution set to Fixed

Committed the patch. Thank you for adding the feature.

#9 Updated by Go MAEDA 3 months ago

  • Subject changed from Export updated_on and passwd_changed_on fields as well when exporting users to CSV to Include updated_on and passwd_changed_on columns when exporting users to CSV

#10 Updated by Go MAEDA about 1 month ago

  • Related to Feature #33592: Include updated_on and passwd_changed_on columns in API response added

Also available in: Atom PDF