Is there a way to capture user activity for when a user exports a report
Thank you reaching out to us.
I'm not sure which type of export you are referring to (e.g. export the report for import into another system or exporting the report data to excel), so hopefully I can provide an answer to both.
All activity is stored within the Yellowfin Configuration database in a table called 'event'.
Exporting to a document (PDF, XLSX, DOCX)
When exporting to a document these are recorded against the event type of 'REPORT' and the event code 'EXPORT' (seen below), with the event data is it possible to see the name of the file, the date is was exported and the document type. You could then join the IpSouce column to person.IpPerson to retrieve the user that has completed this action.
Exporting the report to yfx
When using the admin function to export a report and its dependents for import to another system or to backup the report this process is also audited in the events table. In this scenario the event type is 'EXPORT' and depending on what you are exporting you will see one of the different event codes below:
Again from this you can join this to the person table to find out who completed this action.
I would recommend looking at the Audit Content Package found in the Yellowfin Market Place as this contains pre-built views that would allow you to build reports on this data to help with your monitoring.
I hope this helps, if you have any questions please do let me know.
Than you for that, but is there any way to capture this activity in a log file?
Integrum Management Systems Pty Ltd.
68-70 Mentmore Avenue, Rosebery, NSW 2018, Australia
M: +61 401 416 003 Website: http://www.integrumsystems.com
"IBM Domino/Notes in the right hands is a powerful collaborative tool. In the wrong hands it's just Outlook"
From: "Support Queue" <support@Yellowfin.bi>
To: "Michael" <email@example.com>
Date: 03/12/2019 09:03 PM
Subject: [Awaiting Reply] Is there a way to capture user activity for when a user exports a report
Thank you for getting back to me.
I have added the link below that explains the different logs available what is held within them.
What are all the Yellowfin Logs
I have looked through my own log files to see if it is possible to find this information but the logs show details in to the following way
YF:2019-12-03 09:50:01: INFO (MIExportAction:processActionPerform) - MIExportAction entered
This would allow you to see when an export has occurred but not the detail of it.
Yes i saw that too, would have been nice to see more details for auditing and forensic purposes
Date: 04/12/2019 10:39 PM
Subject: New Comment in "Is there a way to capture user activity for when a user exports a report"
If you could tell me what you would like to be within a log for this purpose and I can raise an idea on your behalf to see if this is an change we can make in the future.
Basically, date, time, username, report name that the export took place
Date: 05/12/2019 08:15 PM
Thank you for getting back to me so quickly. Before a raise this as an idea to increase the detail stored in the logs, can I ask why you would like to do this via a log file rather than getting this data from event table which already contains this? I only ask so that I fully understand your use case.
It was a requirement from one of our clients, for forensic purposes
Date: 05/12/2019 08:39 PM
I am happy to raise this as an idea as discussed to look at including auditing within a log file, but as this would be a new feature and one that I believe may not be implement due to this data already being collected. Would it be possible to ask your client if using a Yellowfin report and exporting that data to a csv for example would be compatible with the forensic work they wish to complete on it?
I hope you are well.
I wanted to check in with you to see if you have had an opportunity to pose my question to your client?
Comments have been locked on this page!