Need DB query to get all information related to BPM agents

[mu4037]

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.

[Tarif_L]

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.

HTH/Tarif  

[JuanC_Monge_AMP]

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