Categories
Extract User List in OBIEE

Hi All,
we have a requirement to get the list of users and their assigned groups/roles. After go through all blogs and sites finally, we found the script in below link.
And, addition of that we need to populate the Name of the user in the report. We are storing the name in Description field.
Try to help me to add the Description field in to the script and also, please let us know the path of the user list stored in the OBIEE environment.
Regards,
Arun
Answers
-
Based on the docs for the security service
https://docs.oracle.com/cd/E28280_01/bi.1111/e16364/methods.htm#BIEIT1159
The Name that you are storing in the description field in WLS is not available.
You should look at what services the WLS LDAP offers and see if you can adapt that.
Tim
0 -
Thanks for you quick reply Tim
In general, is there any file in the back end we can see the list of created user or currently available users ?
0 -
@3281755 Maybe. But in order to respond it would be helpful to know the version you are using.
0 -
OBIEE 11.1.1.7.1 version
0 -
The WLS-embedded LDAP writes .ldif files in that version. But you're not really supposed to touch those.
In any case your "requirement" isn't something that's really suggested as the embedded LDAP isn't supposed to be your main authenticator.
0 -
Once again Thank you Christian..!
Is it fine to check that file in test environments? if yes, please share me the path of the file(*.dif).
My intention is to reduce the manual work to check the active users along with groups/roles. The report which we need to share consists of Name, Description and groups/roles.
0 -
You could just employ some search skillz and do a find | grep combo to find the files.
0 -
My understanding is that you could 'export' the file(s) back to the OS, from the WebLogic Administration Console. For example, got to: Home >Summary of Security Realms >myrealm > Migration > Export. From there, you'd get a bunch of *.dat files in the path provided.
Alternatively, this could be simplified/automated (via WLST scripting), by "pulling" those files onto the OS from the command line. Take a look at Doc ID 1926820.1 for some ideas (also the linked product documentation). All you really need is DefaultAuthenticator.dat to get the data you are looking for. It is a text file that can be operated on/parsed by something, say like AWK to extract what you want. Take that, convert it to CSV (using SED to insert some commas), and you now have an "Excel" file.
Regards,
Charles
0 -
I checked the script in the given blog. As I don't have a good understanding of the given code, could you please let me know if I should make any other modification in the script other than adding the weblogic username and password?
0 -
@2709444 uuhhhh....yes? Just read and look at *words*?
*importData* --> Not really what you would use to export things. Charles said "for some ideas"! Never EVER just copy code and execute it without comprehending what it does! Read the documentation! https://docs.oracle.com/cd/E28280_01/web.1111/e13707/security_data_migration.htm#i1188426
Even if you don't understand the code at the moment it literally takes about 2 minutes to comrehend
0