List obiee users

MarkDeJ

Hi,

I was wondering if it is possible to list all obiee users (users from weblogic console) in a table to display on a dashboard?

Or to extract the users and put them in a database table so we can use them on dashboards.

And how do i manage to do this?

Thanks in advance,

Mark

Satya Ranki Reddy

Enable usage tracking , You will get all obiee users lists and you can build dashboard.

Setting up Usage Tracking in Oracle BI 11g

Follow above link to enable.

Thanks,

Satya Ranki Reddy

Gianni Ceresa

Hi,

Usage tracking as suggested by Satya Ranki Reddy is an option if all your users connected at least once or they don't exist in usage tracking.

If your users are stored in the embedded Weblogic LDAP you can access and query it like any other LDAP server, Publisher can use it as source but not OBIEE itself. In that case you would need to extract the list of uses and load it somewhere.

If your users are stored into an external source (LDAP , Active Directory etc.) you better setup an extract on that directly ...

There is probably also a way to get the list by WLST, but never explored that side...

rmoff

For embedded LDAP, there is the listUsers MBean, see example here: http://docs.oracle.com/middleware/1221/wls/WLSTG/config_wls.htm#WLSTG212

MarkDeJ

Thanks for the suggestions Gianni and Robin, I'll explore the suggestions.

Regards,