cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

DQL query to have specific AWS tag available as value

aled
Newcomer

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

2 REPLIES 2

mark_bley
Dynatrace Champion
Dynatrace Champion

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
Newcomer

Works great! Thanks 🙂

Featured Posts