topic Extract TAG values from hosts tags in DQL in DQL

Extract TAG values from hosts tags in DQL

DavidePiras — Mon, 26 Jun 2023 20:24:13 GMT

I am querying the list of hosts in our environment, i would need to also filter by presence of a tag and to see the tag name and value in a column of the resulting table,

I am using this query to start with:

fetch dt.entity.host
| fieldsAdd entity.type, tags
| filter matchesPhrase(tags,"Business Segment")

the fact is that Business Segment tag can have multiple values, like Sales, IT, Finance, and each hosts has may tags and what i need is to extract the value of the Business Segment tag into a separated column, to see a grid showing only IT, Finance or Sales in a column, after the host name and the host id,

how can I do this?

Thanks,

Davide

Re: Extract TAG values from hosts tags in DQL

sinisa_zubic — Mon, 26 Jun 2023 20:44:39 GMT

Hi @DavidePiras

the field tags is an array of multiple tags. You need to use the expand command to expand it and then parse the key value information from the tag itself.

The parsing looks a bit complex, but it is already optimized for some edge cases I have observed so far.

Best,
Sini

Re: Extract TAG values from hosts tags in DQL

DavidePiras — Mon, 26 Jun 2023 21:02:22 GMT

Amazing, thank you so much for the hint, this is my adapted final query and works quite well, appreciated your prompt answer Sinisa!

Re: Extract TAG values from hosts tags in DQL

SaiK — Mon, 02 Sep 2024 14:37:53 GMT

Hello, I believe this is quite old comment but I am new to Dynatrace and was wondering if there are any documentation/guide available to help me understand the parsing command better that was used in the query here, thank you.