audit 7.1 or 7.2

Hugo Mendoza shared this question 1 year ago
Answered

Hello -

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

Comments (3)

photo
1

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

photo
1

Yes, very helpful. Thank you!

photo
photo
1

great!