Webi Report in Users Inbox and Personal Folders

other Auditor
1

Hi All,

Is there a way we can find out all the Webi reports present in users inbox and favourites folder.

Regards,
Ankit

at&t (BOB member since 2007-04-05)

2

in BOXIR2, go to CMS>>objects. A whole listingof reports is displayed along with other details. All the reports that have the folder as userFolders> <> are te reports present in user’s personal folder.

priyanka1410 :uk: (BOB member since 2007-01-13)

3

You mean CMC, I think, not CMS :wink:

Nick Daniels :uk: (BOB member since 2002-08-15)

4

yes, CMC :slight_smile:

priyanka1410 :uk: (BOB member since 2007-01-13)

5

Thanks for your reply, Actually I want to create a excel report with following columns

  1. User name
  2. Folder (Inbox/Favourites)
  3. Webi Report Name.

I know that using CMC I can see the user reports, but I want to document all of them , so I was just thinking if there is a Auditor Report or Query Builder Query or some other way to get the same information instead of manually looking at each users folders.

Thanks again,
Ankit

at&t (BOB member since 2007-04-05)

6

Any Suggestions Friends?

at&t (BOB member since 2007-04-05)

7

Hi Ankit

I have a suggestion for you using query builder. First I would like to know how many user folders are there in your system? If it is not too large you can try this.

You should get a list of all SI_ID’s of all user folders. You can use this query for this
select si_id from ci_infoobjects where si_kind=‘Inbox’

And you can use those SI_ID’s in the second query which is something like
select si_name,si_owner from ci_infoobjects where si_parentid in (SI_IDuser1,SI_IDuser2,SI_IDuser3,…SI_IDuserN) and si_progid=‘CrystalEnterprise.Webi’

I hope this helps if you don’t have too large users.

Raul… :united_arab_emirates: (BOB member since 2007-07-31)