Audits Report for Universe, Database and Server Connections

[system]

What type of reports are in your deployment?

We’ve developed a report that clearly lists unused Universes and Connections as they pertain to Webi and FullClient reports. You might want to check it out (it’s free).

You can find information at this thread:

120×120 10.4 KB

Hy to everybody. I use this query to select all the webi reports of an universe SELECT TOP 10000 si_id, si_name,SI_AUTHOR,SI_LAST_RUN_TIME,SI_PARENTID, SI_ISTANCE from ci_appobjects, ci_infoobjects where PARENTS("SI_NAME='Webi-Universe'", "SI_NAME='NAME_OF_THE_UNIVERSE'") it works perfectly, but it select all the report, also the istances. I would like to take only the main reports…how i can edit this query to find it? Thanks in advance flavio20002 (BOB member since 2010-03-23)

Once you install the driver, the report of interest will be called:

Universe-Reports-Connections-CE2_2632.wid

Hope this helps.

---

Atul Chowdhury (BOB member since 2003-07-07)