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
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.
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).
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)
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: Code is available here, under MIT license. Let me know if you re-use this work, I will be happy to share it here !
|2021-01-18||Released as open source|
|1.0||2020-11-28||Initial release. Provide a tool to list users and groups.|