How To Fetch User Group Details From SAP Business Objects 3.1 Servers.

After publishing an utility for SAP Business Intelligence/Objects 4.1/4.2 Servers, I have created another utility which can be used with SAP Business Objects 3.1 version.

This time I have included the dependent libraries in the JAR file itself. Since the JAR file already has the dependent libraries it can be used without setting a CLASSPATH variable.

Output of this JAR would be same as of SAP BI4.1 utility and the generated excel format would also be the same.

This utility will fetch the user and group details from the SAP Business Objects repository and will provide the output in the excel format.

In order to use this utility with your SAP Business Objects servers, please follow the steps below.

Step 1: Download the zip file from the below link and extract it. It has the JAR file.

DownloadZip

Step 2: Copy this utility to any folder where you will run it.

Step 3: Open the command prompt and go to the same directory where you have saved this utility in above step.

Step 4: Now, run the following command.

Command:
Java.exe -jar UserDetailsSAPBO31.jar 10.X.X.X administrator “Password” “F:\JavaOutput\BO31\UserDetails.xlsx

Points to note for running the above command:
1. 10.X.X.X is the IP address of the SAP Business Objects Server.
2. Provide the Username/Password to login to SAP Business Objects server.
3. Password should be in double quotes.
4. Provide the file name along with the extension of excel file in double quotes.
5. File name and Path can be anything.
6. This utility will only work with enterprise authentication since I have hard coded it in the source code.

Step 5: Generated excel file would be in the below format.

Generated excel file will have columns as below.
1) User ID
2) Full Name
3) Email Address
4) Status (Enabled or Disabled)
5) Last Logon Time
6) Creation Time
7) License Type (Named User License Or Concurrent Access License)
8) Group Details (This will have information about all the groups where the respective user belongs. If any user is a part of multiple groups then the output will be in comma separated format such Everyone, Administrators and so on)

Please use this utility and share your views.

Thanks,
Swapnil Yavalkar