Is there an audit feature in Yellowfin 7.1 or 7.2? Trying to determine who ran what report, with counts.
yes, there is a table in the Yellowfin config db called Event that records many different events, and definitely who ran what report.
You will need a query something like:
WHERE EventCode = 'RPTRUN'
AND EventDate > '2017-08-29'
and within the EventData field you will find the reportID from which you can identify the reportname with the following query:
WHERE ReportId = <insert ReportId here>
and also you will find the user who ran the report from the data "requestor=12101" by running the following query:
WHERE IpPerson = <insert requestor number here>
and then once you know which users/reports you are looking for, then you can aggregate to found out the counts.
I hope that's enough information to help you, however if you have any further questions about it then please don't hesitate to tell us.
Yes, very helpful. Thank you!
Comments have been locked on this page!