topic Add databases automatically in a management zone based on relationship in Open Q&A

Add databases automatically in a management zone based on relationship

AurelienGravier — Wed, 22 Mar 2023 07:03:21 GMT

Hello,

My host group (or my namespaces in k8S env) contains app_env information and I use them to create 2 distinguished tags "app:xxx" and "env:xxx" on hosts, process and services side.
Afterward, I create management zones and I use an entity selector as condition to add databases automatically based on origin calls service tags values like below :

type(SERVICE),databaseName.exists(),toRelationships.calls(type(SERVICE),tag("env:prod","app:app"))

It almost works ! The problem is the logical condition between tags is a OR condition as indicated here :

https://www.dynatrace.com/support/help/dynatrace-api/environment-api/entity-v2/entity-selector#tag

"An entity with any of the specified tags is included to the response."

I could use only one tag env:app-prod on my services, process, and host but I want to know if you have other ideas.

Thank you.
Regards.

Re: Add databases automatically in a management zone based on relationship

uros_djukic1 — Thu, 23 Mar 2023 07:40:17 GMT

Hi Aurelien,
You can try to use this kind of MetricSelector expression based on HostGroup instead of tag (restrictive indeed) :
Case 1 : several host group
type(service),databaseName.exists(),toRelationships.calls(
type(service),fromRelationships.runsOnHost(
type(host),fromRelationships.isInstanceOf(type(HOST_GROUP),entityName.in("env1, env2, ...")
Case 2 : one host group
entityName.contains("env1")

Why make your life difficult? 😄
Can you test it ?
I hope it helps.
Thanks

Re: Add databases automatically in a management zone based on relationship

AurelienGravier — Wed, 22 Mar 2023 15:51:26 GMT

Hello @uros_djukic1

It's brilliant thank you, it works great :

type(service),databaseName.exists(),toRelationships.calls(type(service),fromRelationships.runsOnHost(type(host),fromRelationships.isInstanceOf(type(HOST_GROUP),entityName.contains("app1-prod"))))

Do you have an equivalent for kubernetes based on kubernetes namespace value ?

Because, I can do it with the entity selector below but only egal and exist are available (I would like contains) :

type(service),databaseName.exists(),toRelationships.calls(type(service),fromRelationships.runsOn(type(process_group),metadata("KUBERNETES_NAMESPACE:gp-sales-app1-prod")))

https://www.dynatrace.com/support/help/shortlink/api-entities-v2-selector#attribute

Thank you very much

Re: Add databases automatically in a management zone based on relationship

uros_djukic1 — Thu, 23 Mar 2023 10:45:29 GMT

For Kubernete try this :
type(service),databaseName.exists(),toRelationships.calls(type(~"SERVICE~"),fromRelationship.runsOn(type(PROCESS_GROUP),toRelationship.isNamespaceOfPg(type(~"CLOUD_APPLICATION_NAMESPACE~"),entityName.contains(~"app1-prod~"))))

My MetricExpression :
builtin:service.requestCount.server:filter(and(or(in("dt.entity.service",entitySelector("type(service),toRelationships.calls(type(~"SERVICE~"),fromRelationship.runsOn(type(PROCESS_GROUP),toRelationship.isNamespaceOfPg(type(~"CLOUD_APPLICATION_NAMESPACE~"),entityName.contains(~"online~"))))"))))):splitBy("dt.entity.service"):sort(value(auto,descending)):limit(20)

Result :

Re: Add databases automatically in a management zone based on relationship

AurelienGravier — Thu, 23 Mar 2023 11:31:20 GMT

You rock @uros_djukic1 ! It's perfect for my need, thank you very much.

Re: Add databases automatically in a management zone based on relationship

paolo_fumanelli — Tue, 10 Oct 2023 14:08:25 GMT

Hi Aurelien, the purposed solution works, by the way if you want to apply an AND in service filter, you can do as follows:

type(SERVICE),databaseName.exists(),toRelationships.calls(type(SERVICE),tag("env:prod"),tag("app:app"))

Re: Add databases automatically in a management zone based on relationship

AurelienGravier — Wed, 11 Oct 2023 07:50:03 GMT

Hello @paolo_fumanelli ,

You will make my day better, so simple solution to manage tags on entity selector, I tried it on service entity only :

OR LOGICAL between tags values :

type(SERVICE),tag("env:prod","app:myappname")

LOGICAL AND between tags values :

type(SERVICE),tag("env:prod"),tag("app:myappname")

Thank you. Regards

Re: Add databases automatically in a management zone based on relationship

paolo_fumanelli — Wed, 11 Oct 2023 08:07:22 GMT

Sure, that works for any entitySelector. All provided criteria (separated by comma) must be fullfilled (AND logic), while when providing more that one value in the same criteria (if the criteria accepts this), OR logic is applied.

Glad to have helped you