topic Database service exclusions in Dashboarding

Database service exclusions

mahender — Mon, 30 Dec 2024 08:26:55 GMT

Hi,

How to exclude Database services In Dashboard Gen3, (Entity Type : Services) we are facing the issues regarding the untagged names for Database services, so we want to exclude those database services.

Re: Database service exclusions

sia_h — Tue, 24 Dec 2024 22:54:29 GMT

Timeseries:

timeseries avg(dt.service.request.response_time), by: { dt.entity.service } | fieldsAdd serviceType = entityAttr(dt.entity.service, "serviceType") | filter not serviceType == "DATABASE_SERVICE" | fieldsAdd dt.entity.service.name = entityName(dt.entity.service) | fieldsAdd value.A = arrayAvg(`avg(dt.service.request.response_time)`)

Fetch:

fetch dt.entity.service | fields entity.name, serviceType | filter not serviceType == "DATABASE_SERVICE"

Re: Database service exclusions

Peter_Youssef — Wed, 25 Dec 2024 07:08:08 GMT

Appreciated suggestion @sia_h

Re: Database service exclusions

mahender — Fri, 27 Dec 2024 15:04:52 GMT

Thank you @sia_h will try and get back to you on this

Re: Database service exclusions

mahender — Mon, 30 Dec 2024 17:16:34 GMT

@Peter_Youssef
we are not using the DQL to Filter the service type.

import { monitoredEntitiesClient } from "@dynatrace-sdk/client-classic-environment-v2"

our code is based out on SDK we will be using above library to fetch the details.