audit 7.1 or 7.2

Hugo Mendoza shared this question ago

Answered

Hello -

Is there an audit feature in Yellowfin 7.1 or 7.2? Trying to determine who ran what report, with counts.

Replies (2)

Guest ●

Hi Hugo,

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:

SELECT EventData
FROM Event
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:

SELECT ReportName
FROM ReportHeader
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:

SELECT FullName
FROM Person
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.

regards,

David