Extract the Ips of postgres DBs monitored via jdbc_reponse and MCS

Products

• DX Unified Infrastructure Management (Nimsoft / UIM)

Issue/Introduction

We are monitoring Monitor postgreSQL databases with MCS in DX UIM as per Monitor postgreSQL databases with MCS in DX UIM

As we are monitoring several DB from MCS from a single locations, we would like to extract the IPs / hostnames of the monitored DBs.

How can we obtain this information from the DB? What tables should we look into? 

Environment

DX UIM 20.4.* / 23.4.*

Cause

Guidance

Resolution

You can build a query using the hints below. 

This information can be obtained by joining 3 different MCS Related tables: 

 

1. First check the template id for the given probe: for example jdbc_response

select * from SSRV2Template where probe = 'jdbc_response'

 

2. Then with this information create a Join query with: 

SSRV2ConfigValue where variable = 'hostname'

and 

SSRv2profile where template = '<template_id_correspndent_to_jdbc_response>'

in this output the "cfgkey" for the variable 'hostname' will will contain the IP address of the monitored hostname.