Collector Information in PostgreSQL

[Imran Ali Khan]

Hi Team

 

How can we extract the number of collectors connected to the MOM through the postgreSQL database.

In which table the number of collectors is stored in the database.

 

Regards

Imran

[Hallett German]

Dear Imran: 

Are you looking for a metric or a specific list of Collectors? 

    If you have CEM, the ts_entity table shows all EMs that can be used to host the three CEM services. Cluster metrics are listed in Cluster Supportability Metrics - CA Application Performance Management - 10.7 - CA Technologies Documentation 

 

Dear Community:

Please add your thoughts on this

 

Thanks

Hal German

[Imran Ali Khan]

Hi Hallett_German

I wanted to know that in postgreSQL in which table can I find the information about the number of collectors connected to MOM.

I wanted to extract this information from the postgreSQL database.

 

Thanks

[Sergio Morales Correa]

Hello Imran,

 

EMs info are stored in the vertices table, you can run a query like this for example, in my test lab it give it the # of collectors

 

SELECT count(*) FROM APPMAP_VERTICES WHERE gathered_attribs LIKE '%EM_COLLECTOR%' AND gathered_attribs LIKE '%Custom Metric Host%'

 

but the recommended way would to be use APM RES API or APMSQL REST API, unfortunately, I don't have any example at the moment, here are the references from docops:

 

Vertex - CA Application Performance Management - 10.7 - CA Technologies Documentation 

SQL REST API - CA Application Performance Management - 10.7 - CA Technologies Documentation 

 

Collector information is also available as EM sustainability  metrics under the MOM:

 

Custom Metric Host (virtual)
- Custom Metric Process (virtual)
- Custom Metric Agent (virtual) (*SuperDomain)
- Enterprise Manager | MOM

 

See CA APM Performance Monitoring Using Supportability Metrics - CA Application Performance Management - 10.7 - CA Technolog… 

 

I hope this helps,

 

Sergio