Views/Table used in Reports

[system]

Hi All,

I have hundreds of reports and I need to find out what tables/views are being used in all of the reports. The reports use universe as well as free hand sql.
Is there any easy way of doing this apart from going to all the data providers in each report and manually looking at what table/view is being used.

I think there was something in the forum to achieve this using a vbscript. but I can’t find it now.

Thanks in advance.

---

atlantadude (BOB member since 2006-01-06)

[system]

This utility might be a good starting point for you.

---

MichaelWelter (BOB member since 2002-08-08)