DQL query to have specific AWS tag available as value

[aled]

In the old dashboard, I have a dynamic filter set on a specific AWS tag "Tag key: Custom device [AWS]environment"

I'm trying to replicate this behaviour in the new dashboards, using variables
However, using DQL I'm failing to write a query to extract the possible values for a specific tag

Here's where I am so far :

fetch `dt.entity.cloud‌‌sqs`
| fields tags

(not very far along as you can see)

My goal is to have a variable listing all existing values for my "environment" tag

[mark_bley · Accepted solution]

maybe this can help

fetch dt.entity.cloud‌‌sqs
| fields tags
| expand tags
| filter contains(tags, "[AWS]environment")
| parse tags, """LD ':' LD:value"""
| fieldsRemove tags
| sort value asc
| summarize environments = collectDistinct(value)

[aled]

Works great! Thanks 🙂