Hi All,
I have developed an utility which will fetch the user group details from the SAP Business Intelligence 4.2 repository and will provide the output in the excel format.
I have developed this utility using the JAVA SDKs which uses the libraries of SAP Business Intelligence 4.2 SP06 version.
In order to use this utility with your SAP Business Intelligence servers, please follow the steps below.
Step 1: Download the zipped file and extract it.
Note: it has 1 folder “UserDetails_lib” and 1 jar file “UserDetails.jar”, both are needed in the same folder to run this program.
Step 2: Open the command prompt and run the following command.
Command:
java.exe -jar UserDetails.jar BOServerIP UserID “Password”
Points to note for running the above command:
- Provide the IP address for SAP Business Objects server.
- Password should be in double quotes.
- This utility will only work with enterprise authentication since I have hard coded it in the source code.
- JAVA 8 is required to use this utility.
Step 3: Generated excel file would be in the below format.
[list]USER_ID
FULL_NAME
EMAIL_ADDRESS
STATUS
LAST_LOGON_TIME
LAST_PASSWORD_CHANGE_TIME
CREATION_TIME
LICENSE_TYPE
GROUP_DETAILS[/list]
This utility is successfully tested with SAP Business Intelligence 4.2 SP06.
Please use this utility and share your views.
Download File:
Thanks,
Swapnil Yavalkar
Swapnil_Yavalkar (BOB member since 2012-03-15)