Skip to Content

Being an SAP Business Intelligence Administrator, many of us must have come across a requirement where the user details and its respective group details were required.

As a part of admin activities we always perform user review activity on quarterly basis for all of our SAP Business Intelligence/Objects servers.

I have always tried my best to get the user details from SAP Business Objects repository, however did not find any easiest way to do so. Query Builder queries are useful for getting such details but need more manual work.

I have heard that SAP Business Intelligence 4.2 SP03 onward, SAP has given an option for administrators so that we can get some specific details from the SAP Business Objects repository.

We have not migrated our clients to SAP Business Intelligence 4.2 version yet, so this would be useful for us only in the foreseeable future.

So finally I have taken the initiative for creating an utility which will fetch the user group details from the SAP Business Objects 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.1 version.

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           (This file will fetch 50000 users)

Step 2: Copy this utility to the local folder on your system.

Step 3: Open the command prompt and run the following command.

Command:
java.exe –jar jarfilename BOServerIP Userid Password

Points to note for running the above command:

1. Replace “jarfilename” with the name of this utility.
2. Provide the IP address for SAP Business Objects server(BOServerIP).
3. Provide the Username/Password to login to SAP Business Objects server(Userid/Password).
4. This utility will only work with enterprise authentication since I have hard coded it in the source code.
5. Output will be generated in an excel file and the file will be generated at the same location from where you will run this utility.
6. Once the file is generated you will get the path of this file in command prompt itself. File name would be “Details.xlsx”
7. This utility was compiled with JAVA 8 so please ensure you have JAVA 8 installed on the system from where you will run it.
8. Please ensure that you use enterprise administrator user only to run it.

Step 4: 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)

This utility is tested with SAP Business Intelligence 4.1 and Business Intelligence 4.2 versions only. I am going to develop the same utility for SAP Business Objects 3.1 version as well and will share it soon.

Please use this utility and share your views.

Thanks,
Swapnil Yavalkar

To report this post you need to login first.

26 Comments

