Document users and groups they are in? (BOXI Rel 2)

[bessebo]

Is there an easy way that I can get a file of all of our existing users and which groups they belong to? I need this list for a Sarbanes-Oxley audit and I don't have an easy way to get this information. Any help would be appreciated.

Regards,
Bessebo

 

[MJRBIM]

Nothing "out of the box" that I am aware of....

I think the APOS KPI tool can do this, once it extracts CMS data to an external DB.

This whole "Reporting on BOE-XI infrastructure set-up" is a big-gap in the current AUDIT reports.

 

[bessebo]

YUP. I agree wholeheartedly. Thanks for your input..

Regards,
Bessebo

 

[groggle]

Go to the BOE Admin Launchpad Screen

Launch Query Builder from the Administration Tools Box

Put the following query into the top query box:

select SI_ID, SI_NAME from CI_INFOOBJECTS where SI_OBTYPE=18

Click on the Submit Query Button.

It's not the most beautiful report but its quick and easy!

 

[bessebo]

Yeah, I figured I could probably do a query but I also need to get the folders that each user has access to. What you sent will help me but is there a way to add the folder access? Is there a schema available somewhere that I can look at? Thanks very much for your post.

Regards,
Bessebo

 

[hilfy]

I've done something similar to this using the .NET SDK. I extract the user and group info into an ADO.NET dataset and then run a Crystal report to present the data. Actually, the app does more than that, like getting the last login date from the audit database or a list of all of the reports that a users has access to. However, since our groups are basically set up for specific folders, I usually just look at the group info.

I did a presentation on this app at the BO conference last fall. You can get a copy of the code I used for my presentation at

http://www.geocities.com/geekgurl7/Intro.html

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.

 

[bessebo]

Thank you Hilfy. Great stuff. I appreciate your response.

Thanks,
Bessebo