Crystal Reports Utilization for Last 90 Days

[Former Member]

I am trying to use Query Builder to determine which crystal reports have been runned within the last 90 days. Is this possible? If yes how?

[former_member190781]

You can also think of using BOMM http://help.sap.com/businessobject/product_guides/boexir31/en/xi31_bomm_users_en.pdf

Regards,

Sohel

[Former Member]

Hi Garet,

As mentioned, this information can be fetched if you have Auditing enabled and configured to capture events specific to accessing reports.

If you are on BO 4.0 platform, you can check in CMC whether auditing is enabled or not. If it is enabled, you can deploy the auditing universe and reports from here.

Cheers

Mohan

[former_member191664]

Hi,

"which crystal reports have been runned within the last 90 days."

If you refer "RUN" as view on demand and refresh in InfoView/Launchpad and Crystal Report 2008/2011 designer, Mani's suggestion to use Audit record extraction of historical information is correct.

If you are referring to "RUN" as Crystal Report scheduled job, you can execute this SQL query in your Query Builder,

SELECT SI_NAME, SI_LAST_RUN_TIME FROM CI_INFOOBJECTS WHERE SI_KIND = 'CrystalReport' and si_instance = 0 and SI_LAST_RUN_TIME >= '2013.4.4'

Hope this helps,

Jin-Chong

[former_member182521]

Hi Garret,

You can't get this information using Query builder as this is meant for extraction of information from CMS database   which is realtime in nature. I would suggest you to consider using Auditor for extraction of historical information.

Regards

Mani

[Former Member]

you can't