Absent Member.. Absent Member..
Absent Member..

Need DB query to get all information related to BPM agents

db query to get BPm agent hostname, ip address, number of transaction, last ping time, version, location, webtraces, group from single query with respect to BPM agent from BSM database.


Need this data to get it in excel sheet. just need query to fetch the data.

2 Replies
Micro Focus Expert
Micro Focus Expert

Hello ,

The BSM management database contains this information, tables starting with EUMBPM* will probably contain all you need as indicated in this BSM 9.x Database Schema article. However, it is highly recommended to explore these tables with the assistance of HP Support.


Premium Services
“If you find this or any post resolves your issue, please be sure to mark it as an accepted solution.”
Absent Member.. Absent Member..
Absent Member..

Hello all,

The main reason for not publishing the BSM database schema docs is that if the schema get published it becomes a "statement"  : a statement for our customers that it is ok to build echo systems around that document without considering that the BS schema may get changed in the future.
Making such a "statement" will be irresponsible from the HP side toward the customers as R&D tends to change the schema for future BSM releases.
The effect of DB schema publication versus HP's productivity/efficiency/agility, HP has decided to *NOT* publishing the BSM DB schema structure.
Best Regards
Juan Carlos Monge Granados
Support Engineer
San José, Costa Rica
Hewlett Packard

If you find that this or any other post resolves your issue, please be sure to mark it as an accepted solution.
If you are satisfied with anyone’s response please remember to give them a KUDOS by clicking on the STAR at the bottom left of the post and show your appreciation.
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.