Email Alerting on all Monitored Production Services

Question

We are setting up to monitor all selected Services in some of our production servers we need email alerts about. (Example: Email if DNS, DHCP, Active Directory Services Service goes down). I have the Alert setup and am working on the alert actions. I need an email template that basically states: Alert: (Whatever service it is) Service on (Whatever production server by hostname) is DOWN NODE DETAILS URL My problem is I have all of it working EXCEPT the Service part. So if I want to say the DNS service on the DNS server is off/down or anything but up I cant find the variable for it. It seems that it would be the ${N=SwisEntity;M=ComponentAlert.ComponentName} but that doesn't seem to retrieve the actual 'Service Name' If hope that explains it well enough to understand.

mesverrum · Answer

Rename the component monitor to match the service name.

The fields inside the component setup are not available as email variables because they are different for all the 49 types of built in components.  You can dig them out of you REALLY need to using custom SQL but most people aren't that familiar with the database and it gets complex because you end up having to do a lot of cases and isnull's and such to deal with the fact that those properties vary so widely in terms of what's available and where they are in the database.

The db table where this stuff all lives is ComponentSettings... except when it isnt there then its on ComponentTemplateSettings... except when its not there and it can sometimes be on ApplicationsSettings, or ApplicationTemplateSettings, or in the cases of a few monitor types they have dedicated tables of their own.  Hopefully that kind of explains why its a pain.

eric4381 · Answer

I am looking more at something like this. I can specifically set the services I want to monitor but the email trigger is where I am stuck. I cant seem to figure out how to show the %Service Name% in said email.