topic Displaying server instance and server name for failed database connects in Open Q&A

Displaying server instance and server name for failed database connects

leonatay — Mon, 19 Jun 2023 08:49:20 GMT

Hi community,

Has anyone tried to configure alerting profile so that the server instance and server host name for failed database connects can be shown? because for now only the database service name is displayed.

Is this even possible?

Thanks.

Sincerely,

Leona

Re: Displaying server instance and server name for failed database connects

andre_f — Fri, 11 Nov 2022 11:48:56 GMT

Hi @leonatay,

I haven't done it for the problems (page), but for notifications I have created such a solution. This means that the host name also appears in the problem notification for a database problem. I used auto tags for the process group instances with the hostname they are running on (via entity selector).
Do not know if this can help.

Re: Displaying server instance and server name for failed database connects

kalle_lahtinen — Fri, 11 Nov 2022 14:10:06 GMT

If you need it visible on that problem screen, I guess you'd need a service naming rule? Something like:

{Service:DatabaseHostName} - {Service:DatabaseName}

(or however you'd like to display it)

Then add conditions Service type = Database and Database host name must exist.