How do I create a postgres query as a metric from JBoss ON UI?

Solution Verified - Updated -

Issue

  • I was tring to add a postgreSQL query as a metric. Per https://access.redhat.com/site/documentation/en-US/JBoss_Operations_Network/3.1/html/Admin_Setting_up_Monitoring_Alerts_and_Operations/monitoring-and-events.html#postgres-query I was trying to make the query like:
 "SELECT 'name', count(id) FROM rhq_agent WHERE port =16163"
  • Here I am confused with count(id) what does the count mean?

Environment

  • Red Hat JBoss Operations Network (ON) 3.1.2

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.

Current Customers and Partners

Log in for full access

Log In