User/Universe relationship

[system]

Hello,

Goal: To pull a report from BOE which shows (a) All the active users (b) and which universes they have access to?

Steps I followed:

I was able to extract all the active users and groups from this nice little utility.

BOXI UserList & Group Extraction

Here is a little excel file with a bit of VBA code to extract from a CMS the complete list of user and the list of groups each user is member of. Quite useful when you need to check group membership. It’s now possible to edit the CMS data, simply by modify entries in the Excel File. You need then to export your modification back to the CMS. Modifiables column are : Login, FullName, Email, Disabled and Description. Platform: BO XI R2 / BOXI3.1 (it’s necessary to change the libs to fits XI3.1, s…

Then I went ahead and used this utility to see (a) author (b) report name (c) universe used

WID Scanner

version: BOXI rls2 platform: MS Windows JBO jbo_911@hotmail.com download grep @ http://sourceforge.net/project/showfiles.php?group_id=23617 Updated 8/14/2007 – Version 1.1: -fix export path, spaces were not allowed -added FullClient documents to documentlist (no object scan is done, other tools available) -added filesize in KB of the documents -Instances are (if wanted) excluded in a proper way WIDScanner_1_2.zip (43.0 KB) jbo (BOB member since 2005-07-31)

There were some discrepancies in the result. Many Webi reports did not show what universe was used.

If we joined these two excel (common object is user id) we could see what user used what universe.

Question: Is there a simpler/automated way to achieve this. We have an in-house DBA who can create tables for us, but how do we get started on this?

Mr. Moderator: Please redirect my question to the right thread if this is the wrong location

Any ideas would be appreciated.
Thanks,

---

Diamond (BOB member since 2009-08-26)

[SebastienGoiffon]

There is no real way to get this info from the CMC or the auditor database. All your resluts will always be partial …