You must be Logged on to comment or reply to a post.

  1. Swapnil Yavalkar Post author

    Hi All,

    If any user belongs to multiple groups then the output will be generated in the comma separated format in the excel file e.g. Everyone, Administrator and so on.

    Regards,
    Swapnil Y
     

    (0) 
  2. Swapnil Yavalkar Post author

    Hi Arpan,

    Setting a classpath variable is a one time activity and can be used multiple times without creating it again and again. Make sure you create this variable under system variables only.

    Regards,
    Swapnil Yavalkar

    (0) 
  3. Swapnil Yavalkar Post author

    Hi All,

    Here is the new version of this utility which does not require any classpath to be set. You can directly use it using the below command.

    Download File

    Command:

    java.exe –jar jarfilename BOServerIP Userid password

    Output will be generated in the excel file as mentioned above and the file will be generated at the same location from where you will run this utility. Once the file is generated you will get the path of this file in command prompt itself.

    Regards,
    Swapnil Y

     

    (0) 
    1. Arpan Gupta

      Hi Swapnil,

      Thanks a lot for this. The utility is working smoothly now.

      But I have around 1200+ users in BO server and the excel file which is generated has only 115 users in it. Is there anything which I need to pass in
      command
      “java.exe –jar jarfilename BOServerIP Userid password”

      Thanks in advance,
      Arpan

      (0) 
      1. Swapnil Yavalkar Post author

        Hi Arpan,

        You have used the correct command to run this utility. I would like to know whether you have killed this command before getting the message that “Excel file written successfully at pathoffile” or not. If so then please run it again and wait until you get this message in the command prompt.

        I am also testing this utility on one of our servers where we have 900 + users, will let you know the results.

        As of now it is running and I can see that it is fetching all the details from the CMS database, however it is going to take more time to write the output in the excel file.

        I will let you know once the excel file is generated.

        Regards,
        Swapnil Yavalkar
         

        (0) 
        1. Arpan Gupta

          Hi Swapnil,

          I got the message “Excel written successfully” but I have only 115 user’s list in Excel while in server there are 1200+ users.

          Regards,
          Arpan

          (0) 
          1. Swapnil Yavalkar Post author

            Hi Arpan,

            I have tested it in the eclipse and it has given me an excel file which has exact number of users as of our BO server i.e. 917.

            Now, I am testing it using the command line. Will let you know the outcome.

            Meanwhile, could you please share 4-5 rows of the excel file generated for you? Let me check the output. Please hide any confidential information while sharing it.

            Regards,
            Swapnil Yavalkar
             

            (0) 
            1. Swapnil Yavalkar Post author

              Hi Arpan,

              This worked for me through command line as well.

              Please ensure that

              1. You are using the enterprise administrator user only.
              2. What is the exact version of your BI4.1 server.
              3. Did you try this with any other server?
              4. Try to run this utility from any other drive except C drive.

              Do let me know your observations.

              Regards,
              Swapnil Yavalkar
               

              (0) 
              1. Arpan Gupta

                Thanks Swapnil,

                It seems some authorization / group policy related issue which has been corrected now.

                BUT I have 1287 users on BO server and the excel file is producing only 1000 users. I guess if you are using “Select *” somewhere you may need to replace it by “Select TOP 5000” (example).
                This is something same when we use “Select * ” in Query builder it used to give only 1000 records.
                Like if I use “SELECT * si_name,SI_USERFULLNAME FROM CI_SYSTEMOBJECTS WHERE SI_KIND=’USER‘” It gives only 1000 users But if I use Select TOP 5000, It gives exact 1287 user’s details.

                Regards,
                Arpan

                (0) 
                1. Swapnil Yavalkar Post author

                  Hi Arpan,

                  Good catch 🙂 , I actually developed this utility for our servers where we do not have more than 1000 users, hence could not think about this scenario.

                  I have updated the new JAR file in the above post which has the query with “TOP 50000” users.

                  ~Swapnil Yavalkar
                   

                  (0) 
                  1. Arpan Gupta

                    Hi Swapnil,

                    I just downloaded the jar again and executed it with

                    command
                    “java.exe –jar jarfilename BOServerIP Userid password”

                    But it still throws 1000 users only :(. I think the jar file is not the updated one. Could you please check it once?

                    Regards,
                    Arpan

                    (0) 
                    1. Swapnil Yavalkar Post author

                      Hi Arpan,

                      I have updated the new version V3 in the main post, you can also download it here.

                      There was another query in the source code which gets group details, I had not updated it with “TOP 50000” this is why it must have not worked for you. Try it now.

                      ~Swapnil Yavalkar

                      (0) 
            2. Arpan Gupta

              Thanks Swapnil,

              Here is the screenshot for first 9 rows.

              I tried once again but it still generated a list of 115 users.

              Please let me know If you want any further info from my side to carry  your analysis.

              Regards,
              Arpan

              (0) 
              1. Swapnil Yavalkar Post author

                Hi Arpan,

                Output is looking fine as expected.
                Please ensure that

                1. You are using the enterprise administrator user only.
                2. What is the exact version of your BI4.1 server.
                3. Did you try this with any other BI server?
                4. Try to run this utility from any other drive except C drive.

                I have not mentioned any limit on the excel rows and output of this program, it should work for you. Please try above points and let me know the outcome.

                Regards,
                Swapnil Yavalkar
                 

                (0) 
    1. Swapnil Yavalkar Post author

      Hi Santhosh,

      Could you please confirm the size of ZIP file you have downloaded? If it is less than 10 KB then you have downloaded the JAR file which will need the classpath variable to be set on your system.

      Download it from here. This file would not need any classpath variable.

      Please ensure that you are running this command from the same folder where you have copied this utility.

      ~Swapnil Yavalkar

      (0) 

Leave a Reply