BOBJ BI4.2 User List and Group Extraction (via SPA)

Hello all,

I want to make a dedicated topic for this little tool that I have developed, coming from this post BOXI UserList & Group Extraction. It’s not a download, but as it can replace a previous tool coming from the downloads I think it deserve it 's own topic :wink:

Introduction

I have created a very simple SPA (Single Page Application) powered by React.js that consume BOBJ REST api. It is designed to extract the complete list of users and groups, I have tested it for systems with around 5,000 users.

How to use it

Go to this application:

Provide your BOBJ dns (where your REST api is hosted, it is just adding :6405/biprws to generate the API endpoint), your BOBJ user and your BOBJ password (currently it work only using Enterprise authentication)

Then click on Connect. It will call the right endpoint directly from your computer (no BOBJ data is sent over internet), and populate the user and group table below.

Then you can use the extracted data within any tool you want (copy paste to Excel for example).

Motivation ?

I have created by the past a similar tool (BOXI UserList & Group Extraction) based on Microsoft Excel, using VBA to consume BOBJ API. Today I do not have anymore Office on my laptop but still working with BOBJ, and I have some skills in frontend development using React.js. It’s an opportunity to test such application that does not rely on any backend (except your BOBJ REST API) :wink:

Questions ?

Let me know in this thread if this tool have helped you, if you have any issue with it. Thanks for your feedback, I will look forward to enhance it !

  • BOBJ version: The tool have been tested on BI4.2 SP7 and SP8. I think it work starting from BI4.2 SP0.
  • Tracker: A Google Analytics tracker is installed to let me know how many user have used the tool, and how many fail/success login it generate. The tracker does not not track any BOBJ related information (system, user, password, user or group extracted)
  • Source Code: I will release the source code once no major issue were detected. It will be available on the github platform, under an opensource license.

Versions

Version Date Comments
1.0 2020-11-28 Initial release. Provide a tool to list users and groups.
1 Like

Hi Julien,
i’ve tested your tool, it works fine.
Thanks for sharing it, and Ihope the sorce will be available soon.

Karoly

1 Like

Thanks, It worked with my system and I got total: 5,939 items that’s correct. I would love to download it. so that I can run on production server 4.2 SP06.

1 Like