M-Files Event Log - Dashboarding and Reporting

Hi fellow Admins,

I didn't see this represented in the forums - does anyone do anything with their event log? Any kind of reporting?

I have been asked to run a report of two users' activity over the past few months and I don't know what to do. 

Parents
  • Thank you and - I'm still curious of 2 things: 

    Where does the event log get saved to? How do I determine this? Is it possible to have the event log save to a master table, which could then be filtered into a dashboard. Can you save the event logs to M-Files itself?

    I recently met Michael Schweitzer, CEO of Gravity Union. He demonstrated their dashboard where their event log can be mined for various events to determine compliance flags. Events such as a project consultant accessing records outside of their project, or downloading items right before their departure - these anomalies can be addressed since they're identified through this kind of reporting. 

    Essentially I feel I'm not leveraging my event log and as Bright-Ideas pointed out, it's being over-written. 

    Has anyone taken their event log to the next level?

  • By default the event log is stored in the vault database.

    • To ensure that the event log keeps all the events and doesn't overwrite older ones, you need to enable Advanced Logging in the vault. See "The Electronic Signatures and Advanced Logging module" in the user guide: https://www.m-files.com/user-guide/latest/eng/Event_log.html
    • To export events from the vault database for external analytics and monitoring, you can use the Log Exporter module of Compliance Kit. It writes the logs to disk as XML files and you would then have to come up with a way to utilize those files (e.g. importing to SQL Server and analyzing with some third-party tool). As Craig said, you should be careful about the access to the exported logs.

    Both Advanced Logging and Log Exporter come with the Electronic Signatures add-on package, so please check if your license already includes that.

    Note also that the September '22 Update brought new event log filtering options to M-Files Admin, so even without these additional modules it's now easier to browse the event log if you are looking for instance events from a specific user (assuming the events are still in the log and not yet overwritten, that is):

Reply
  • By default the event log is stored in the vault database.

    • To ensure that the event log keeps all the events and doesn't overwrite older ones, you need to enable Advanced Logging in the vault. See "The Electronic Signatures and Advanced Logging module" in the user guide: https://www.m-files.com/user-guide/latest/eng/Event_log.html
    • To export events from the vault database for external analytics and monitoring, you can use the Log Exporter module of Compliance Kit. It writes the logs to disk as XML files and you would then have to come up with a way to utilize those files (e.g. importing to SQL Server and analyzing with some third-party tool). As Craig said, you should be careful about the access to the exported logs.

    Both Advanced Logging and Log Exporter come with the Electronic Signatures add-on package, so please check if your license already includes that.

    Note also that the September '22 Update brought new event log filtering options to M-Files Admin, so even without these additional modules it's now easier to browse the event log if you are looking for instance events from a specific user (assuming the events are still in the log and not yet overwritten, that is):

Children
No Data