Hello All –

Now that I have a better understanding of the relationships between domains, groups, and users I'm trying to apply a more systemic regime to our environment. With that in mind I’m wondering if WebFOCUS has an internal tool or report that can provide the following information:

What domains are in my system?
What groups are in my system?
What are the group-domain relationships?
What are the user-group relationships?
What is the role assigned to each user?

Similarly, I'd be interested if anyone has a home grown tool or report that provides this type of information.

Thanks for any and all suggestions and feedback.

Dan Stoll
Bard College at Simons Rock
WebFOCUS 7.1.3

This message has been edited. Last edited by: Kerry,

This FocalPoint posting has some information that should be of interest to you: Report against user.htm? And this one as well: MRE 'Name' into Amber-Var?

Check out the Managed Reporting Extract Utility in the mradmin manual for your release. This might work for you.

when you installed MRE, what kind of database did you choose for your MRE repository.
Was it Oracle?
or what?
If you have no idea what i'm talking about, then you might want to ask whoever installed MRE.
If, say, you chose Oracle, there will be master files for oracle tables that you can read directly, join them up however you want. its very nice.
find out what type of repos you have, and get back to us...

Thanks to all who responded.

Francis Mariani's response prodded me to look at an earlier post on Focal Point. That discussion pointed me to the Managed Reporting Extract Utility covered in Chapter 10 of the WF Managed Reporting Administrator's Manual (as noted by GinnyJakes as well).

The Data Extract worked exactly as described and I think I've got all the information I need about my users, groups and domains.

Thanks again!

. . .Dan