Database service exclusions

[mahender]

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.

[sia_h · Accepted solution]

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"

[Peter_Youssef]

Appreciated suggestion @sia_h 

[mahender]

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

[mahender]

@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.