Displaying server instance and server name for failed database connects

[leonatay]

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

[andre_f]

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.

[kalle_lahtinen · Accepted solution]

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.