How to identify reports where an object or LOV was used

[system]

We recently added a new position and would like to know all reports where the position code object has been used. Is there a utility that comes with BO that will identify all Webi and Deski reports where a specified object or LOV was used?

---

asosseh (BOB member since 2009-05-11)

[system]

This object level analysis is not available out of the box through Query Builder.

You have a few options - 1) there are free utilities available in the Downloads area of BOB that may get you what you need, 2) you can script a SDK solution for this, or 3) 3rd party solutions extract this information and load to database for easy reporting.

---

crystal01 (BOB member since 2006-08-30)

[system]

Here are some links which may help you:

DeskI Documents Inspector we use this in our shop

WID Scanner we use this in our shop

List objects used in a series of reports

Author: [url=http://www.forumtopics.com/busobj/profile.php?mode=viewprofile&u=1343]Dwayne Hoffpauir, EDS[/url] The attached utility will record objects that are used in a series of reports. Usage is as follows: [quote:61cb8b7957="Author's notes"]- Create a temporary directory. - Place all documents (.rep files) to be analyzed in that directory. - Place this document in that same directory. - Open this document, and refresh. - Each document in the directory will be opened, and data provider ob…

List report level variables in full client reports

Author: Dwayne Hoffpauir, EDS The attached utility will record named report level variables and their formula that are used in a series of reports. Usage is as follows: [quote:ce6effceb0=“Author’s notes”]- Create a temporary directory. Place all documents (.rep files) to be analyzed in that directory. Place this document in that same directory. Open this document, and refresh. Each document in the directory will be opened, and data provider objects recorded. There will be a lot of screen f…

---

REB01 (BOB member since 2004-11-29)

[system]

Also - search the Downloads forum for “WID Scanner” - this is a solution for WebI report objects.

---

crystal01 (BOB member since 2006-08-30)

[system]

@crystal01

Also - search the Downloads forum for “WID Scanner” - this is a solution for WebI report objects.

I included the WID Scanner link in my post.

WID Scanner

version: BOXI rls2 platform: MS Windows JBO jbo_911@hotmail.com download grep @ http://sourceforge.net/project/showfiles.php?group_id=23617 Updated 8/14/2007 – Version 1.1: -fix export path, spaces were not allowed -added FullClient documents to documentlist (no object scan is done, other tools available) -added filesize in KB of the documents -Instances are (if wanted) excluded in a proper way WIDScanner_1_2.zip (43.0 KB) jbo (BOB member since 2005-07-31)

---

REB01 (BOB member since 2004-11-29)