Hi BPM Group.

If possible to have access to detailed information about BPMDB database tables and fields to make query's and get information about it, for example users and groups for reporting and consolidations of users information?

For example tables like:

LSW_USR
LSW_USR_XREF
LSW_USR_GRP_XREF
LSW_USR_GRP_MEM_XREF
LSW_GRP_GRP_MEM_XREF

Thanks In Advance

Hi Pablo,

There are no official documentation available of these tables as these are product internal. It's not recommended to directly access product internal tables via SQL queries. There are APIs available to retrieve user/group information, you should use those instead.

Hi Atanu, 

Thanks for your answer, you can give a reference to this API's please, some URL or documentation?

Thanks in advance

Hi Pablo,

Here is the documentation of the REST APIs - https://www.ibm.com/docs/en/baw/20.x?topic=apis-rest-interface-bpd-related-resources

You can test the REST APIs from - https://host:port/bpmrest-ui

JavaScript API reference - https://www.ibm.com/docs/en/baw/19.x?topic=apis-javascript-api-in-processes-service-flows