Hi @Mizső,
I have multiple use cases for OS service monitoring, especially for Windows OS, and one of the important use cases is related to the MSSQL service monitoring on multiple servers, which in my case should be up and running all the time.
so I have configured it for the MSSQL services with the alerting condition if the service status is not in a running state same as the following screenshot
also, I have added all configured OS services in a dashboard using the below query in Data Explorer with Honeycomb and enabled show labels to get the availability percentage, hostname, and service name.
Note: you can change the status based on the configured status in your case
(builtin:osservice.availability:filter(prefix(“dt.entity.os:service”,CUSTOM_DEVICE-)):filter(or(eq(“dt.osservice.status”,running),eq(“dt.osservice.status”,active))):sum:auto:sort(value(sum,descending)):splitBy(“dt.entity.host”,“dt.entity.os:service”)/builtin:osservice.availability:filter(prefix(“dt.entity.os:service”,CUSTOM_DEVICE-)):sum:auto:sort(value(sum, descending)):splitBy(“dt.entity.host”,“dt.entity.os:service”)*100):setUnit(Percent):splitBy(“dt.entity.host”,“dt.entity.os:service”):sort(value(auto,ascending)):limit(100)
Best regards,
Mohamed
@Mohamed_Hamdy Thanks for providing this use case as well as query.
Hi @Mizső ,
In out use case, customer asked to monitor all Windows OS services that are marked to be in running mode and are not running on server that is using OA in infrastructure mode.
HTH
Yos
Hi,
Within some of my clients, we monitor essential services like backup software, antivirus software, and endpoint security software. Moreover, for Windows Servers we monitor services like SQL Server, IIS, and Windows Defender.
| Display Name | Service Name |
|---|---|
| SQL Server | MSSQLSERVER |
| Windows Defender | WinDefend |
| IIS (Internet Information Services) | W3SVC |
Sia
Hi Mohamed
How do we configure OS Service Monitoring alerts goes to specific workgroup. for all MSSQL OS Service monitoring to be sent to different assignment group.
Hi @sundarv1 ,
You have a couple of options to consider. First, you can enable the alert option under OS services monitoring and specify the criteria and message. By default, this will generate a problem under availability. You can create an alerting profile and set up problem notifications for a specific group.
The second option is to create a metric event for more customization, followed by an alerting profile and problem notification.
Let me know if you need further assistance!
Mohammed - How do we create Metric event for Specific OS Service?.
you can use Data Explorer then click on … and add a metric event, same as the screenshot below, i have used the below query as a sample in the global demo environment, of course, you can use different one
(builtin:osservice.availability:filter(and(or(eq(“dt.osservice.name”,“apl-easytravel”)))):filter(or(eq(“dt.osservice.status”,running),eq(“dt.osservice.status”,active))):sum:auto:sort(value(sum,descending)):splitBy(“dt.entity.host”,“dt.entity.os:service”)/builtin:osservice.availability:filter(and(or(eq(“dt.osservice.name”,“apl-easytravel”)))):sum:auto:sort(value(sum, descending)):splitBy(“dt.entity.host”,“dt.entity.os:service”)*100):setUnit(Percent):splitBy(“dt.entity.host”,“dt.entity.os:service”):sort(value(auto,ascending)):limit(100)
Hi Mohammed
if we create metric event, how to do exclude the OS services which we don’t want to monitor. Please suggest.
Hi @sundarv1 , If I understand your question correctly, as long as you’ve created this metric using the metric selector for the OS services you need to cover, you don’t need to worry about the other OS services.
if you are asking to switch of the os service monitor or enable/disable monitor or alert for the OS services you can do that directly from the os service monitoring settings as per the below screenshot
Hi Mohammed
we need to create this metric selector, before that i want to check how do avoid other services which we don’t monitor. we have 50 services running in the server and we want to not be alert permanently if few services are not running
Hi @sundarv1 , just to get a clear understanding, you currently have 50 OS services configured for monitoring with Dynatrace. I assume you are using a single OS service monitor for all these services; is that correct?
based on how it was configured, You can check this under Settings → Monitoring → OS Services Monitoring. or you can check under the host directly if it was configured under the host settings
If you don’t need to monitor some of the other OS services, consider reconfiguring or creating a separate OS service monitor for those that require coverage only
currently we have done in the above way. only challenge if we do with this way, all the alerts are going to default profile and coming as availability event.
we want to configure this metric event so this can be as resource event.
