Audit report with FRS Data?

Hello,
I’ve Audit Universe and some sample audit reports downloaded from SAP site. My system is BO 4.2 SP3 and CMS/Audit are in Oracle.
I need audit report, chart, or dashbaord (whatever you call it) that displays the following:
Folder Name, Report Name, Accessed Date, Group Name, User ID, User Name, FRS Type, FRS Location, Report Size, FRS Size.

How do I get all that? Does this report require SDK to build it or can be done in regular Audit universe?
Can someone share some good sample audit report?

Thanks,


zulu1900 (BOB member since 2005-07-27)

Audit does not capture the FRS details of events. You would have to get that from either a CMS query or SDK program.


joepeters :us: (BOB member since 2002-08-29)

Thanks joepeters!
I was reading through this wiki post, maybe this could be another possibility.
https://wiki.scn.sap.com/wiki/display/BOBJ/Unlock+the+CMS+database+with+new+data+access+driver+for+BI+4.2

not sure if anyone has done it and if there is any issue with it.

Thanks,


zulu1900 (BOB member since 2005-07-27)

I haven’t used it for that specific reason, but it should work – it’s just a universe on top of CMS queries.


joepeters :us: (BOB member since 2002-08-29)