The following SQL query would return the Repeater health status from hmv_tx_summary ISM table for all the repeaters in your BBCA Infrastructure.
select mac_host as 'Server Name',
'Repeater' as 'Type',
mac_ipaddress as 'IP Address',
network_ip as 'Site',
round(100*(vm_heap_total-vm_heap_available)/vm_heap_total,2) as 'Memory Usage',
Stats_last_changed as 'Last Reporting Date',
round(100*(total_diskspace-available_diskspace)/total_diskspace,2) as 'Disk Usage',
overall_last_replication as 'Last Replication Success',
overall_last_replication_time as 'Last Replication Time' ,
metrix_requests_per_minute as 'Requests Per Minute'
from hmv_tx_summary where type_id ='3'
Note: Please confirm that the user account running the query has select permissions on hmv_tx_summary table of INVDB as by default the access would be restricted to hmuser and hmadmin accounts.