Report List by Public Folders

other Auditor
1

Hi All,

I am trying to get the complete list of reports available in Public Folders by each folder using the Audit Universe.This way i can track the mterics for each report in these Public folders.

Is there a way to do this.

For Example:
Report Name Report Folder
Report 1 Public Folder/Folder 1

Appreciate your help and thoughts.

BO XI R2,Oracle 10g

Thank you
Bluebox

bluebox (BOB member since 2004-05-28)

2

you can’t !

auditor will only list you reports and ressources based on their use and activity. if a report is on the cms but has been never used, it will not be displayed. you have to use the infamous query builder tool or make more ellaborate solution using sdk

have a look to

bernard timbal :fr: (BOB member since 2003-05-26)

3

Hi Bernard,

Thank you for the reply.

Say each and every report has some kind of activity,is it even possible to display the exact folder path of each these reports using the Audit universe.

Thank you once again.
Bluebox

bluebox (BOB member since 2004-05-28)

4

Depending on what SP you are running you can get the object path from the audit database. The object path was added in SP2 however it will only apply for new audit entries that are written, historical audit events are not updated with the path.

jwhite9 :us: (BOB member since 2006-07-28)

5

Does this mean that a report that has never been refreshed (or has no event written into the Audit db) won’t show up with this Object Folder path.

Thank you
Bluebox

bluebox (BOB member since 2004-05-28)

6

A report that has never been refreshed will not have audit entries for it other than those logged when the report was created.

If you want to get a list of reports and the folders they reside in you will need to use something other than the audit database. Check the BOB Downloads section for a tool that may help.

jwhite9 :us: (BOB member since 2006-07-28)

7

Thank you.Will do that.

Appreciate your reply.

bluebox (BOB member since 2004-05-28)

8

Bluebox,

I’ve adapted the Action Detail as a new measure in the Activity Universe, to make it more usable for things like this. See my post here…

You should get a full list even if there’s reports with no refreshes or read docs as ‘object created’ will have recorded at some point. I do however get reports that have since been deleted coming up in my Audit reports, I guess using the query filter you can probably make this more relevant if necessary.

Cheers

bolr1 (BOB member since 2008-11-27)

9

BlueBox -

You may also want to investigate a 3rd party tool (System Profiler, etc) for this type of data. As others have mentioned, Auditor may not always have the information you are looking for.

crystal01 :us: (BOB member since 2006-08-30)