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.
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.
“If you find this or any post resolves your issue, please be sure to mark it as an accepted solution.”
San José, Costa Rica
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.