topic Re: Is there any metrics which can show OS Services availability in %? in Open Q&A

Is there any metrics which can show OS Services availability in %?

sujit_k_singh — Tue, 24 Oct 2023 23:04:23 GMT

I was creating dashboard for OS Service availability but didnt find any metrics which can show availability in %. Please let me know if there a way to get it.

Thanks,

Tijust

Re: Is there any metrics which can show OS Services availability in %?

natanael_mendes — Wed, 25 Oct 2023 00:01:08 GMT

You can create a process availability in your environment, so you can define metrics about this.

Take a look on this documentation

https://www.dynatrace.com/support/help/platform-modules/infrastructure-monitoring/hosts/monitoring/process-availability

Re: Is there any metrics which can show OS Services availability in %?

sujit_k_singh — Wed, 25 Oct 2023 00:04:18 GMT

@natanael_mendes thanks for your message but i am already capturing all OS Services. My question to see availability in %. I have gone through same page but no luck in terms of %.

Re: Is there any metrics which can show OS Services availability in %?

natanael_mendes — Wed, 25 Oct 2023 00:05:50 GMT

You can make through data explorer, like in the image below

Re: Is there any metrics which can show OS Services availability in %?

sujit_k_singh — Wed, 25 Oct 2023 00:12:05 GMT

I am not talking about Process, I am talking about OS Service.

Re: Is there any metrics which can show OS Services availability in %?

natanael_mendes — Wed, 25 Oct 2023 00:28:41 GMT

process was just an example

Re: Is there any metrics which can show OS Services availability in %?

AntonPineiro — Wed, 25 Oct 2023 07:17:49 GMT

Hi,

You can check all OS Services metrics here.

I do not see that available. You can raise a product idea.

Best regards

Re: Is there any metrics which can show OS Services availability in %?

sujit_k_singh — Wed, 25 Oct 2023 10:27:21 GMT

@AntonPineiro make sencse. I will raise a product idea on this. Thanks for sharing the link.

Thanks

Tijust

Re: Is there any metrics which can show OS Services availability in %?

Mohamed_Hamdy — Wed, 25 Oct 2023 18:19:14 GMT

Hello @sujit_k_singh ,

you can open product idea as suggested by @AntonPineiro

also, you can use a workaround that might help you by using the advanced mode with entity selector and the following is a sample, as you know that each os service availability create custom device you can get the custom device id of the os service from the url after access it.

the following is a sample, by the way, you can create this automatically and then adjust it based on the configured status of the service (dt.osservice.status) you go to the os service on the host and pin it to a dashboard then reconfigure the data

(builtin:osservice.availability:filter(eq("dt.entity.os:service",CUSTOM_DEVICE-)):filter(or(eq("dt.osservice.status",running),eq("dt.osservice.status",active))):sum:auto:sort(value(sum,descending))/builtin:osservice.availability:filter(eq("dt.entity.os:service",CUSTOM_DEVICE-)):sum:auto:sort(value(sum,descending)):splitBy()*100):setUnit(Percent):splitBy("dt.entity.os:service")

for more details you can check the following link

https://www.dynatrace.com/support/help/shortlink/explorer-advanced-query-editor

Re: Is there any metrics which can show OS Services availability in %?

sujit_k_singh — Wed, 25 Oct 2023 22:23:50 GMT

@Mohamed_Hamdy Thanks for your reply, yes i was using similar advance query but bit different way.

Your query appears more accurate as it provides the result in percentage, unlike mine, which presented numbers without the '%' symbol. I appreciate your assistance. The only drawback with this approach is the need to go through each service individually, which is quite cumbersome, especially with over 200 services in my environment...

Thanks,

Tijust

Re: Is there any metrics which can show OS Services availability in %?

Mohamed_Hamdy — Thu, 26 Oct 2023 05:07:18 GMT

Hi @sujit_k_singh ,

you can use prefix instead of eq to list all the services same as the following sample, of course, you can adjust the whole query to get a correct result, I've just updated the option to replace eq() with prefix()

(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))/builtin:osservice.availability:filter(prefix("dt.entity.os:service",CUSTOM_DEVICE-)):sum:auto:sort(value(sum, descending)):splitBy()*100):setUnit(Percent):splitBy("dt.entity.os:service")

Re: Is there any metrics which can show OS Services availability in %?

sujit_k_singh — Thu, 26 Oct 2023 05:10:59 GMT

Hmm... but it doesn't give desired result ... if i go one by one os-service then it shows 100% but if i go for all then different

Re: Is there any metrics which can show OS Services availability in %?

Mohamed_Hamdy — Thu, 26 Oct 2023 05:23:27 GMT

Yes, i just added it as sample, but you can use the following one

(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.os:service")/builtin:osservice.availability:filter(prefix("dt.entity.os:service",CUSTOM_DEVICE-)):sum:auto:sort(value(sum, descending)):splitBy("dt.entity.os:service")*100):setUnit(Percent)

Re: Is there any metrics which can show OS Services availability in %?

Mohamed_Hamdy — Thu, 26 Oct 2023 05:24:51 GMT

Note: adjust it based on the dt.osservice.status you've configured for the OS services

Re: Is there any metrics which can show OS Services availability in %?

Mohamed_Hamdy — Thu, 26 Oct 2023 05:41:26 GMT

I've just added more details such as split by host as well, and sort by value ascending and adding limit

(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)

Re: Is there any metrics which can show OS Services availability in %?

sujit_k_singh — Thu, 26 Oct 2023 07:17:34 GMT

@Mohamed_Hamdy It worked perfectly now.. thank you so much for your help.