Question Re: Audit report: in Technology Q&A

Audit report:

Former Member — Wed, 10 Feb 2016 10:46:53 GMT

Hi Gurus,

Kindly help me...

Can we know the reports that were never used using Auditing universe, (BO 4.1)

Thank you for the Help !!!

Re: Audit report:

manikandan_elumalai — Wed, 10 Feb 2016 11:19:36 GMT

You need to manually deploy the Audit universe and Reports as they no longer available Out of box. Download teh LCMBIARs appropritae for you here

You need to look for Report 14 in the list

Re: Audit report:

Former Member — Wed, 10 Feb 2016 11:37:28 GMT

Hi Mani,

Thank you for the reply

I have deployed this universe

for SQL

i want to know, how we can list the reports never used.

Thank you for the help !!!

Re: Audit report:

manikandan_elumalai — Wed, 10 Feb 2016 11:43:52 GMT

I would suggest you the newer version as it is webi format along with more accurate Audit reports than that of the previous section. Please refer the comments section of the new version for more clarity.

Re: Audit report:

amitrathi239 — Wed, 10 Feb 2016 12:18:22 GMT

Hi,

Create a webi query as attached screenshot and try.Based on the requirement you can select the different Event type value.

Amit

Re: Audit report:

DellSC — Wed, 10 Feb 2016 14:49:33 GMT

Actually, the Audit reports/database will only show you which reports have been used. If, for example, you upgraded into a newer version of BO and you have reports that haven't been used since prior to the upgrade, they will not have any audit data that would tell you that they have not been used.

The only way to really get this information would be to write a program using either the .NET or Java SDK that would pull the SI_CUID value for each report in the system (along with report name and folder) and then query the ADS_EVENT table in the audit database to determine whether it has been viewed or run on a schedule.

-Dell