using startsWith in entity selector

leonatay — Fri, 11 Nov 2022 09:19:42 GMT

Hi community,

I want to configure a tag that selects mssql db instance and EXCLUDES db instances from specific server instance beginning with certain alphabets (for custom alerting purposes). In attribute seems like there is no startswith() option.

Have anyone have experience regarding this?

For now my entity selector looked like this:

type(dt.entity.sql:sql_server_database), not(Device("VCENxxx"))

which i keyed in the full name of the device.

Was wondering if I can have a startswith option.

Thank you.

Sincerely,

Leona

Re: using startsWith in entity selector

Ingrida — Fri, 11 Nov 2022 17:35:37 GMT

Hi Leona,

At least on our cluster (Dynatrace Managed, 1.248) we do not have entity type "dt.entity.sql:sql_server_database". Are your sure you do?

We actually work quite a lot with entitySelector for Management Zone definition (f.e. include all queues or all databases which are related to services from this management zone) or for custom tagging (tag all services which run on process group with these tags and entity name which starts with this and contains that). And it works. Example:

type(SERVICE),serviceType(DATABASE_SERVICE),softwareTechnologies(MICROSOFT_SQL_SERVER),not(entityName.startsWith("EV"))

Asks all services which are MS SQL databases and name does not starts with EV. Output:

{ "totalCount": 155, "pageSize": 200, "entities": [ { "entityId": "SERVICE-076BDC9E1A05DB5A", "type": "SERVICE", "displayName": "SpiraTest", "properties": { "softwareTechnologies": [ { "type": "MICROSOFT_SQL_SERVER" }, { "type": "DOTNET", "edition": ".NET Framework", "version": "4.6.2.0" } ] } }, ...

(we do not have mysql oon the system...)

Regards,

Ingrida

topic using startsWith in entity selector in Open Q&A

using startsWith in entity selector

Re: using startsWith in entity selector