Core - User Activity

Owned by Thibault Dethier
Sept 14, 2023
1 min read

Ticket

OMT-312: Report: Admin - User Activity ReportDone

Legacy stored procedure

uspSSRSUserLogReport

 

Comments about the report

The legacy version of openIMIS used to track some data that is no longer saved in the modular version. This implies that some entities are no longer available. This includes:

  • ICD interactions

  • logins

  • logouts

There are issues with the way audit dates are saved in many modules: usually, element.save_history() is called, which creates a new entry for the element, and nothing else is done.

The issue is that saving history without updating the validity_from attribute of the valid element means that every record of a given item will have the same validity_from value, which makes auditing difficult and error-prone.

While this situation is not solved (either by fixing each audit call or by changing the audit system), this report can generate data that is incoherent.

 

How it works

 

First, a verification is done to make sure that the modules containing each requested entity are installed. Then, for each entity:

  • A query fetches data that matches the requested criteria (user, dates…). Data is ordered by audit dates.

  • A function determines if the data line is a creation, an update or a suppression (based on the audit dates and previously analyzed IDs).

  • The data line is formatted

 

Did you encounter a problem or do you have a suggestion?

Please contact our Service Desk


This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License. https://creativecommons.org/licenses/by-sa/4.0/