howto create a "report of Reports"?

[system]

hi all
yes the question could sounds strange but a user of mine asked me if it is possible to have a report showing him all reports created under a specific folder (and its subfolders) in order to have a sort of control of the situation for a specific folder.

I have tried with auditor universe but the query are really slow and data refers to actions and events…and i would like to be able to submit “simple” and quick report to retrieve:
all reports for a specific user, or…all reports under a folder…
so infos not related to particular events or actions.

thanks in advance for your help
ciao from Italy

---

bilux_team (BOB member since 2008-01-17)

[system]

I haven’t done what you are asking, but I recall seeing something similar in a thread about using query builder:

XIR2 Query Builder Admin Reports

I have compiled a list of queries that will get some basic information out of the CMC. I'm trying to figure out how to run more complex queires to get all the reports that I need. here is the initial list. feel free to add queries.. Thanks Get All Webi reports Select SI_ID, SI_NAME From CI_INFOOBJECTS Where SI_PROGID='CrystalEnterprise.Webi' And SI_INSTANCE=0 Get Full Client Reports SELECT SI_ID, SI_NAME,SI_FILES FROM CI_INFOOBJECTS WHERE SI_KIND in( 'webi' ,'FullClient') Get All report…

I find query builder cumbersome, but you may be able to use it to get the info you are looking for.

---

jmacgill (BOB member since 2002-08-30)

[system]

My company has a product to extract any information from the CMS system db and put it into a relational db, which can be reported from. If you’d like more information, please contact me.

---

gobrien (BOB member since 2008-03-14)