Does anyone know of a way to query the User Administration tables for reporting on Security Group membership and privileges?

Check out the mrextract utility, documented in the Admin manual. This utility will extract all the repository info into flat files that can then be reported from.

Greetings,

The Managed Reporting Extract Utility is documented in Chapter 10 of the WebFOCUS Managed Reporting Administration Manual.

Version 5.3: DN4500584.0904
Version 7.1: DN4500690.0505
Version 7.1.3: DN4500690.0206
Version 7.6: DN4500809.1006

You can view and/or download this manual from the i-Base: The Technical Documentation Library.

If you have an InfoResponse ID, log on to the Tech Support Web site and then access i-Base. By logging in first, you can download the PDF file and/or view the HTMLHelp version.

You can access i-Base via the following Web sites:

• http://techsupport.informationbuilders.com
  (From the top navigation bar, click Publications. Then select i-Base: Tech Doc Library.)
  
• www.informationbuilders.com
  (From the top navigation bar, click Services & Support. Then select Documentation.)
  
• www.iwaysoftware.com
  (From the top navigation bar, click Services & Support. Then select Bookstore.)
  

Hope this helps.

Regards,
Jennifer