Skip to Content
0
Former Member
Oct 12, 2022 at 07:29 PM

Need help getting Universe list, reports list

393 Views Last edit Oct 13, 2022 at 02:39 PM 3 rev

Hi All

I am trying to get the following info and load into excel or csv

Report Name

Location – File path

Last Accessed Date

Last Accessed By – User Name

Universe List

I tried various Queries using Query Builder, but no luck, please advice, below are some queries I used.


si_name,

si_universe,

si_cuid,

SI_PROGID From CI_INFOOBJECTS where SI_INSTANCE=0 AND SI_PROGID='CrystalEnterprise.Webi'
<br>