BusinessObjects XI report inventory

[ususr]

We have been using BOE XI for a while and i need to get a list of all scheduled/recurring/successful reports. Is there an easy way to get this through SQL Server DB? Any other ideas are appreciated. I could try it through instance manager but it would require lot of manual work.

Thanks in advance.

 

[cmmrfrds]

If you have the Audit DB, you can get that type of information from the Audit DB.

 

[ususr]

what is this Audit DB and how do i get it??

Thanks

 

[cmmrfrds]

The Audit DB comes with Premium, otherwise, it is an extra cost to the Standard BOXI. Check with your BOXI administrator.

 

[SFLLC]

You have a couple of options. You could use the Instance and Schedule manager web tools in XI as you stated and build together a report (i.e. by copy & paste from the result to an Excel file)

You could also use the Query Builder tool which you could structure to look in specific folders or specific criteria (i.e. if it is a parent or if it has children and whether those children were success) and build together a report (i.e. by copy & paste from the result to an Excel file).

You could try coding something if you're familiar with development and the BO SDKs.

Be prepared for all of the above approaches to pretty time consuming and tedious.

There are also a couple of third party tools that can help. One such tool is .rpt Inspector Enterprise Suite. This is a windows based tool that allows you to open multiple reports at the same time and builds an in-memory database that you can then put together documentation sets to Excel (or CSV) and quickly find out which report objects have schedules, which have been successful, and other properties associated to them.

--
Software Forces

http://www.SoftwareForces.com

.rpt Inspector - Document, Analyze, Modify, Standardize, Change Data source and/or Database -- on Multiple Crystal Reports objects (i.e. formulas, parameters, database, text, etc.) and properties (definitions, default values, driver / locations / fields, fonts / colors, etc.) and enterprise meta data (i.e. schedules, formats, destinations, instances, etc.) at the same time.

Add-ons, Tools, Utilities for Business Objects / Crystal Enterprise, and Crystal Reports: .rpt Inspector, SPL (Smart Pick Lists), SmartObjects, SmartObjects Admin Desktop