Hi All,
I am new when it comes to auditing in BO. Can anyone plz help me in auditing all reports and their Last Refresh Date pointing to a universe or placed in a particular folder? I know we can do for the one pointing to a universe…but can we do it folder wise? If so can anyone give me the syntax for the query to run in the Query Builder?
Thanks a ton in advance!
hrithik_14 (BOB member since 2007-04-23)
No one knows the syntax? I was assuming this is a fairly easy one…maybe I am wrong.
hrithik_14 (BOB member since 2007-04-23)
You should be able to accomplish mostly through Auditor alone but it’ll be a little hairy.
Through a series of derived tables, you’ll want to get the max(start_timestamp) from the audit_event table where your report is in the audit_detail table with your desired universe (using the right detail_type_id) and the desired object folder (also using another detail_type_id).
Those two lookups on detail_type_id are just derived tables.
V[/code]
Eric Vallo 
(BOB member since 2002-08-15)
Hi, how do you audit users who accessed a particular universe?? I want to be able to do that as well because I have one universe that contains sensitive data and it is a requirement to keep track of who’s running reports off it.
gjwl_8 (BOB member since 2010-02-17)
Look at the detail_type table for the correct value and use that in your audit_detail query where the detail text equals your universe name and the detail_type_id = that value.
V
Eric Vallo (BOB member since 2002-08-15)